geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hari Krishna Korrapati" <harikrishna.korrap...@gmail.com>
Subject Re: Problem with connection management
Date Tue, 18 Dec 2007 09:02:46 GMT
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>
        <!-- Data source -->
        <property name="connection.datasource
">java:comp/env/jdbc/XYZDataSource</property>
        <!-- Database settings -->
        <property name="dialect">net.sf.hibernate.dialect.DB2Dialect
</property>
        <property name="show_sql">true</property>
        <property name="use_outer_join">true</property>
        <!-- JDBC settings -->
        <property name="hibernate.jdbc.batch_size">200</property>
        <property name="statement_cache.size">100</property>
        <!-- Cache settings-->
        <property name="hibernate.cache.provider_class">
net.sf.ehcache.hibernate.Provider</property>
        <property name="hibernate.cache.use_query_cache ">true</property>
        <!-- Transaction API -->
        <property name="transaction.factory_class">
net.sf.hibernate.transaction.JDBCTransactionFactory</property>
        <property name=" transaction.manager_lookup_class">
net.sf.hibernate.transaction.GeronimoTransactionManagerLookup</property>
        <!-- Mapping files -->
        <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

Mime
View raw message