Hibernate exception::error performing isolated work
thinksteep Mar 22, 2012 12:17 PMHi All,
We are in process of upgrading to 7.1 from 4.2.3a. During this excersize I did few changes to my hibernate.cfg.xml. Attached hibernate.cfg.xml
As well as here is standalone.xml entries:
<datasource jta="true" jndi-name="java:/DSName" pool-name="DSName" enabled="true" use-java-context="true">
<connection-url>connectionurl</connection-url>
<driver>mysql</driver>
<pool>
<min-pool-size>20</min-pool-size>
<max-pool-size>100</max-pool-size>
</pool>
<security>
<user-name>username</user-name>
<password>pwd</password>
</security>
<timeout>
<blocking-timeout-millis>120000</blocking-timeout-millis>
<idle-timeout-minutes>0</idle-timeout-minutes>
</timeout>
<statement>
<prepared-statement-cache-size>50</prepared-statement-cache-size>
</statement>
</datasource>
And I am getting following error:
12:00:26,470 WARN [org.hibernate.util.JDBCExceptionReporter] (http--127.0.0.1-8080-2) SQL Error: 0, SQLState: null
12:00:26,471 ERROR [org.hibernate.util.JDBCExceptionReporter] (http--127.0.0.1-8080-2) You cannot commit during a managed transaction!
12:00:26,472 ERROR [yyy_common.yyyUserActivityException] (http--127.0.0.1-8080-2) [yyyUserActivity][yyyUserActivityException][myBean][createConnection] Failed to create connection: org.hibernate.exception.GenericJDBCException: error performing isolated work
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) [hibernate3.jar:3.2.6.ga]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) [hibernate3.jar:3.2.6.ga]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) [hibernate3.jar:3.2.6.ga]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) [hibernate3.jar:3.2.6.ga]
at org.hibernate.engine.transaction.Isolater$JdbcDelegate.delegateWork(Isolater.java:207) [hibernate3.jar:3.2.6.ga]
at org.hibernate.engine.transaction.Isolater.doIsolatedWork(Isolater.java:43) [hibernate3.jar:3.2.6.ga]
at org.hibernate.engine.TransactionHelper.doWorkInNewTransaction(TransactionHelper.java:51) [hibernate3.jar:3.2.6.ga]
at org.hibernate.id.TableGenerator.generate(TableGenerator.java:94) [hibernate3.jar:3.2.6.ga]
Attached full log. Any pointer would be really appreciated.
Thank you for your time and help.
-
hibernate_Exception.txt.zip 2.7 KB
-
hibernate.cfg.xml 1.1 KB