I'm using hibernate 3.0.5 and my code tests successfully with Oracle 8i, 9i, 10g, MySQL, MSSQL, and DB2 on Unix - but when connecting to DB2 on iSeries, I get the following error message:
could not get database metadata
SQL Error Code: -204
SQL State: 42704
com.ibm.db2.jdbc.app.DB2DBException: SYSSEQUENCES in SYSIBM type *FILE not found.

The only way I've been able to create a table is if i use hbm2ddl.auto=create but we need it to work with "update". I've tried setting default_schema and default_catalog properties with no success. The following is the hibernate mapping being used. I have a rather long debug trace that I could provide but is too long to post here. Need help!!
Gary

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping SYSTEM "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class entity-name="AAGary" node="AAGary" table="AAGary">
<cache usage="read-write"/>
<id name="oid" node="@oid" column="AAGary_oid" type="string" length="32">
<generator class="uuid"/>
</id>
</class>
</hibernate-mapping>

Never mind - This all worked once I downloaded and used hibernate3.jar version 3.1.2