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

JNLP, MIME, WebSphere settings

[ 2006/02/23]

To enable WebSphere to serve Java Web Start applications, you have to add the jnlp mime-type to web sphere

In the admin console for web sphere include a new mime type

MIME type: application/x-java-jnlp-file
Extension: jnlp

In the admin console go to:

Environment->Virtual Hosts->default-host->MIME Types