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
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

    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