org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, L'archivio è in uso da un altro processo: org.hsqldb.persist.NIOLockFile@39637f09\[file =/home/sviluppo/db\_ordine.lck, exists=true, locked=false, valid=false, fl =null\]: java.lang.Exception: checkHeartbeat(): lock file \[/home/sviluppo/db\_ordine.lck\] è presumibilmente in uso da un altro processo..      at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:222)      at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:179)      at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:220)      at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:151)      at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)      at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157)      at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:236)      at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:223)

hsqldb | shingen67 | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    HSQLDB and BIRT

    hsqldb | 8 years ago | shingen67
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, L'archivio è in uso da un altro processo: org.hsqldb.persist.NIOLockFile@39637f09\[file =/home/sviluppo/db\_ordine.lck, exists=true, locked=false, valid=false, fl =null\]: java.lang.Exception: checkHeartbeat(): lock file \[/home/sviluppo/db\_ordine.lck\] è presumibilmente in uso da un altro processo..      at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:222)      at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:179)      at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:220)      at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:151)      at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)      at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157)      at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:236)      at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:223)

    Root Cause Analysis

    1. org.eclipse.birt.report.data.oda.jdbc.JDBCException

      There is an error in get connection, L'archivio è in uso da un altro processo: org.hsqldb.persist.NIOLockFile@39637f09\[file =/home/sviluppo/db\_ordine.lck, exists=true, locked=false, valid=false, fl =null\]: java.lang.Exception: checkHeartbeat(): lock file \[/home/sviluppo/db\_ordine.lck\] è presumibilmente in uso da un altro processo..      at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:222)      at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:179)      at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:220)      at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:151)      at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)      at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157)      at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:236)      at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:223)

      at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource()
    2. BIRT Data Engine
      PreparedOdaDSQuery.execute
      1. org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)
      2. org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:390)
      3. org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:309)
      4. org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:498)
      5. org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
      6. org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
      7. org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
      7 frames
    3. BIRT Data Adapter
      DataRequestSessionImpl.execute
      1. org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:482)
      1 frame
    4. org.eclipse.birt
      RunAndRenderTask.run
      1. org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:115)
      2. org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
      3. org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
      4. org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
      5. org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
      6. org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
      7. org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
      8. org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
      9. org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
      10. org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
      11. org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
      12. org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151)
      13. org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
      13 frames
    5. Unknown
      AlboElettronico$1.actionPerformed
      1. AlboElettronico.Stampa(AlboElettronico.java:628)
      2. AlboElettronico$1.actionPerformed(AlboElettronico.java:324)
      2 frames
    6. Java RT
      EventDispatchThread.run
      1. java.awt.Button.processActionEvent(Button.java:409)
      2. java.awt.Button.processEvent(Button.java:377)
      3. java.awt.Component.dispatchEventImpl(Component.java:4467)
      4. java.awt.Component.dispatchEvent(Component.java:4293)
      5. java.awt.EventQueue.dispatchEvent(EventQueue.java:604)
      6. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275)
      7. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200)
      8. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
      9. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:185)
      10. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:177)
      11. java.awt.EventDispatchThread.run(EventDispatchThread.java:138)
      11 frames