Can not find Generic JDBC Driver on OS X

[amix]

Hi,

I am using the Eclipse plugin version on Apple Mac OS X 10.6.4. I would like to setup a SQLite3 connection using the SQLite ODBC driver, which I have installed (0.83). I would need the JDBC-ODBC bridge, but there is none.

Also there is no generic JDBC driver on OS X as it seems. The 'detect' button in the oXygenXML prefs results in "Drivers found: 0".

What am I doing wrong?

[adrian]

Hello,

The JDBC-ODBC bridge is only provided by Oxygen when it is run on Windows platforms.
This bridge is a built-in component of the Sun JVM and unfortunately it is not present in Apple's own JVM(as far as I know).

Anyway, the JDBC-ODBC bridge should only be used as a last resort, it's not particularly fast or reliable.

The best way to resolve this is to use an SQLite JDBC connector:
http://www.zentus.com/sqlitejdbc/ (sqlitejdbc-v056.jar)
http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC (sqlite-jdbc-3.6.20.1.jar)
I see these also support Mac OS X.

To use any of these drivers you have to create a new generic JDBC Data Source in Oxygen and add the corresponding jar(Add Files), then the driver class should be detected automatically: org.sqlite.JDBC

Afterwards you can create a new connection, choose the Data Source configured above and provide the JDBC URL(e.g. jdbc:sqlite:sample.db), user and password.

Regards,
Adrian

[amix]

Thank you, that worked.