Yes, I've noticed actually that it appears that this error only occurs once
and it's during the creation of the database. So when I distribute our app,
I'll just do it in a tomcat container with the database already created.
I'd still like to know why it happens. My guess is that it gets locked
because a thread is trying to access while the database file is being
created. I'm not sure how easy that is to replicate other than I guess a
unit test that does a decode on 4236 at the same time from different
threads.. I can see if I can get some time to try it, but I'm pretty sure
that's what going on. If you notice, it says "a portion of the file" which
just makes me think it's locked because the file is being written.
On Sun, Jan 11, 2009 at 7:57 AM, Martin Desruisseaux <
[email protected]> wrote:
> Ryan Moquin a écrit :
> > I'm trying to use geotools in a tomcat web application, and I'm getting
> > a weird exception that I don't get with the same code in a non-j2ee
> > environment..I'm not sure why the database is being locked since I've
> > used hsql in several different connection modes and haven't see this
> > error.. is there a way to have multithreaded access to the epsg hsql
> > plugin in tomcat?
> >
> > Caused by: java.sql.SQLException: The database is already in use by
> > another process: org.hsqldb.persist.NIOLock
> > f...@8ffeb90e[file =C:\tomcat\temp\Geotools\Databases\HSQL\EPSG.lck,
> > exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:
> java.io.IOException: The process
> > cannot access the file because another process has locked a portion of
> the file :
> > C:\tomcat\temp\Geotools\Databases\HSQL\EPSG.lck
>
>
> I'm not familiar with this error, this is the first time I see it. GeoTools
> is
> still using HSQL version 1.8.0.7 (I have not updated this dependencies
> since a
> long time...). Are you using the same version?
>
> Martin
>
------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
