When the appserver stop your app, i am sure it will give your webapp a chance to cleanup, by that time, you must issue sql "SHUTDOWN".
-Dan On 5/25/05, phillip rhodes <[EMAIL PROTECTED]> wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
