Hi Tomcat Team,
Please help me out in solving below error.
Below is the details :
================Configuration in my context.xml============================
<Resource name="jdbc/ABC"
auth="Container"
type="javax.sql.DataSource"
maxActive="50"
maxIdle="10"
maxWait="10000"
username="ABC"
password="ABC"
removeAbandoned="true"
logAbandoned="true"
testOnBorrow="true"
testWhileIdle="true"
timeBetweenEvictionRunsMillis="30000"
validationQuery="SELECT 1 FROM dual"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@MY_DB" />
==========================Error Message
============================================
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:679)
Caused by: org.springframework.transaction.TransactionSystemException: Could
not roll back JPA transaction; nested exception is
javax.persistence.PersistenceException: unexpected error when rollbacking
at
org.springframework.orm.jpa.JpaTransactionManager.doRollback(JpaTransactionManager.java:486)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:800)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:777)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:339)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at sun.proxy.$Proxy185.selectPharmaUser(Unknown Source)
at
com.aptilon.axcelrx.server.service.impl.AuthenticationServiceImpl.login(AuthenticationServiceImpl.java:170)
at
com.aptilon.axcelrx.server.ws.endpoint.AuthenticationEndpoint.login_aroundBody0(AuthenticationEndpoint.java:110)
... 45 more
Caused by: javax.persistence.PersistenceException: unexpected error when
rollbacking
at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:88)
at
org.springframework.orm.jpa.JpaTransactionManager.doRollback(JpaTransactionManager.java:482)
... 54 more
Caused by: org.hibernate.exception.GenericJDBCException: Cannot release
connection
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at
org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:478)
at
org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:429)
at
org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:316)
at
org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:248)
at
org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:208)
at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:85)
... 55 more
Caused by: java.sql.SQLException: Already closed.
at
org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:114)
at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
at
org.hibernate.connection.DatasourceConnectionProvider.closeConnection(DatasourceConnectionProvider.java:97)
at
org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:474)
... 60 more
===========================================================================
Your help in this regard is highly appreciated.
Thanks & Regards,
Vijendra
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
