1 Reply Latest reply on Mar 30, 2012 9:13 AM by Areak Huang

    Hibernate exception::error performing isolated work

    thinksteep thinksteep Novice

      Hi 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.