Author: techfox9
Oracle JDBC 9i/10g problem..
Friday, February 23rd, 2007 @ 11:01 pm
JProfiler indicated a memory leak in the Oracle JDBC 9.0.x.3 package at TTCItem.
We replaced the 9i JDBC package with the 10g version and we started getting $B!HClassCastException$B!I on Timestamp to Date conversions. It turns out the Oracle JDBC 10g package has an option to treat this issue as a version 8 backwards compatibility by doing one of two things:
– Set system property props.put(oracle.jdbc.V8Compatible, true);
or
– Start Tomcat with cli option -Doracle.jdbc.V8Compatible=true
