遇到h2 db数据库文件被锁住了该怎么办？

最新推荐文章于 2024-07-09 09:50:43 发布

LS.YU

最新推荐文章于 2024-07-09 09:50:43 发布

阅读量8.7k

点赞数 1

分类专栏：综合知识文章标签： h2 process

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/seafishyls/article/details/79806356

版权

综合知识专栏收录该内容

1 篇文章 0 订阅

订阅专栏

H2 DB 是一种轻量级的文件型数据库，还提供 Web Console 可视化操作数据库，支持标准的JDBC API。

因是文件型数据库，在使用的时候经常会遇到如下问题：

Error Message:

Database may be already in use: "Locked by another process"

Detail Stack:

Exception in thread "main" org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-161]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
    at org.h2.message.DbException.get(DbException.java:169)
    at org.h2.message.DbException.get(DbException.java:146)
    at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:435)
    at org.h2.store.FileLock.lockFile(FileLock.java:332)
    at org.h2.store.FileLock.lock(FileLock.java:128)
    at org.h2.engine.Database.open(Database.java:539)
    at org.h2.engine.Database.openDatabase(Database.java:219)
    at org.h2.engine.Database.<init>(Database.java:214)
    at org.h2.engine.Engine.openSession(Engine.java:56)
    at org.h2.engine.Engine.openSession(Engine.java:159)
    at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138)
    at org.h2.engine.Engine.createSession(Engine.java:121)
    at org.h2.server.TcpServerThread.run(TcpServerThread.java:124)
    at java.lang.Thread.run(Unknown Source)

    at org.h2.engine.SessionRemote.done(SessionRemote.java:538)
    at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:109)
    at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:373)
    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:267)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
    at org.h2.Driver.connect(Driver.java:72)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.h2.tools.RunScript.process(RunScript.java:312)
    at org.h2.tools.RunScript.runTool(RunScript.java:140)
    at org.h2.tools.RunScript.main(RunScript.java:68)