Using Oracle JDBC Thin Driver with MyOra

MyOra 10.2 requires Oracle JDBC Thin Driver to connect to database. Oracle JDBC Thin driver can be download from Oracle website for free of charge, but you may require to register on the Oracle site to proceed with download. You do not require any additional software other than Oracle JDBC Thin driver. You do not require to install the JDBC driver, just copy the JDBC jar file into a folder where MyOra.exe file is located. 

Note:
Oracle JDBC Thin driver can be found in Oracle SQL Developer, Oracle Client or Oracle Server installations.
If you have Oracle SQL Developer, Oracle Client or Oracle Server installed on your machine, Oracle JDBC Thin driver can be found in one of the directories (search for ojdbc5.jar or ojdbc6.jar  or ojdbc7.jar  or ojdbc8.jar files). The directory listing of the driver files is [ORACLE_HOME]\jdbc\lib\.

Oracle JDBC Driver URL:
https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html





Java version
Oracle Database
JDBC Driver (Required)
If you have Java 1.6 (JRE) version installed on your machine

If you want to connect to 
Oracle database(s)

10g, 11g, 12c
You need to download any one of the following Oracle JDBC Thin driver.
Click the link below to download.

or
If you have Java 1.7 (JRE) version installed on your machine
If you want to connect to 
Oracle database(s)

10g, 11g, 12c, 18c
You need to download the following Oracle JDBC Thin driver.
Click the link below to download.

If you have Java 1.8 (JRE) version installed on your machine
If you want to connect to 
Oracle database(s)

10g, 11g, 12c, 18c, 19c
You need to download the following Oracle JDBC Thin driver.
Click the link below to download.

To identify the Java version used by MyOra
       

Note:
Oracle JDBC Thin driver can be found in Oracle SQL Developer, Oracle Client or Oracle Server installations.
If you have Oracle SQL Developer, Oracle Client or Oracle Server installed on your machine, Oracle JDBC Thin driver can be found in one of the directories (search for ojdbc5.jar or ojdbc6.jar or ojdbc7.jar or ojdbc8.jar files). The directory listing of the driver files is [ORACLE_HOME]\jdbc\lib\.
Note: If you have multiple java versions installed on local machine, you need to find the java version that is being used by MyOra. Based on the java version used by MyOra, you need to download appropriate Oralce JDBC Thin driver version from Oracle website.
After you have downloaded Oracle JDBC Thin Driver (ojdbc5.jar  or  ojdbc6.jar or  ojdbc7.jar or  ojdbc8.jar)  from Oracle website and copied it to a folder where MyOra.exe file is located, the contents of the folder are shown as below:
After downloading Oracle JDBC Thin Driver
To start MyOra application
Double click MyOra.exe file to start MyOra application. You are ready to connect to Oracle Database.
Copyright © Jayam Systems, LLC
®
MyOra
Java version, Oracle database version,  JDBC driver connection compatibility is given below:



v10.2
MyOra is available in two separate builds, one build works with  Java 1.6  or 1.7  or 1.8 versions and other build works with Java 9 or 10 or 11 or 12 or 13.

There two MyOra builds are available in two separate folders Java1_8andBelow and Java9andAbove.
For MyOra build Java1_8andBelow
Java version
Oracle Database
JDBC Driver (Required)
If you have Java 9 (JRE) version installed on your machine







If you want to connect to 
Oracle database(s)

10g, 11g, 12c, 18c, 19c






You need to download the following Oracle JDBC Thin driver.
Click the link below to download.

If you have Java 10 (JRE) version installed on your machine
If you have Java 11 (JRE) version installed on your machine
If you have Java 12 (JRE) version installed on your machine
If you have Java 13 (JRE) version installed on your machine
Java version, Oracle database version,  JDBC driver connection compatibility is given below:

For MyOra build Java9andAbove