How to set properties for JDBC connection?
Posted: Thu Feb 04, 2010 6:46 pm
I am trying to use a JDBC connection using Christian Werner's SQLite JDBC driver SQLite.JDBCDriver described here:
http://www.ch-werner.de/javasqlite/
The driver class registers and works, and so does my Datasource URL. I can browse and query the database in Base.
However, it seems that for this connection I need to tweak one of the driver's own properties, a driver-specific property called daterepr.
My problem is that I can find no place in Open Office to change the driver-specific properties. If I right-click Database -> Properties, I just see the barebones definition of the driver class and URL. If I right-click Database -> Advanced Settings, I see some "Advanced Prperties" and "Special Settings" that seem to pertain to something else.
I am a Java newbie, but it does seem that driver-specific properties are commonly exposed to a calling program. See
http://www.exampledepot.com/egs/java.sq ... pInfo.html
So how can I set such properties for the connection from within OpenOffice?
http://www.ch-werner.de/javasqlite/
The driver class registers and works, and so does my Datasource URL. I can browse and query the database in Base.
However, it seems that for this connection I need to tweak one of the driver's own properties, a driver-specific property called daterepr.
My problem is that I can find no place in Open Office to change the driver-specific properties. If I right-click Database -> Properties, I just see the barebones definition of the driver class and URL. If I right-click Database -> Advanced Settings, I see some "Advanced Prperties" and "Special Settings" that seem to pertain to something else.
I am a Java newbie, but it does seem that driver-specific properties are commonly exposed to a calling program. See
http://www.exampledepot.com/egs/java.sq ... pInfo.html
So how can I set such properties for the connection from within OpenOffice?