Database Drivers

• Introduction
• Supported Database Drivers
• General Instructions
• Specific Databases
• Unsupported Databases
• Non Database Exports
• Where do I put database drivers?

Introduction

To import a structure from an existing database you need a jdbc driver for the database.
You may also need to build the database with special options for jdbc compatibility

Please see also the SQLEditor Manual for more information on jdbc drivers.

Supported Database Drivers

Many database drivers are now automatically detected by SQLEditor and so you only need to install the jar file.
SQLEditor will then find and use the driver on the next restart.

Currently only JDBC Drivers compatible with java 1.4 will work with SQLEditor.
(However this seems to cover almost all commonly available JDBC drivers)

The following drivers are automatically detected by SQLEditor.

• MySQL
• PostgreSQL
• Oracle
• SQLite
• OpenBase

Drivers that are not on this list must be added manually using the Database pane of the Preferences window

General Instructions

• First download the correct driver
• Then find the .jar driver file
• Place the driver file in /Library/Java/Extensions
• Restart SQLEditor

Specific Databases

MySQL

Download page:
MySQL Connector J Driver

Install the JDBC driver in /Library/Java/Extensions

SQLEditor should find this driver automatically

SQLite

SQLite Driver Page - For details of the recommended sqlite driver

Install the JDBC driver in /Library/Java/Extensions

SQLEditor should find this driver automatically

Postgresql

If you are using the Entropy packages by Marc Liyanage then the current build contains everything you need.

Simply copy the jdbc driver from /usr/local/pgsql/share/java to /Library/Java/Extensions and edit /usr/local/pgsql/data/postgresql.conf so that tcpip_socket = true is visible.

Install the JDBC driver in /Library/Java/Extensions

It may be set to false or not be present at all in the default settings

SQLEditor should find this driver automatically

OpenBase

OpenBase uses the URL com.openbase.jdbc.ObDriver.

Install the JDBC driver in /Library/Java/Extensions

SQLEditor should find this driver automatically

Unsupported Databases

If a database system has a JDBC driver it should work, although databases that use a java swing or AWT user interface in their JDBC driver will probably not.

Non Database Exports

Ruby On Rails Export

The Ruby On Rails exporter is not a database export. Instead it is considered a dialect of SQL, so use the File->Export menu option. (This is because the Rails exporter exports a text file rather than interacting with the Rails setup directly.

Where do I put database drivers?

You can place JDBC database drivers in either

• /Library/Java/Extensions/

for use by all programs on your machine

• /Library/Application Support/SQLEditor/JDBC Drivers/

for use only by SQLEditor

The instructions on this page assume that you will use the /Library/Java/Extensions/ directory.
If you use the SQLEditor specific directory option you will need to subsititute the correct directory path.