Spring Hibernate cluster env

Discussions

General J2EE: Spring Hibernate cluster env

  1. Spring Hibernate cluster env (3 messages)

    Hi, I am facing an issue with spring-Hibernate tomcat clustered env. server throws exception as below it happens only time to time otherwise app works fine .. do I need to do any special configuration for Hibernate to work on clustered env with dbcp datasource or am missing something else .... exception --------- SEVERE: Could not toggle autocommit java.sql.SQLException: Closed Connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207) at oracle.jdbc.driver.PhysicalConnection.setAutoCommit(PhysicalConnection.java:1028) at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:293) at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:174) at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:166) at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:142) at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:603) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:579) at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:556) at org.springframework.transaction.interceptor.TransactionAspectSupport.doCloseTransactionAfterThrowing(TransactionAspectSupport.java:284) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy14.getQuery(Unknown Source) Shoj.

    Threaded Messages (3)

  2. Re: Spring Hibernate cluster env[ Go to top ]

    The close method that needs to be called on shutdown can be registered via Spring's "destroy-method" attribute, to avoid the need for BasicDataSource to implement any Spring interface Bhagvan K http://www.jroller.com/page/bhagvank
  3. Re: Spring Hibernate cluster env[ Go to top ]

    Hi Bhagavan, I already have the destroy method mentioned here I am pasting the Datasource configaration in my applicationcontext.xml ${database.driver} ${database.url} ${database.user} ${database.password} ${database.initialSize} true true Thanks Shoj
  4. Re: Spring Hibernate cluster env[ Go to top ]

    Hii Any help on this matter ?? Shoj