Re: Change table status

I set Xmx512m for both the DB engine and DB Manager then tried again. Still leaves the tables as Memory. Any other ideas?

The tables are small enough now that I can get around this problem by dumping them to text, deleting and recreating them then reload for the text. I thought you would probably like to figure out what is wrong though.

Bayless


----------------------------------------------------------------


No error message. Just acted like it was done but still memory after shutdown. I’ll try the Xmx later today when I get a chance. The tables are not really that large yet but I expect them to grow due to new information.

Bayless


From: Fred Toussi 
Sent: Monday, March 24, 2014 3:29 PM
To: User discussions about HyperSQL Database Engine. 
Subject: Re: [Hsqldb-user] Change table status

Do you get an error message?

In any case execute the DatabaseManager with a large Xmx memory allocation.

Fred

On Mon, Mar 24, 2014, at 19:09, Bayless Kirtley wrote:
  Hmmm. Still no luck. I opened with DatabaseManager and manually submitted the SET TABLE statements as you suggested. The 3 recalcitrant table are still memory instead of cached.



  From: Fred Toussi
  Sent: Friday, March 21, 2014 5:08 PM
  To: User discussions about HyperSQL Database Engine.
  Subject: Re: [Hsqldb-user] Change table status

  This doesn't look right.

  You don't need to recompile your code to upgrade from 2.2.8.

  If the properties file is showing 2.2.8, the version of HSQLDB that last saved the database is 2.2.8

  Regarding the actual issue, open a copy of your database with the DatabaseManager and enter the SET TABLE statements by hand to see they do indeed work.

  Fred

  On Thu, Mar 20, 2014, at 2:26, Bayless Kirtley wrote:
    Fred,

    I just tried the checkpoint. Also tried commit then shutdown after each set command. Still no luck. One table changes but the other 3 are still memory.

    I am still running 2.2.8 so thought I would update to 2.3.2. Everything still the same. But, after that, my .properties file still shows 2.2.8. The way I tried to update was remove the old library from my program then point to the new one and recompile. This is an imbedded database. Am I doing something wrong in my update method?

    Bayless


    From: Fred Toussi
    Sent: Wednesday, March 19, 2014 5:24 PM
    To: User discussions about HyperSQL Database Engine.
    Subject: Re: [Hsqldb-user] Change table status

    Try executing a checkpoint after each run of the statement.

    Fred

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user