Hi, I would first analyze why it grows so much. Possibly an uncommitted transaction?
Regards, Thomas On Thu, Feb 16, 2012 at 10:06 AM, Wolfgang Pedot <wpe...@gmail.com> wrote: > I have a related question: > > Triggered by this request I tried what happens if I execute "shutdown > compact" but do not close my connection-pool as well and as one > could have expected the database was reopened at the first query after > the shutdown without a problem. I also tried starting a new > transaction while > the compact was busy and that worked as well. > > I guess this is not quite so different from what you are trying to > implement (DB-Lock), are there any dangers to this aproach? > The nice thing is that I dont have to restart my application, I just > let it reopen the database. It does block all access to the database > during operation but thats fine with me. > > regards > Wolfgang Pedot > > -- > You received this message because you are subscribed to the Google Groups "H2 > Database" group. > To post to this group, send email to h2-database@googlegroups.com. > To unsubscribe from this group, send email to > h2-database+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.