Re: [libreoffice-users] Re: Base: Connecting to SQLite3 .db and Working With it

On Wed, 21 Jan 2015, Alexander Thurgood wrote:

> The hsqldb 1.8 documentation ? LO uses the hsqldb 1.8 as the embedded db
> engine in LO by default, unless you meant you are setting up a "split"
> database using an external hsqldb.jar version > 2 ?
Alex,

  The manual appears to be the most current, but it refers to backward
compatibility with versions 1.8 and 2.0 with the syntax for an
autoincrementing primary key. I could not care less which hsqldb is used as
long as LO-4.3.5 Base will work with it.

  I'm translating the SQLite schema .sql to the HSQLDB DDL syntax. I'll
check syntax with the hsqldb mail list and ask them how to generate the file
that Base will recognize using the jdbc interface.

Thanks,

Rich


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