Re: [Springframework-developer] HSQLDB.lck file issues when using Spring Framework

[<tri...@tr...>]

Troy,

Are you using the "DriverManagerDataSource"?  If not try using it or post your
DataSource configuration.

Thomas


Quoting Troy McKinnon <Tro...@ho...>:

> Note: I posted this to springframework forum as well since it is applicable
> to both.
> 
> The springframework is an open source IoC MVC framework. It also allows you
> to incorportate Hibernate framework, easily, for the model side of things.
> 
> http://www.springframework.org/docs/reference/index.html
> 
> As far as my question below.  I am not familiar with the SHUTDOWN. How would
> I do that?
> 
> But as far as with the Spring Framework.  I don't really have control of that
> as far as I know.  The framework is locking the database at server startup,
> because I have HSQLDB datasource in my application-context.xml.
> 
>   ----- Original Message ----- 
>   From: fredt 
>   To: Troy McKinnon ; hsq...@li... 
>   Sent: Tuesday, January 20, 2004 3:31 PM
>   Subject: Re: [Hsqldb-developers] HSQLDB.lck file issues
> 
> 
>   As far as HSQLDB is concerned, an in-process or server instance that opens
> a database, creates the *.lck file and does not release it until the SHUTDOWN
> command has been issued on the database. You should aim at incorporating the
> SHUTDOWN into your framework when you no longer need the connection to that
> particular database.
> 
>   If you are using SHUTDOWN and it does not release the *.lck then please let
> us know. I don't know about the Sprint framework (reference please).
> 
>   Please subscribe to the hsqldb-developers if you want to post messages
> here.
> 
>   Fred
> 
> 
>     ----- Original Message ----- 
>     From: Troy McKinnon 
>     To: fredt ; hsq...@li... 
>     Sent: 20 January 2004 23:11
>     Subject: Re: [Hsqldb-developers] HSQLDB.lck file issues
> 
> 
>     My issue is basically this...
> 
>     I am using the FILE version of HSQLDB to access CVS files so I can import
> them into my (Oracle /or/ Postgres) database.
> 
>     I manually create these files with one process and using the HSQL driver
> and Hibernate to access the data and take care of all the Dirty Work for me.
> 
>     Works very well stand alone.  But when I tried to incorporate it into my
> Tomcat/Spring/Hibernate framework, it just locks up (HSQLDB.lck).
> 
>     I discovered this is because I created a HSQLHibernateSessionFactory bean
> using the HSQLDataSource in my application-context.xml.
> 
>     On startup Spring must load these and lock them. It doesn't release them
> again until tomcat is terminated.
> 
>     I removed the references from my application-context.xml and used a
> straight forward hibernate-HSQLDB.cfg.xml file configuration.  Basically
> skipped spring all together.. and it works fine.
> 
>     I would like to utilize the spring framework.. is there a better way to
> do this?  I don't want to run SERVER mode on HSQL since they are basically
> only temporary import and export files.
> 
> 
>     What would you suggest?
> 
>     Cheers
> 
>     Troy
> 
> 
>       ----- Original Message ----- 
>       From: fredt 
>       To: Troy McKinnon ; hsq...@li... 
>       Cc: Troy McKinnon 
>       Sent: Tuesday, January 20, 2004 3:02 PM
>       Subject: Re: [Hsqldb-developers] HSQLDB.lck file issues
> 
> 
>       The .lck file prevents two processes from simultaneously opening the
> database file. It stays there until you shutdown the database.  If it is
> causing a problem, please state what it is.
> 
>       Fred
>         ----- Original Message ----- 
>         From: Troy McKinnon 
>         To: hsq...@li... 
>         Cc: Troy McKinnon 
>         Sent: 20 January 2004 22:12
>         Subject: [Hsqldb-developers] HSQLDB.lck file issues
> 
> 
>         I am having trouble using HSQLDB using CSV type files.  Running it in
> tomcat using Hibernate... as soon as the context starts up the lock file
> appears and it doesn't ever go away.  What exactly creates the lck file and
> how can I get by it?
> 
>         Troy
> 
>