5 Replies Latest reply on Oct 30, 2002 10:10 AM by Peter Fagerlund

    Troubles with Hypersonic

    Maxim Newbie

      Hi. I have found a bug in hypersonic database, that is bundled with current JBoss versions. It can't store fields larger 64 Kb. I asked the hypersonic creators and they told that this bug is fixed in 1.6 release. When JBoss team update its persistence engine with the latest version of hypersonic (1.7 now is available)?
      I tried to update hypersonic by my own (simply replaced hsqldb.jar), but I failed. JBoss did not work with new hypersonic at all.

        • 1. Re: Troubles with Hypersonic
          Peter Fagerlund Newbie

          > Hi. I have found a bug in hypersonic database, that
          > is bundled with current JBoss versions.

          ummm ? ...

          >It can't
          > store fields larger 64 Kb. I asked the hypersonic
          > creators and they told that this bug is fixed in 1.6
          > release.

          Current versions of jboss ships with hsqldb 1.6.1 that has a JDBC Driver version 1.6

          >When JBoss team update its persistence
          > engine with the latest version of hypersonic (1.7 now
          > is available)?

          1.7 implementation is being tested now ... please try out for Yourself the hsqldb170TestImpl patch at sf.net

          > I tried to update hypersonic by my own (simply
          > replaced hsqldb.jar), but I failed. JBoss did not
          > work with new hypersonic at all.

          You can (try) run 1.6.1 and/or 1.7.x ? in it's own VM and point Your jboss DataSource there ...

          • 2. Re: Troubles with Hypersonic
            Maxim Newbie

            >Current versions of jboss ships with hsqldb 1.6.1 that has a
            >JDBC Driver version 1.6

            Are you shure? I'm using JBoss 3.0.3 and I have this bug with storing fields larger than 64 Kb.
            And all classes from JBoss/server/default/lib/hsqldb.jar was modified last in 2001, so it seems fishily to me that this hypersonic is up to date. Anyway, this bug still persists :(

            • 3. Re: Troubles with Hypersonic
              Peter Fagerlund Newbie

              > Are you shure?

              Yes

              >I'm using JBoss 3.0.3 and I have this
              > bug with storing fields larger than 64 Kb.

              It is not a bug - it is a limitation by implementation in versions prior to 1.7

              > And all classes from
              > JBoss/server/default/lib/hsqldb.jar was modified last
              > in 2001, so it seems fishily to me that this
              > hypersonic is up to date. Anyway, this bug still
              > persists :(

              huh ...

              ***

              HSQLDB running in the same VM as JBoss - is a convienience turn-key DB used mainly for :
              - quick and easy testing of internal components
              - quick and easy testing of deployed applications
              - quick and easy demo, documentation and tutorial backend
              - a cool XP "sql-cache" mechanism

              If You are to store big/many records use a HSQLDB with cached tables in a VM outside of JBoss, since the in VM HSQLDB instance uses "in-memory" tables You will grow and blow Your stack if used as a regular DBMS.

              ***

              IMHO it could be a excelent distributed "sql-cache" mechanism utilising hsqldbr(eplicated) :
              http://www.javagroups.com/javagroupsnew/docs/hsqldbr/design.htm

              1) Get Your feature-versioning straight.
              2) Try run an instance outside jboss for big and or many records.
              3) Tell us how You are doing ...

              • 4. Re: Troubles with Hypersonic
                Maxim Newbie

                >If You are to store big/many records use a HSQLDB with
                >cached tables in a VM outside of JBoss, since the in VM
                >HSQLDB instance uses "in-memory" tables You will grow and
                >blow Your stack if used as a regular DBMS.

                Pity. I thought that it can be used for ejb application. I'm creating a client-server game, and I supposed to use internal JBoss' cmp engine for simplicity. Ordinary game admin won't configure external database. It even won't know how it to do.
                So, JBoss can't be used as turn-key app server, external db is needed?
                Is it possible to turn off hypersonic's "in-memory" tables and enforce it to use hard disk?
                If possible, where the 1.7 release will be bundled with JBoss?

                Thank you.

                • 5. Re: Troubles with Hypersonic
                  Peter Fagerlund Newbie

                  > I supposed to use internal JBoss' cmp engine for
                  > simplicity. Ordinary game admin won't configure
                  > external database. It even won't know how it to do.
                  > So, JBoss can't be used as turn-key app server,
                  > external db is needed?

                  Do not confuse jboss cmp engine with a DataSource backend !

                  > Is it possible to turn off hypersonic's "in-memory"
                  > tables and enforce it to use hard disk?

                  Download hsqldb with documentation :

                  http://sourceforge.net/project/showfiles.php?group_id=23316&release_id=117043

                  Use "cached tables" --- CREATE CACHED TABLE

                  > If possible, where the 1.7 release will be bundled
                  > with JBoss?

                  As I told You already You can help test hsqldb 1.7 test impl and report if it works for You ...