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?
Thanks!
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=fa
lse, fl =null]: java.lang.Exception: java.io.IOException: The process
cannot access the file because another p
rocess has locked a portion of the file :
C:\tomcat\temp\Geotools\Databases\HSQL\EPSG.lck
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbc.jdbcDataSource.getConnection(Unknown Source)
at org.hsqldb.jdbc.jdbcDataSource.getConnection(Unknown Source)
at
org.geotools.referencing.factory.epsg.ThreadedHsqlEpsgFactory.createBackingStore(ThreadedHsqlEpsgFac
tory.java:313)
at
org.geotools.referencing.factory.epsg.ThreadedEpsgFactory.createBackingStore0(ThreadedEpsgFactory.ja
va:384)
at
org.geotools.referencing.factory.epsg.ThreadedEpsgFactory.createBackingStore(ThreadedEpsgFactory.jav
a:421)
------------------------------------------------------------------------------
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
