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?
Can not find Generic JDBC Driver on OS X
Re: Can not find Generic JDBC Driver on OS X
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
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
<oXygen/> XML Editor, Schema Editor and XSLT Editor/Debugger
http://www.oxygenxml.com