Reclaiming space from Derby

2010-09-08 Thread Paul Taylor
HI, I use derby in embedded mode, I let the user specify a maxmium size for the derby database files, my program monitors this and if it goes over the size I use SQL to delete records that are no longer necessary in the hope of shrinking the database files size, but it doesn't, how can I force

Re: Reclaiming space from Derby

2010-09-08 Thread Kristian Waagan
On 08.09.10 12:50, Paul Taylor wrote: HI, I use derby in embedded mode, I let the user specify a maxmium size for the derby database files, my program monitors this and if it goes over the size I use SQL to delete records that are no longer necessary in the hope of shrinking the database

Re: Reclaiming space from Derby

2010-09-08 Thread Knut Anders Hatlen
Paul Taylor paul_t...@fastmail.fm writes: HI, I use derby in embedded mode, I let the user specify a maxmium size for the derby database files, my program monitors this and if it goes over the size I use SQL to delete records that are no longer necessary in the hope of shrinking the database

Re: Reclaiming space from Derby

2010-09-08 Thread Paul Taylor
Knut Anders Hatlen wrote: Paul Taylor paul_t...@fastmail.fm writes: HI, I use derby in embedded mode, I let the user specify a maxmium size for the derby database files, my program monitors this and if it goes over the size I use SQL to delete records that are no longer necessary in the

Re: Create trigger with 2 sql statements

2010-09-08 Thread Kristian Waagan
On 23.08.10 11:52, Andrzej Kasprzyszyn wrote: Hi All I would like to create following trigger CREATE TRIGGER COUNTRY_TRG AFTER INSERT ON COUNTRY DELETE FROM aTable WHERE table_name = 'country' INSERT INTO aTable(table_name, msg) VALUES('country', current_timestamp) I am receiving syntax

Re: Reclaiming space from Derby

2010-09-08 Thread Knut Anders Hatlen
Paul Taylor paul_t...@fastmail.fm writes: Knut Anders Hatlen wrote: Paul Taylor paul_t...@fastmail.fm writes: HI, I use derby in embedded mode, I let the user specify a maxmium size for the derby database files, my program monitors this and if it goes over the size I use SQL to delete

RE: Question about how Derby uses it's tmp/ sub-directory - and what to do when it goes missing!

2010-09-08 Thread Richard G. Hash
Bryan, Thanks for the information. I will submit a bug as soon as we can pin it down to something more useful than some problem occurs ;-) In our case I have not been leaning towards resource constraints for a couple of reasons. We ran into the max-file-descriptor issue a long time ago, and