6 Replies Latest reply on Dec 16, 2009 4:56 AM by stevoffm

    Hypersonic localDB.data file size limit

    erahamim Sep 12, 2004 11:11 AM

      Hi,
      I'm using jboss 3.2.5 with default jms configuration.
      I noticed that jboss-3.2.5\server\default\data\hypersonic\localDB.data file grows and never stop until I run out of disk space (2 giga).

      Is there any way in the configuration to limit this file size ?
      How can I invoke CHECKPOINT / SHUTDOWN operation while my server is still running ? can I do it without damage the current jms messages ?

      Thanks,
      Eyal

      • 11952 Views
      • Tags:
        • 1. Re: Hypersonic localDB.data file size limit
          anil.saldhana
          anil.saldhana Sep 12, 2004 12:24 PM (in response to erahamim)

          Are you saying that you are running hsql as JMS store in production? In any case, JBoss recommends replacement of HSQL with a 3rd party stable database for production.

          We have included hsql as a small footprint database for testing purposes only. You should migrate to a different database. Look under docs/examples/jca for datasource config files for various databases.

            • Actions
          • 2. Re: Hypersonic localDB.data file size limit
            genman
            genman Sep 13, 2004 4:50 PM (in response to erahamim)


            2 gigs isn't very large, especially for a database. You can move it to a different disk.

            You can issue CHECKPOINT DEFRAG safely during server operation, though it stops the whole JMS server.

            I would suggest upgrading to HSQL 1.7.2.

              • Actions
            • 3. Re: Hypersonic localDB.data file size limit
              erahamim Sep 14, 2004 3:11 AM (in response to erahamim)

              Hi,

              Because of performance issues I need that the jms storage will be local on the same server the jboss run and not on remote database.

              Can I do it with the hsql database or file-pm-service.xml ? or the jboss doesn't support local jms persistent ?

              How can I issue CHECKPOINT DEFRAG ?

              Thanks,
              Eyal

                • Actions
              • 4. Re: Hypersonic localDB.data file size limit
                genman
                genman Sep 14, 2004 11:44 PM (in response to erahamim)


                Get a javax.sql.DatasSource via JNDI, I guess "java:/localDB". Then get a connection, issue "CHECKPOINT DEFRAG", close the connection, etc. HSQL also issues this command after ever 200MB is inserted. This won't damage your data, but as I said will cause JMS to block.

                Again, try to upgrade to 1.7.2 which will be part of 3.2.6. (Rember to back-up your data.)

                Also, if you're still having trouble you can also get help from http://sf.net in the HSQL forum.

                  • Actions
                • 5. Re: Hypersonic localDB.data file size limit
                  erahamim Sep 20, 2004 4:45 AM (in response to erahamim)

                  Thanks,
                  It works fine.
                  Eyal

                    • Actions
                  • 6. Re: Hypersonic localDB.data file size limit
                    stevoffm Dec 16, 2009 4:56 AM (in response to genman)

                    Hey,

                     

                    we are having the same problem. We are using JBoss 4.03.

                     

                    I would like to configure SET CHECKPOINT DEFRAG <VALUE>

                    in combination with the SET LOGSIZE <VALUE>

                    instead of manually triggering it.

                     

                    Does anyone know how to configure it in JBoss? Can I put it

                    somewhere in the hsql-ds.xml file -> I found a mbean there

                    which has <attribute> tags nested. Is this the right place?

                     

                    I have not found any documentation about that.

                     

                    I hope anyone can help

                     

                    Thanks & regards

                      • Actions