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.