I am not aware of the ability to issue a sql shutdown to an in-process HSQL instance.
In your case, it would appear to me that you will have to stop the server. HTH --- Siegfried Goeschl <[EMAIL PROTECTED]> wrote: > Hi Sebastien, > > I think you need to issue a SQL shutdown command for > HSQLDB which also > compacts the database > > Cheers, > > Siegfried Goeschl > > Sebastien Arbogast wrote: > > >Hi, > > > >I'm using Codeczar tomcat plugin to manipulate my > tomcat server for my > >web application. > >So when I have to recompile some Java class while > my Tomcat server is > >running I want to execute the following procedure : > > > >maven tomcat:stop > >maven war:webapp > >maven tomcat:start > > > >But then when I try to access my database (HSQLDB > in file protocol, > >In-process mode) through my application, I get the > following error > >message : > > > >The database is already in use by another process: > >[EMAIL PROTECTED] > >=C:\dev\pfe\schaman\target\webapp\WEB-INF\db\schamandb.lck, > >exists=true, locked=false, valid=false, fl =null]: > > > >The problem seems to be that when the application > is stopped, the lock > >on schamandb.lck is not released. Does anyone know > how to solve this > >situation or do I have to stop the server everytime > I have something > >to recompile ? > > > >My configuration is the following : > >- HSQLDB 1.7.3.3 > >- Maven 1.0.2 > >- maven-tomcat-plugin version 1.1 > > > >Thx in advance. > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
