HyperSQL Database Engine (HSQLDB)

On 23.11.2004 10:11 lists@... wrote:

> Hi there
> i was looking in the documentation, the faq and the forum but i didnt find
> somewhere how to create a cached table.
> 
> This is my create expr.:
> CREATE TABLE file ( id INTEGER IDENTITY, name VARCHAR(256), project_id_fs
> INTEGER)
> 

CREATE CACHED TABLE ...

http://hsqldb.sourceforge.net/doc/guide/ch08.html#create_table-section

Regards
Thomas

On wto, lis 23, 2004 at 10:11:40 +0100, lists@... wrote:
> This is my create expr.:
> CREATE TABLE file ( id INTEGER IDENTITY, name VARCHAR(256), project_id_fs
> INTEGER)
> 
> Some inputs? Thx, Greets Remo

CREATE CACHED TABLE [...]

Pzdr

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
>

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
>

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