Oracle is a widely used commercial database. These instructions are based on testing using Oracle 10g running on Mac OS X. But other platforms should be indentical and other versions should be similar.
This also assumes that Oracle is correctly configured to accept connections from JDBC applications. Configuring Oracle is outside the scope of this document
It also assumes Java 1.4 or better. You are strongly recommended to use SQLEditor with Java 1.4 or better.
Note that for best oracle support you should use version 1.0.2 of SQLEditor. This version includes an extra field to allow selection of schema within a database. If a schema is not specified then all of the tables within the database will be selected. This is not normally what is wanted
Oracle support is still being improved. Please submit reports of problems to support@malcolmhardie.com
-
The Oracle JDBC Driver is available for download from Oracle.
You may need multiple files for Oracle support. These may vary depending on the version of Oracle you are using. The following instructions are a guide only.
For the installation described we are using the following files
-
ojdbc14.jar
This is the JDBC driver itself.
-
orai18n.jar
If you need Oracle's National Language Support.
You may find that you don't need the second file, or that you need other files. If you are unsure you should consult the administrator of your Oracle database or the Oracle documentation.
-
Quit SQLEditor if it is currently running
-
Download and unpack the driver archive using stuffit or similar
-
Locate the files ojdbc14.jar and orai18n.jar.
-
Copy the files ojdbc14.jar and orai18n.jar to the directory
/Library/Java/Extensions/ -
Start SQLEditor
-
Show the preferences window using → and select the database tab. Then enter the values as follows:
Value
Driver Name
classpath
oracle.jdbc.driver.OracleDriver
subprotocol
oracle:thin
-
Click the add button
-
Choose File→Import From Database
-
Select the Oracle database driver in the popup menu. Then enter the details of the connection into the fields.
In this example picture we are loading the database test using a database server running on the local machine with a username of test and a password of test. We have also specified a schema of TEST. The connection string will auto-complete with the suggested database url. Unless it looks wrong you should probably use the suggested database url.
Value
Setting
Hostname
localhost
the name of the machine that the database is running on (Use localhost if the database is on the same machine)
Database
test
The name of the database to connect to, ‘test’ is an example
Schema
TEST
The name of the database schema to access (or leave empty to get all tables), ‘TEST’ is an example
Username
username
The username that you wish to connect using
Password
pass
The password to use (optional)
-
Click the import button and after a few moments the database structure will appear in new window