Java能打开数据库服务器吗_java – 如何在服务器模式下运行H2数据库?

如何在服务器模式下启动H2数据库。我需要从我的应用程序启动它。我尝试了以下代码:

server = Server.createTcpServer().start();

以下是连接的属性:

javabase.jdbc.url = jdbc:h2:tcp://localhost:9092/nio:~/source/db/database/db;AUTO_SERVER=TRUE

javabase.jdbc.driver = org.h2.Driver

javabase.jdbc.username = sa

javabase.jdbc.password =

当我运行程序时,我得到以下错误:

client.db.exception.DAOException: 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-164]

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:439)

at org.h2.store.FileLock.lockFile(FileLock.java:336)

at org.h2.store.FileLock.lock(FileLock.java:128)

at org.h2.engine.Database.open(Database.java:542)

at org.h2.engine.Database.openDatabase(Database.java:222)

at org.h2.engine.Database.(Database.java:217)

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:133)

at java.lang.Thread.run(Thread.java:680)

谢谢,

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值