1 2 Previous Next 16 Replies Latest reply on Aug 14, 2007 8:49 AM by aquest Go to original post
      • 15. Re: Hypersonic localDB.data file size limit
        genman

        jeffdo - Really a HSQL and not JBossMQ question, but you can run that statement as SQL command and it sets it within the file. Create a fix.bsh script that accesses the DataSource and runs the SQL command.

        http://wiki.jboss.org/wiki/Wiki.jsp?page=BSHDeployer

        • 16. Re: Hypersonic localDB.data file size limit
          aquest

          from where do i execute the command CHECKPOINT DEFRAG. We are using Jboss 4.0.5.GA and the data file grows till 2GB after which it throws the exception

          "org.jboss.mq.SpyJMSException: Could not store message: 2626268 msg=48627 hard NOT_STORED PERSISTENT queue=TOPIC.JECCommand.ID:6.-2147483648 priority=4 lateClone=false hashCode=29761546; - nested throwable: (java.sql.SQLException: S1000 Data file size limit is reached in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)])"

          any help will be highly appreciated.

          1 2 Previous Next