Java Database Connectivity (JDBC)

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!

Problem connecting using OCI8

83282Sep 9 2002

I am getting an error when attempting to connect to a 9i r2 database using OCI8. When I connect using the thin driver all works fine. Are different drivers or installation procedures needed to use OCI8? I am working with BLOB's and wanted to use OCI because I understand it is more efficient thatn the thin driver for this data type.

The two url's which are used are listed below.
dbUrl1 "jdbc:oracle:oci8:@svr:1521:orcl"

Fails with the following error: 500 Internal Server Error : java.lang.NoSuchFieldError: oracle.jdbc.oci8.OCIEnv.envCharSetId

dbUrl2 "jdbc:oracle:thin:@svr:1521:orcl"

Works fine.

Any help is appreciated.

Thanks in advance.

Wayne

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2002

Added on Sep 9 2002

#java-database-connectivity-jdbc

6 comments

488 views