java.sql.SQLException: File input/output errorerror java.io.IOException closing file - file C:\Program Files\sylob\jboss-4.2.0.GA\server\default\data\hypersonic\localDB.data in statement \[UPDATE JMS\_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=?\] INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.Util.throwError(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:95)

hsqldb | grouvignac | 9 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

    IOException closing file localDB.data

    hsqldb | 9 years ago | grouvignac
    java.sql.SQLException: File input/output errorerror java.io.IOException closing file - file C:\Program Files\sylob\jboss-4.2.0.GA\server\default\data\hypersonic\localDB.data in statement \[UPDATE JMS\_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=?\] INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.Util.throwError(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:95)
  2. 0

    No Active Application Scope

    wpthm.com | 2 years ago
    java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES] at org.hsqldb.jdbc.Util.throwError(Lorg.hsqldb.Result;)V(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate()I(Unknown Source)

    Root Cause Analysis

    1. java.sql.SQLException

      File input/output errorerror java.io.IOException closing file - file C:\Program Files\sylob\jboss-4.2.0.GA\server\default\data\hypersonic\localDB.data in statement \[UPDATE JMS\_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=?\] INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.Util.throwError(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) INFO   | jvm 1    | 2008/06/19 14:32:06 |     at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:95)

      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate()
    2. JBoss Application Server Connector
      WrappedPreparedStatement.executeUpdate
      1. org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
      1 frame
    3. JBossMQ
      SpyXAResource.commit
      1. org.jboss.mq.pm.jdbc2.PersistenceManager.remove(PersistenceManager.java:1404)
      2. org.jboss.mq.server.BasicQueue.acknowledge(BasicQueue.java:750)
      3. org.jboss.mq.server.JMSQueue.acknowledge(JMSQueue.java:172)
      4. org.jboss.mq.server.ClientConsumer.acknowledge(ClientConsumer.java:334)
      5. org.jboss.mq.server.JMSDestinationManager.acknowledge(JMSDestinationManager.java:514)
      6. org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:441)
      7. org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInterceptorSupport.java:126)
      8. org.jboss.mq.security.ServerSecurityInterceptor.transact(ServerSecurityInterceptor.java:197)
      9. org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:352)
      10. org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:132)
      11. org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:175)
      12. org.jboss.mq.Connection.send(Connection.java:1112)
      13. org.jboss.mq.SpyXAResourceManager.commit(SpyXAResourceManager.java:166)
      14. org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:88)
      14 frames
    4. JBoss Application Server Connector
      JcaXAResourceWrapper.commit
      1. org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.commit(JcaXAResourceWrapper.java:53)
      1 frame
    5. JBossTS jbossjta
      BaseTransaction.commit
      1. com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelOnePhaseCommit(XAResourceRecord.java:636)
      2. com.arjuna.ats.arjuna.coordinator.BasicAction.onePhaseCommit(BasicAction.java:2619)
      3. com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1779)
      4. com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:90)
      5. com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
      6. com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1256)
      7. com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
      7 frames
    6. Narayana: ArjunaJTS integration
      BaseTransactionManagerDelegate.commit
      1. com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
      1 frame
    7. JBoss Application Server Connector
      WorkWrapper.execute
      1. org.jboss.resource.adapter.jms.inflow.JmsServerSession$XATransactionDemarcationStrategy.end(JmsServerSession.java:494)
      2. org.jboss.resource.adapter.jms.inflow.JmsServerSession.run(JmsServerSession.java:248)
      3. org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:204)
      3 frames
    8. JBoss Common Classes
      BasicTaskWrapper.run
      1. org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:275)
      1 frame
    9. Dough Lea's util.concurrent package
      PooledExecutor$Worker.run
      1. EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743)
      1 frame