Can not find Generic JDBC Driver on OS X

<oXygen/> general issues.
amix
Posts: 81
Joined: Sat Aug 05, 2006 10:43 pm

Can not find Generic JDBC Driver on OS X

Post by amix » Sun Jul 18, 2010 10:54 pm

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?
Andreas

adrian
Posts: 2574
Joined: Tue May 17, 2005 4:01 pm

Re: Can not find Generic JDBC Driver on OS X

Post by adrian » Mon Jul 19, 2010 11:15 am

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
Adrian Buza
<oXygen/> XML Editor, Schema Editor and XSLT Editor/Debugger
http://www.oxygenxml.com

amix
Posts: 81
Joined: Sat Aug 05, 2006 10:43 pm

Re: Can not find Generic JDBC Driver on OS X

Post by amix » Tue Jul 20, 2010 1:18 am

Thank you, that worked. :)
Andreas

Post Reply