Oracle, hibernate, jdbc errors

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 v9.2.0.3 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
Advertisements