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.sql/GetPropInfo.html
So how can I set such properties for the connection from within OpenOffice?