JPA 中 hsqldb 数据库的使用

最新推荐文章于 2025-06-17 15:04:04 发布

-droidcoffee-

最新推荐文章于 2025-06-17 15:04:04 发布

阅读量5.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： JPA JDBC 文章标签： hsqldb jpa 数据库 database exception thread

本文链接：https://blog.youkuaiyun.com/id19870510/article/details/6093733

JDBC 同时被 2 个专栏收录

21 篇文章

订阅专栏

JPA

7 篇文章

订阅专栏

本文分析了在使用HSQLEJB的standalone模式下遇到的数据库锁获取失败问题，详细解释了出现Cannot open connection异常的原因，并提供了异常堆栈跟踪。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在standalone模式下

hsqldb 必须停止服务，否则将会抛出如下异常

org.hibernate.ejb.EntityManagerFactoryImpl@dc41c5 Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147) at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1224) at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:63) at com.jpa.demo.Test.main(Test.java:27) Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473) at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:60) ... 1 more Caused by: java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@9210d1f6[file =D:/Workspaces/MyEclipse 8.6/JPA/src/com/hsql/db/xdb.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2010-12-23 03:40:13 heartbeat - read: -4750 ms. at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) 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.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) ... 6 more Caused by: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@9210d1f6[file =D:/Workspaces/MyEclipse 8.6/JPA/src/com/hsql/db/xdb.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2010-12-23 03:40:13 heartbeat - read: -4750 ms. at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source) at org.hsqldb.persist.Logger.acquireLock(Unknown Source) at org.hsqldb.persist.Logger.openPersistence(Unknown Source) at org.hsqldb.Database.reopen(Unknown Source) at org.hsqldb.Database.open(Unknown Source) at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) at org.hsqldb.DatabaseManager.newSession(Unknown Source) ... 13 more