Using Oracle JDBC Thin Driver with MyOra
MyOra 10.0 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:
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
Java version, Oracle database version, JDBC driver connection compatibility is given below:
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 version, JDBC driver connection compatibility is given below:
For MyOra build Java9andAbove