Announcement Announcement Module
Collapse
No announcement yet.
You can't operate on a closed Connection!!! Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • You can't operate on a closed Connection!!!

    Hello everyone,

    I keep getting this exception in my application, so I decided to look for help here.
    Here's the stack trace from a JUnit test:
    Code:
    testCreateModifications(com.xxxxxx.core.ModelServiceTest)  Time elapsed: 0.091 sec  <<< ERROR!
    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:543)
       at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
       at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
       at org.springframework.test.context.transaction.TransactionalTestExecutionListener$TransactionContext.endTransaction(TransactionalTestExecutionListener.java:588)
       at org.springframework.test.context.transaction.TransactionalTestExecutionListener.endTransaction(TransactionalTestExecutionListener.java:297)
       at org.springframework.test.context.transaction.TransactionalTestExecutionListener.afterTestMethod(TransactionalTestExecutionListener.java:192)
       at org.springframework.test.context.TestContextManager.afterTestMethod(TestContextManager.java:396)
       at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:91)
       at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72)
       at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:231)
       at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:88)
       at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
       at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
       at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
       at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
       at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
       at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
       at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:71)
       at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
       at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:174)
       at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:53)
       at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:123)
       at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:104)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:601)
       at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:164)
       at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:110)
       at org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:175)
       at org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcessWhenForked(SurefireStarter.java:107)
       at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:68)
    Caused by: javax.persistence.PersistenceException: unexpected error when rollbacking
       at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:109)
       at org.springframework.orm.jpa.JpaTransactionManager.doRollback(JpaTransactionManager.java:539)
       ... 31 more
    Caused by: org.hibernate.TransactionException: rollback failed
       at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:215)
       at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:106)
       ... 32 more
    Caused by: org.hibernate.TransactionException: unable to rollback against JDBC connection
       at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)
       at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:209)
       ... 33 more
    Caused by: java.sql.SQLException: You can't operate on a closed Connection!!!
       at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
       at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
       at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:866)
       at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)
       ... 34 more
    Caused by: java.lang.NullPointerException
       at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:860)
       ... 35 more

    I think the problem is somewhere between spring transactions, hibernate, c3p0 and the JdbcTemplate of Spring ACL. I already asked this question on the Hybris forums (https://forums.hibernate.org/viewtop...?f=1&t=1025844) but I don't think it's a Hibernate issue. Also I have created a small application to reproduce the issue. You can reproduce it with these simple steps:

    1) download the zip from here https://www.dropbox.com/s/i46fj65ivw...connection.zip
    2) change your mysql properties in src/main/resources/mysql-jdbc.properties
    3) run mvn clean install
    4) run $>mysql -u root -pYOURPASS < src/main/resources/mysql-ddl.sql
    5) run $>./start.sh
    6) Go to http://localhost:8080/test.html in your browser and you will see the exception.

    I hope someone knows what's the cause of it as I have already spent several weeks on this

    Thanks a lot.
Working...
X