CODEWITHSUNDEEP
oracle-databaseojdbcoracle19c
bud_dev
bud_dev

Reputation: 31

How to use ojdbc6.jar with Oracle 19c?

We have a legacy application, currently using ojdbc6.jar which cannot be upgraded now. However we want to upgrade to Oracle 19c. Can we use ojdbc6.jar with Oracle 19c? If the answer is no, then can we set compatible to 11.2.0 to be able to use ojdbc6.jar?

Upvotes: 2

Views: 17313

Answers (1)

user123664
user123664

Reputation:

Normally you can use older drivers for newer databases. You just can not use the newer features of the newer database. If the driver is really old, the dba can change the sqlnet.ora on the server to allow connections from older versions.

For example: SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11 allows a client from version 11 to connect to the databases.

Better is to make sure the app is upgraded for support of the latest LTS release. In this case that would be 19c. Allowing older versions to connect can have security considerations.

In the jdbc Frequently Asked Questions you will find a lot of information.

Upvotes: 3

Related Questions