Support
Oracle and SQLEditor
Can I use SQLEditor with an Oracle database?
Yes, you can.
SQLEditor supports importing and exporting to Oracle databases and there is a specific Oracle SQL dialect.
SQLEditor will also auto-detect Oracle JDBC drivers when they are installed.
Where can I get the Oracle JDBC driver from?
The Oracle driver is available directly from Oracle corporation at their website.
SQLEditor normally uses java 1.4, so you will need to use the Oracle 10g JDBC drivers (rather than the 11g drivers which need java 1.5)
You need to download two files from this page
ojdbc14.jar
orai18n.jar
Both of which then go into /Library/Java/Extensions/
SQLEditor should find these drivers automatically when it starts up.
If SQLEditor is already running you may need to restart it to see the new drivers.