Using Oracle 9i with hibernate on Websphere was giving consistent but unpredictable errors when writing to the database.
Patches for oracle on Win2003 – oracle patch v126.96.36.199 and the jdbc driver that came with it also did not help. (the dates on the ojdbc-jars with 9i were in 2002 and 2003)
Using the jdbc driver that came with the Oracle 10g express as the oracle driver in Websphere (but still using Oracle 9i, just the jdbc jar is the one from 10g) fixed the issues.
>>>>ojdbc14.jar Manifest-Version: 1.0 Specification-Title: Oracle JDBC driver classes for use with JDK14 Sealed: true Created-By: 1.4.2_08 (Sun Microsystems Inc.) Implementation-Title: ojdbc14.jar Specification-Vendor: Oracle Corporation Specification-Version: Oracle JDBC Driver version - "10.2.0.1.0XE" Implementation-Version: Oracle JDBC Driver version - "10.2.0.1.0XE" Implementation-Vendor: Oracle Corporation Implementation-Time: Wed Jan 25 01:28:31 2006