[libreoffice-users] Re: SQLite on OS X

Le 15/10/2014 17:42, Hal Vaughan a écrit :


Hal,

> I found this link 
> (https://wiki.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org) about 
> using SQLite with OpenOffice, but I am having trouble finding updated info about using SQLite 
> with LibreOffice and the link talks abut doing this on Windows and Linux, but does not mention OS 
> X or Mac at all.  (There’s also this, from 2 years ago: 
> http://ask.libreoffice.org/en/question/5523/sqlite-driver-for-mac-os-x-and-other-oss/)
>
> I’ve tried a few possibilities, but I can’t get LibreOffice to read my SQLite DB files.  Is there 
> anything more current that allows use of SQLite with LibreOffice on OS X?

There used to be an extension that worked on Linux and Windows, but I
don't recall it ever working on OSX.

Download a corresponding JDBC driver for SQLite, there are several
available, including Christian Werner's own package.

Create your sqlite database beforehand with an ad hoc tool.

Set up a database file that connects to the sqlite file via the JDBC
driver. You will have to add the JAR file to the classpath in the Java
options setup of LO.

When you start the db creation wizard in LO, you will need to find the
driver connection string and driver name - these are often provided
either in the driver documentation, or the corresponding web site

http://www.ch-werner.de/javasqlite/

I haven't tried the driver above, but was successful with a different
driver that I downloaded here :

http://www.java2s.com/Code/Jar/s/Downloadsqlitejdbcjar.htm

In the db setup wizard :

URL sqlite://absolute/path/to/test.sqlite3
JDBC Driver Class : org.sqlite.JDBC

This works for me on OSX 10.9.5


Alex



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted