This will work if you are using Cayenne default DataSource:
dataNode.shutdown();
ataNode.setDataSource(new PoolManager(..));
(this is broken in M12 and M11, but should work with earlier
milestones and the upcoming Beta).
Andrus
On Mar 31, 2006, at 5:18 PM, Pirola Davide wrote:
Hi Enrico,
your suggest doesn't works :-(
The csv file associated to my tables don't change if i execute
"CHECKPOINT DEFRAG"...only with "SHUTDOWN COMPACT"... but after the
db is no more accesible :-(
Thanks
Davide
-----Original Message-----
From: Enrico Donelli [mailto:[EMAIL PROTECTED]
Sent: giovedì 30 marzo 2006 11.07
To: [email protected]
Subject: Re: Hsqldb - Shutdown
Pirola Davide ha scritto:
Hi,
i'm using hsqldb with cayenne.
I'm using Resin as servlet container, and also i have a connection
pool under JNDI.
I have some Text table associated to csv file.
After executing DELETE /INSERT / UPDATE statement, this files
grow... for example when a DELETE is executed, a blank line appear
in the csv file.
So, can happen that i have only 1 record in my table, but the file
contains 100 rows!
The only way that i have found for compact this files is to
execute a "SHUTDOWN COMPACT" (i execute it with a Cayenne
SQLTemplate).
This command, reduce the size of the file, but in the while, it
"close" the session (HSQLDB),and no other command can be execute
on this connection, otherwise i receive this error: "Access is
denied : Session is closed".
I think that in this case, the connection must be closed fisically
because probably when cayenne close it, it returns available in
the connection pool, but for HSQLDB is no more usable!
So there is a way to tell to cayenne to "destroy" this connection?
... or anyone knows a "best bractise" for this kind of problem?
Thanks
Davide
I send a command CHECKPOINT DEFRAG
It should solve your problem. Let me know!
Bye
Enrico
