Link to home
Start Free TrialLog in
Avatar of dba840
dba840

asked on

oracle 10.2.0.5 jdbc driver

is 10.2.0.5 jdbc driver compatible with oracle database 10.2.0.4?    we are seeing issues once we upgrade the jdbc driver from 10.2.0.1 to 10.2.0.5.

we are getting ORA-00932: inconsistent datatypes: expected DATE got NUMBER.   our developer described the issue seems to be the code expecting java..util.Date but we are getting java.sql.Date.  
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

There shouldn't be an issue with versions.  The problem is likely an issue with implicit date conversions.

Oracle can convert strings to dates itself IF everything is correct.  This rarely happens.  

The developers should force string to dates with the Oracle TO_DATE call specifying the mask for the string and force the java date call to a matching specific string.
Avatar of dba840

ASKER

Well it was working fine before with 10.2.0.1 version of jdbc driver.   this might require code change or upgrade rdbms to 10.2.0.5 for fix but just wonder if anyone has run into similar issue with 10.2.0.5.   thanks.
You can control the 'default' date format for Oracle with NLS_DATE_FORMAT.  Try setting that value on the client side to match the format produced by Java.

It's possible they did that for the old install.
ASKER CERTIFIED SOLUTION
Avatar of dba840
dba840

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Glad you finally got the issue resolved.

I suggest you select your last post, http:#a34928770, as the solution in case anyone else runs into this probem.
Avatar of dba840

ASKER

see above comments.
Avatar of dba840

ASKER

since 9i oracle jdbc driver has changed how it handles date and other datatypes that might requires this settings if you still use oci8 driver each time you upgrade your jdbc driver.

more information:
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#08_01
Avatar of dba840

ASKER

since 9i oracle jdbc driver has changed how it handles date and other datatypes that might requires this settings if you still use oci8 driver each time you upgrade your jdbc driver.

more information:
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#08_01