JDBC: Unparseable date

This is a problem we had a month or so back. I’m going to cut and paste from my notes at the time…

We are trying to upgrade our warehouse from 8.1.7 to 9.2.0.4.
In testing the pre-production database, we are getting the error below from our
systems integration tools (Crossworlds). This transfers data via jdbc to the
warehouse.
This works fine against the old 8i production database, but not against the 9i
database.

ThreadPool Worker (#6775863)] [Type: Error] [MsgID: 90012] [Mesg:
ParseException java.text.ParseException: Unparseable date: “”]

Used Metalink note Note 232357.1 to get the following versioning information:

Database Product Name is … Oracle
Database Product Version is Oracle9i Enterprise Edition Release 9.2.0.5.0 –

Pro
duction
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 – Production
=============
JDBC Driver Name is …….. Oracle JDBC driver
JDBC Driver Version is ….. 8.1.7.2.0
JDBC Driver Major Version is 8
JDBC Driver Minor Version is 1
=============

Following advice from Oracle, I copied cl* and nls* out of the 9i database $ORACLE_HOME/jdbc/lib to the same directory on the client.

This seemed to sort it out.

However there was an an associated problem which I’ll put into the next post….

Advertisements