Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

which ojdbc14.jar JDBC driver to use for Oracle 10g database

661878Sep 25 2008 — edited Oct 3 2008

When ODI is installed there seems to be an Oralce JDBC driver in place in the drivers folder (ojdbc14.jar).

When we connect to an Oracle datastore and point to a table and use the 'reverse' function to populate the columns - it sort of works OK but does not bring back the datatypes properly. This is found to be when the Oracle table has UNICODE character datatypes NCHAR and NVARCHAR. If a table has CHAR and VARCHAR it is all OK but any table that has UNICODE datatyoe has a problem.

Is this likely to be the JDBC driver ?

We have tried replacing this ojdbc14.jar with the older classes12 and this, as expected, did not resolve the issue.

We then tried replacing it with the latest 10.2.0.4 ojdbc14.jar but again no difference.

Does anyone have any experience with Oracle JDBC drivers and what release level to use - and using against UNICODE datatypes in tables ?

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2008

Added on Sep 25 2008

#business-intelligence-applications, #data-integrator, #system-management-and-integration

5 comments

1,197 views