Did you try w/out escaping the double quotes? We use this statement and it
works fine (w/ hsqldb 1.7.2.8):
SET PROPERTY "hsqldb.cache_size_scale" 10;
So, try this:
SET PROPERTY "hsqldb.cache_scale" 20;
M
----- Original Message -----
From: <lists@...>
To: <hsqldb-user@...>
Sent: Tuesday, November 23, 2004 2:42 AM
Subject: Re: [Hsqldb-user] How to set/change properties on runtime
There it is:
http://hsqldb.sourceforge.net/doc/guide/ch04.html#N10B5A
I executed this expr:
SET PROPERTY \"hsqldb.cache_scale\" 20
i restarted the database, and shut it down after that. I took a look into
the
prop file, but hsqldb.cache_scale is set to 14, the default val. What am I
doing wrong?
Remo
Quoting lists@...:
> i found something:
>
> " The properties file for each database is generated by the database
> engine.
> This file can be edited after closing the database. In 1.7.2, some
> property
> values can be changed via SQL commands."
> (http://hsqldb.sourceforge.net/doc/guide/ch04.html#N109F2)
>
> I need to change the size of allowed rows in the properties file,
> property:
> hsqldb.cache_size_scale=10 (I think...?)
>
> Which sql exp is used?
>
> Remo
>
>
>
> Quoting lists@...:
>
> > Hi there
> > I got the actual release of hsqldb and I'd like to change some
> > properties
> in
> > the
> > properties file on runtime. How am I doing this?
> > Does hsqldb support cahnges while running?
> >
> > I'm using hsqldb as a lib(using the jar file) and it is started like
> > this:
> >
> > (conn is a class member variable, databaselocation too)
> >
> > Class.forName("org.hsqldb.jdbcDriver");
> > conn = DriverManager.getConnection("jdbc:hsqldb:" + databaseLocation,
> "sa",
> > //
> > username
> > ""); //password
> >
> >
> > How to start the db with params?
> >
> >
> > Greets Remo
> >
> >
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real users.
> > Discover which products truly live up to the hype. Start reading now.
> > http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Hsqldb-user mailing list
> > Hsqldb-user@...
> > https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> >
>
>
>
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
|