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
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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