I'm trying to use Hibernate with HyperJaxb2 on a DB2/400 database. I have a simple junit test case that marshals an XML file into an object, stores it in hibernate, then re-loads it, unmarshals to XML & prints the XML. This works fine using the hypersonic db, but if I switch to the DB2/400, it fails in hibernate when trying to load the object. I know the store worked, because i can see the row in the table using other tools. From the hibernate debug trace, it appears that the PrepareStatement fails:

GOOD trace (hypersonic):
Hibernate: /* load com.triversity.te.integration.impl.TsD1Impl */ select tsd1impl0_.Hjid as Hjid0_, tsd1impl0_.Hjversion as Hjversion0_0_, tsd1impl0_.Tstring2 as Tstring4_0_0_, tsd1impl0_.Tstring1 as Tstring5_0_0_ from TsD1Type tsd1impl0_ where tsd1impl0_.Hjid=? and tsd1impl0_.Hjtype='com.triversity.te.integration.TsD1'
DEBUG [org.hibernate.jdbc.AbstractBatcher] - <preparing statement>
DEBUG [org.hibernate.type.LongType] - <binding '1' to parameter: 1>
DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to open ResultSet (open ResultSets: 0, globally: 0)>
DEBUG [org.hibernate.loader.Loader] - <processing result set>

FAILING trace (DB2/400):
{same as good trace...}
Hibernate: /* load com.triversity.te.integration.impl.TsD1Impl */ select tsd1impl0_.Hjid as Hjid0_, tsd1impl0_.Hjversion as Hjversion0_0_, tsd1impl0_.Tstring2 as Tstring4_0_0_, tsd1impl0_.Tstring1 as Tstring5_0_0_ from tedev.TsD1Type tsd1impl0_ where tsd1impl0_.Hjid=? and tsd1impl0_.Hjtype='com.triversity.te.integration.TsD1'
DEBUG [org.hibernate.jdbc.AbstractBatcher] - <preparing statement>
DEBUG [org.hibernate.type.LongType] - <binding '1' to parameter: 1>
{diverges from good trace here...}
DEBUG [org.hibernate.jdbc.AbstractBatcher] - <about to close PreparedStatement (open PreparedStatements: 1, globally: 1)>
DEBUG [org.hibernate.jdbc.AbstractBatcher] - <closing statement>
INFO [org.hibernate.connection.DriverManagerConnectionProvider] - <cleaning up connection pool: jdbc:as400://192.100.100.1/TEDEV>
DEBUG [org.hibernate.util.JDBCExceptionReporter] - <could not load an entity: [com.triversity.te.integration.impl.TsD1Impl#1] [/* load com.triversity.te.integration.impl.TsD1Impl */ select tsd1impl0_.Hjid as Hjid0_, tsd1impl0_.Hjversion as Hjversion0_0_, tsd1impl0_.Tstring2 as Tstring4_0_0_, tsd1impl0_.Tstring1 as Tstring5_0_0_ from tedev.TsD1Type tsd1impl0_ where tsd1impl0_.Hjid=? and tsd1impl0_.Hjtype='com.triversity.te.integration.TsD1']>

java.sql.SQLException: [SQL0518] Prepared statement STMT0001 not found.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:364)
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:616)
at com.ibm.as400.access.AS400JDBCPreparedStatement.executeQuery(AS400JDBCPreparedStatement.java:871)
...

The traces diverge after the <binding '1' to parameter 1> output. The failing case indicates the PreparedStatement is being closed... then we get the SQLException apparently because there's no prepared statement.

The hbm.xml files are identical in the two cases -- they're generated by HyperJaxb from my XSD. The only difference in the SQL statement being prepared (as seen in trace) is the AS400 code has the schema name prepended to the table name: "from tedev.TsD1Type" (as expected).

Any ideas?
-dwight

Hibernate version: 3.0.5
Name and version of the database you are using: DB2/400, iSeries V5R3; AS/400 toolbox v5.1.0 for jdbc access.
Code between sessionFactory.openSession() and session.close():
final Object loadedObject = loadSession.load(object.getClass(), id);
Mapping documents:

I installed hibernate 3.1 & this still happens. Test works (save + load) with HSQLDB, but using the AS400, I can save, but not load. The load always gets "[SQL0518] Prepared statement STMT0001 not found."

This is our first attempt using Hibernate on the AS400; it hasn't worked yet -- so it's probably something simple, but the symptom is sure obscure. The generate SQL (in trace in previous post) seems correct; i can copy it to my db utility, change the "?" to 1, and it fetches the desired row.

I stepped thru the code, and in Loader.doQuery(), the code does:
final PreparedStatement st = prepareQueryStatement( queryParameters, false, session );

This returns a non-null st, but when getResultSet calls AS400JDBCPreparedStatement.executeQuery, it throws the SQL0518 exception.

hbm.xml & application code as shown in prior post.
I'm using the built-in hibernate connection pool.

hibernate.properties: