[Hsqldb-user] setting connection property hsqldb.cache_file_scale doesn't take effect

[Elizabeth D. <zz...@gm...>]

Hi

If I include the property "hsqldb.cache_file_scale=128" in 
the url when I create a database connection, I don't see 
any sign that the setting has taken effect. 

After closing the database, my .script file shows:

SET FILES SCALE 8

This tells me that setting this property via the url isn't working.

If I instead set it using SQL (SET FILES SCALE 128), 
I get an error: "Data file is in use." 
The documentation says "This command can be
used only when there is no data in CACHED tables." 

Since this SQL SET call is the first SQL call I make after 
creating a new database, I don't think I have data in cached 
tables yet, so I'm not sure why this is failing.

I need a programmatic way to set this property. 
I'd like to set it as a connection 
property or set it using SQL the same way 
I set my other properties.

Please let me know what I'm doing wrong 
or provide suggestions for alternate 
approaches. Your help is very much appreciated!

Best,
Elizabeth