wrote: > On Dec 18, 2007 7:19 AM, Hari Krishna Korrapati > < harikrishna.korrapati@gmail.com> wrote: > > > I hope i am not using hibernate pool. > > I think you are as the properties for database pools are in Geronimo > and Hibernate configuration files. Hibernate doesn't really know about > Geronimo and its database pools. Take a look at hibernate-cfg.xml in > JBoss to Geronimo - Hibernate Migration [1] > > Jacek > > [1] > http://cwiki.apache.org/GMOxDOC20/jboss-to-geronimo-hibernate-migration.html > > -- > Jacek Laskowski > http://www.JacekLaskowski.pl > -- Regards, Hari ------=_Part_10397_30505013.1197968566929 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Sorry for the previous post which has configuration information used for testing purpose also.
My hibernate.cfg.xml has the following which is similar to the one specified in the link given by you

<hibernate-configuration>
    <session-factory>
        
        <property name="connection.datasource">java:comp/env/jdbc/XYZDataSource</property>
        
        <property name="dialect">net.sf.hibernate.dialect.DB2Dialect</property>
        <property name="show_sql">true</property>
        <property name="use_outer_join">true</property>
        
        <property name="hibernate.jdbc.batch_size">200</property>
        <property name="statement_cache.size">100</property>
        
        <property name="hibernate.cache.provider_class">net.sf.ehcache.hibernate.Provider</property>
        <property name="hibernate.cache.use_query_cache ">true</property>
        
        <property name="transaction.factory_class">net.sf.hibernate.transaction.JDBCTransactionFactory</property>
        <property name=" transaction.manager_lookup_class">net.sf.hibernate.transaction.GeronimoTransactionManagerLookup</property>
        
        <mapping resource="Sample.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

Also the error i am getting is

14:27:45,092 WARN [GeronimoConnectionEventListener] connectionErrorOccurred called with null
com.ibm.db2.jcc.a.dg: Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.
    at com.ibm.db2.jcc.a.f.a(f.java:328)
    at com.ibm.db2.jcc.a.cp.a(cp.java:2160)
    at com.ibm.db2.jcc.a.cp.executeBatch(cp.java:1991)
    at com.ibm.db2.jcc.a.cp.executeBatch(cp.java:1010)
    at org.tranql.connector.jdbc.StatementHandle.executeBatch (StatementHandle.java:157)
    at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
    at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:122)
    at net.sf.hibernate.impl.SessionImpl.executeAll (SessionImpl.java:2417)
    at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2368)
    at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236)
................
.............

14:27:45,092 WARN [JDBCExceptionReporter] SQL Error: -99999, SQLState: null
14:27:45,092 ERROR [JDBCExceptionReporter] Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.
14:27:45,092 WARN [JDBCExceptionReporter] SQL Error: -301, SQLState: 07006
14:27:45,092 ERROR [JDBCExceptionReporter] Error for batch element #0: DB2 SQL error: SQLCODE: -301, SQLSTATE: 07006, SQLERRMC: 12
14:27:45,092 WARN [JDBCExceptionReporter] SQL Error: -99999, SQLState: null
14:27:45,092 ERROR [JDBCExceptionReporter] Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.
14:27:45,092 WARN [JDBCExceptionReporter] SQL Error: -301, SQLState: 07006
14:27:45,092 ERROR [JDBCExceptionReporter] Error for batch element #0: DB2 SQL error: SQLCODE: -301, SQLSTATE: 07006, SQLERRMC: 12
14:27:45,092 ERROR [JDBCExceptionReporter] Could not execute JDBC batch update
c

On Dec 18, 2007 1:10 PM, Jacek Laskowski <jacek@laskowski.net.pl> wrote:

On Dec 18, 2007 7:19 AM, Hari Krishna Korrapati
< harikrishna.korrapati@gmail.com> wrote:

> I hope i am not using hibernate pool.

I think you are as the properties for database pools are in Geronimo
and Hibernate configuration files. Hibernate doesn't really know about
Geronimo and its database pools. Take a look at hibernate-cfg.xml in
JBoss to Geronimo - Hibernate Migration [1]

Jacek

[1] http://cwiki.apache.org/GMOxDOC20/jboss-to-geronimo-hibernate-migration.html

--
Jacek Laskowski
http://www.JacekLaskowski.pl

--
Regards,
Hari ------=_Part_10397_30505013.1197968566929--