Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

JDBC driver for Oracle Database 12.2.0.1

User_PAL9XNov 21 2018 — edited Nov 23 2018

Hello,

We need JDBC driver with filename ojdbc6.jar for a third party software installation, but the driver that is on our server is ojdbc8.jar.

Our server is running Oracle Database Release 12.2.0.1. The download page for this release only lists ojdbc8.jar, while ojdbc6.jar is available for Oracle 12.1.0.2.

Is it safe to install ojdbc6.jar for Oracle Database 12.2.0.1?
This post has been answered by unknown-7404 on Nov 22 2018
Jump to Answer

Comments

unknown-7404 
We need JDBC driver with filename ojdbc6.jar for a third party software installation, but the driver that is on our server is ojdbc8.jar.

Correct - if you meant the jar that is part of the Oracle DB installation.

Java comes with the database and a separate version of Java is used internally by Oracle.

Our server is running Oracle Database Release 12.2.0.1. The download page for this release only lists ojdbc8.jar, while ojdbc6.jar is available for Oracle 12.1.0.2.

Correct - Java 6 is no longer supported 'internally' - you can't use Java 6 INSIDE the DB.

Is it safe to install ojdbc6.jar for Oracle Database 12.2.0.1?

You can use ANY version of Java outside the database that you wish. It has NOTHING to do, nor any interaction, with the version used INSIDE the database.

User_PAL9X

Ok, so I can paste an ojdbc6.jar file in the jdbc/lib directory of the Oracle DB home and it will not interfere with the operation of the database? If the instance needs to be restarted in the future, the DB will still use the ojdbc8.jar file? Just want to be safe.

unknown-7404 
Ok, so I can paste an ojdbc6.jar file in the jdbc/lib directory of the Oracle DB home and it will not interfere with the operation of the database?

NO! Why would you put it there? Any additional jdbc files have NOTHING to do with Oracle or the Oracle DB so don't muck up the installation with your own files..

You should never alter ANY of the files/objects that belong to Oracle.

Install your Java anywhere you want and execute it from where ever you put it.

Treat it like you would treat any other application/other file you want to put on your machine.

User_PAL9X

Because the 3rd party software that we will use for database table replication expects the jar file to be in the jdbc/lib directory.

unknown-7404
Answer 
Because the 3rd party software that we will use for database table replication expects the jar file to be in the jdbc/lib directory.

Then that software violates best practices - it should search for standard apps like executeables using the OS search process which is generally:

1. current/launch folder

2. folders specified by the PATH environment variable.

Some software may also look for its personal files in the USER HOME folder and in folders based on an applications configuration file.

But it certainly shouldn't hard code folder or file names - that is just bad coding.

Oracle doesn't use the 'external' Java version - it uses the internal one.

So although you shouldn't have a problem putting your own files in Oracles folder you shouldn't put them there.

Whenever you do an upgrade Oracle assumes it owns and controls the files in its folders.

I suggest you find a way to tell your vendor they have made a BIG mistake.

Marked as Answer by User_PAL9X · Sep 27 2020
User_PAL9X

Found the properties file where the vendor specifies the location of the jar file

1 - 6

Post Details

Added on Nov 21 2018
#java-database-connectivity-jdbc
6 comments
24,187 views