On 10/19/09 08:59, Ocke Janssen wrote:

On 10/17/09 23:30, Drew Jensen wrote:
Using the CWSHsqldb19 build, 10/16/09 the default has changed in the HSQLdb engine for table creation from CACHED to MEMORY.

Creating tables via the GUI or via SQL statement, w/out explicit CACHED type, produces a memory based table - on purpose change? -hmm, I didn't go back and check the SCRIPT file for a converted Base file....I'll let you know on that.
Indeed the CACHED type is missing. I'll have a look at it.
I fixed it in a newer version of the hsqldb.dll. As work around you may execute
SET DATABASE DEFAULT TABLE TYPE CACHED

as the first statement when creating a new db or convert an old one.

- oj

PS: I'll upload a new version when more issues are fixed.

- oj

Thanks

Drew



---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org





--
Ocke Janssen                      Tel: +49 40 23646 661, x66661
Dipl. Inf(FH)                     Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55                      mailto:ocke.jans...@sun.com
D-20097 Hamburg                   http://www.sun.com/staroffice

Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Reply via email to