Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#70 DB2 error 805

open
nobody
None
5
2008-12-12
2008-12-12
Larry K
No

I am using c3p0 under Hibernate. I run a test program that reads from one database table using hibernate and inserts into other tables using native JDBC(using Hibernate's connection). When I do not use c3p0 I do not get this exception, but when I do use c3p0 I get the following exception and stack trace during one part of the write. The actual insert statement is below the stack trace.

WARN JDBCExceptionReporter.logExceptions - SQL Error: -805, SQLState: 51002
ERROR JDBCExceptionReporter.logExceptions - DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH103 0X5359534C564C3031
ERROR TestPSDProposer.addAppearancesUsingScrollingAndPaging - Exception adding appearances to Pleiades schema.
org.hibernate.exception.GenericJDBCException: could not execute native bulk manipulation query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:174)
at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1163)
at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:334)
at org.egcrc.cfr.persistence.HibernateObjectManager.executeSQLUpdateQuery(HibernateObjectManager.java:179)
at org.egcrc.cfr.persistence.PSDObjectManager.executeSQLUpdateQuery(PSDObjectManager.java:156)
at org.egcrc.cfr.proposing.TestPSDProposer.addAppearancesUsingScrollingAndPaging(TestPSDProposer.java:224)
at org.egcrc.cfr.proposing.TestPSDProposer.main(TestPSDProposer.java:57)
Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH103 0X5359534C564C3031
at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
at com.ibm.db2.jcc.b.gb.o(gb.java:747)
at com.ibm.db2.jcc.b.gb.g(gb.java:143)
at com.ibm.db2.jcc.b.gb.a(gb.java:39)
at com.ibm.db2.jcc.b.w.a(w.java:34)
at com.ibm.db2.jcc.b.vb.g(vb.java:139)
at com.ibm.db2.jcc.c.fg.n(fg.java:1177)
at com.ibm.db2.jcc.c.gg.eb(gg.java:1862)
at com.ibm.db2.jcc.c.gg.d(gg.java:2295)
at com.ibm.db2.jcc.c.gg.W(gg.java:457)
at com.ibm.db2.jcc.c.gg.executeUpdate(gg.java:440)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:165)
... 6 more
ERROR TestPSDProposer.main - org.egcrc.cfr.proposing.LinkProposerException: org.hibernate.exception.GenericJDBCException: could not execute native bulk manipulation query

Insert statement that causes the problem:
"insert into psd.rljobs (gid) values (" + entry.getKey() + ")"

Relevant lines in my hibernate.cf.xml file:
<property name="hibernate.c3p0.min_size">50</property>
<property name="hibernate.c3p0.max_size">200</property>
<property name="hibernate.c3p0.timeout">1800</property>
<property name="hibernate.c3p0.max_statements">5000</property>

Discussion