[jboss-user] [JBoss Tools] New message: "Re: Hibernate tools keeps lock on HSQLDB"

[Coen Damen]

User development,

A new message was posted in the thread "Hibernate tools keeps lock on HSQLDB":

http://community.jboss.org/message/532047#532047

Author  : Coen Damen
Profile : http://community.jboss.org/people/coenos

Message:
--------------------------------------------------------------
Hi Max,
 
thanks for your reply.
 
Closing the connection does not release the lock. The problem occurs when I open the Hibernate Configuration, see picture. However, when I click on the database (+) to open and see which entities there are, I get the Exception. This is when I actually use the database.
 
http://community.jboss.org/servlet/JiveServlet/showImage/2336/openconfig.JPG
 
org.hibernate.exception.JDBCConnectionException: Getting database metadata
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)
    at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.getMetaData(AbstractMetaDataDialect.java:64)
    at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.caseForSearch(AbstractMetaDataDialect.java:163)
    at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:22)
    at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:476)
    at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74)
    at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$2.execute(LazyDatabaseSchemaWorkbenchAdapter.java:116)
    at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:63)
    at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:107)
    at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:63)
    at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:106)
    at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:234)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile at 7a80f893[file =C:\Apps\hsqldb_1_8_1_2\hsqldb\data\seamdemoDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception: checkHeartbeat(): lock file [C:\Apps\hsqldb_1_8_1_2\hsqldb\data\seamdemoDB.lck] is presumably locked by another process.
    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.jdbcDriver.connect(Unknown Source)
    at org.hibernate.console.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:154)
    at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
    at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.getConnection(AbstractMetaDataDialect.java:122)
    at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.getMetaData(AbstractMetaDataDialect.java:61)
    ... 11 more
 
The lock is never released, even after closing or refreshing the configuration. The lock is only released after closing Eclipse. But even then the lck file is not removed, I need to remove it myself.
 
I am not using DTP, only JBoss tools (Hibernate tools, Seam tools explicitly).
 
I think Hibernate Tools is somehow not closing the connection to the DB after refreshing the Hibernate configuration, what do you think?
 

Thanks,
Coen

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/532047#532047