3 Replies Latest reply on Nov 24, 2005 2:05 PM by koen.aers

    HSQLDB 1.8 + SELECT * FROM SYSTEM_TABLES not working


      hi all,

      i am using jboss-4.0.3RC1 with HSQLDB 1.8.

      When deploying my apps now it complains about executing the 'select * from system_tables'. In HSQLDB1.8 the system tables moved into the information_schema and can on;t be address with the schema prefix. Fine so where does JBOSS get the config from for the select * from system_Tables. I check the hibernate HSQLdialect but there is no mention of the system_Tables.

      where is the config to change this erroneous sql?

      any help appreciated


      2005-08-05 10:07:19,964 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Using properties: {user=sa, password=--hidden--}
      2005-08-05 10:07:19,980 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Starting failed jboss:service=KeyGeneratorFactory,type=HiLo
      org.jboss.deployment.DeploymentException: Error while checking if table aleady exists HILOSEQUENCES; - nested throwable: (java.sql.SQLException: Table not found in statement [SELECT * FROM SYSTEM_TABLES])
       at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:1002)
       at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.dropTableIfExists(HiLoKeyGeneratorFactory.java:308)
       at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.startService(HiLoKeyGeneratorFactory.java:211)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:267)

        • 1. Re: HSQLDB 1.8 + SELECT * FROM SYSTEM_TABLES not working

          i dunno if this is the correct forum for my question since i have no replies. This means either no one has come across this problem ( unlikey) or this is the wrong forum.
          I have posted on the installation/beginners/ejb3 and this one. Any suggestions please?


          • 2. Re: HSQLDB 1.8 + SELECT * FROM SYSTEM_TABLES not working

            I got this error when I added the TCP/IP Hypersonic mbean and left the localDB mbean in with the reference to the localDB (which was not configured). I changed the depends in hsqldb-ds.xml to:
            to point to the configured instance and all worked fine.

            Being new to JBoss, I can't help more, but it looks like your localDB is not configured.

            I was following the Getting Started Tutorial p 15 when I got this error.

            • 3. Re: HSQLDB 1.8 + SELECT * FROM SYSTEM_TABLES not working

              Probably way too late, but I just came across this entry and having resolved the problem myself I thought it could be interesting for others.
              In my case this was because I did not use the right jdbc driver. Make sure you use the driver provided in the 4.0.3 release of JBoss.