连接finedb报错

报错日志
2017-02-28 10:26:52
严重:com.fr.third.org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The database is already in use by another process: lockFile: com.fr.third.org.hsqldb.persist.LockFile@b4d8b3d3[file =E:\Program Files (x86)\apache-tomcat-9.0.0.M9\webapps\WebReport\WEB-INF\finedb\db.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2017-02-28 10:26:51.552 heartbeat - read: -2099 ms.)
        at java.util.concurrent.FutureTask.report(Unknown Source)
        at java.util.concurrent.FutureTask.get(Unknown Source)
        at com.fr.dav.LocalEnv.testConnection(Unknown Source)
        at com.fr.design.data.datapane.connect.DatabaseConnectionPane$1$1.doInBackground(Unknown Source)
        at javax.swing.SwingWorker$1.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at javax.swing.SwingWorker.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
2017-02-28 10:26:52
正常:columnIndex:1[12]<--->columnValue:非模板触发错误[java.lang.String]
2017-02-28 10:26:52
正常:columnIndex:2[-6]<--->columnValue:6[java.lang.Short]
2017-02-28 10:26:52
正常:columnIndex:3[12]<--->columnValue:com.fr.third.org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The database is already in use by another process: lockFile: com.fr.third.org.hsqldb.persist.LockFile@b4d8b3d3[file =E:\Program Files (x86)\apache-tomcat-9.0.0.M9\webapps\WebReport\WEB-INF\finedb\db.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2017-02-28 10:26:51.552 heartbeat - read: -2099 ms.)[java.lang.String]
2017-02-28 10:26:52
正常:columnIndex:4[-1]<--->columnValue:java.util.concurrent.ExecutionException: com.fr.third.org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The database is already in use by another process: lockFile: com.fr.third.org.hsqldb.persist.LockFile@b4d8b3d3[file =E:\Program Files (x86)\apache-tomcat-9.0.0.M9\webapps\WebReport\WEB-INF\finedb\db.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2017-02-28 10:26:51.552 heartbeat - read: -2099 ms.)
        at java.util.concurrent.FutureTask.report(Unknown Source)
        at java.util.concurrent.FutureTask.get(Unknown Source)
        at com.fr.dav.LocalEnv.testConnection(Unknown Source)
        at com.fr.design.data.datapane.connect.DatabaseConnectionPane$1$1.doInBackground(Unknown Source)
        at javax.swing.SwingWorker$1.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at javax.swing.SwingWorker.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: com.fr.third.org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The database is already in use by another process: lockFile: com.fr.third.org.hsqldb.persist.LockFile@b4d8b3d3[file =E:\Program Files (x86)\apache-tomcat-9.0.0.M9\webapps\WebReport\WEB-INF\finedb\db.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2017-02-28 10:26:51.552 heartbeat - read: -2099 ms.)
        at com.fr.third.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
        at com.fr.third.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
        at com.fr.third.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at com.fr.data.pool.MemoryConnection.create(Unknown Source)
        at com.fr.data.impl.JDBCDatabaseConnection.createConnection(Unknown Source)
        at com.fr.data.impl.JDBCDatabaseConnection.testConnection(Unknown Source)
        at com.fr.dav.LocalEnv$2.call(Unknown Source)
        at com.fr.dav.LocalEnv$2.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        ... 3 more
Caused by: java.sql.SQLException: The database is already in use by another process: lockFile: com.fr.third.org.hsqldb.persist.LockFile@b4d8b3d3[file =E:\Program Files (x86)\apache-tomcat-9.0.0.M9\webapps\WebReport\WEB-INF\finedb\db.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2017-02-28 10:26:51.552 heartbeat - read: -2099 ms.
        at com.fr.third.org.hsqldb.jdbc.Util.sqlException(Util.java:63)
        at com.fr.third.org.hsqldb.jdbc.jdbcConnection.<init>(jdbcConnection.java:2430)
        at com.fr.third.org.hsqldb.jdbcDriver.getConnection(jdbcDriver.java:183)
        at com.fr.third.org.hsqldb.jdbcDriver.connect(jdbcDriver.java:161)
        at com.fr.third.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
        at com.fr.third.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at com.fr.third.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
        at com.fr.third.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        ... 13 more
[java.lang.String]
2017-02-28 10:26:52
正常:columnIndex:5[93]<--->columnValue:2017-02-28 10:26:52[java.util.Date]
2017-02-28 10:27:17
正常:加载配置文件:"datasource.xml".
FineReport竹林舞剑 发布于 2017-2-28 10:22
悬赏：2 F币 + 添加悬赏
举报
提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知
共9回答
最佳回答
0
macro_hard发布于2017-2-28 10:22（编辑于 2023-9-6 09:34）
555
最佳回答
0
Poseidon发布于2017-2-28 10:31（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • 竹林舞剑 竹林舞剑(提问者)
    [attach]58983[/attach]
    帮助文档上的数据库是填的other，但在设计器上填好other之后会自动变成SQLite。
    回复
    2017-02-28 10:36 
最佳回答
0
竹林舞剑发布于2017-2-28 10:36（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • Poseidon Poseidon

    如图
    回复
    2017-02-28 10:38 
最佳回答
0
Poseidon发布于2017-2-28 10:38（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • 竹林舞剑 竹林舞剑(提问者)

    [attach]58987[/attach]
    连接成功了，但是为什么看不到里面的表呢？
    回复
    2017-02-28 10:45 
最佳回答
0
竹林舞剑发布于2017-2-28 10:45（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • Poseidon Poseidon

    呃，这个我就不清楚了，你可以问问技术支持或者重新下载安装个，然后把FRDemo.db拷贝过来
    回复
    2017-02-28 10:47 
最佳回答
0
Poseidon发布于2017-2-28 10:47（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • 竹林舞剑 竹林舞剑(提问者)

    是finedb，不是FRDemo。但是FineBI中能看到finedb中的表，在设计器上却看不到
    [attach]58991[/attach]
    回复
    2017-02-28 11:01 
最佳回答
0
竹林舞剑发布于2017-2-28 11:01（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • Poseidon Poseidon

    如图数据库随便选，这个没关系的，主要是驱动和URL

    驱动：com.fr.third.org.hsqldb.jdbcDriver
    URL：emb:jdbc:hsqldb:file://${ENV_HOME}\\finedb\\db
    回复
    2017-02-28 11:10 
最佳回答
0
Poseidon发布于2017-2-28 11:10（编辑于 2023-9-6 09:34）
555
最佳回答
0
macro_hard发布于2017-2-28 11:47（编辑于 2023-9-6 09:34）
555
  • 0关注人数
  • 841浏览人数
    • 最后回答于：2017-2-28 11:47
    活动推荐 更多
    热门课程 更多
    隐私政策
    帆软用户服务协议
    联系管理员
    联系帆软
    Copyright© 帆软软件有限公司 版权所有
    苏ICP备18065767号
    返回顶部