0 Replies Latest reply on Aug 21, 2005 9:49 PM by Jeffrey A. McManigal

    HSQLDB1.8 and jboss-4.0.3RC1

    Jeffrey A. McManigal Newbie

       

      "lpiccoli" wrote:
      hi all,

      i am using jboss-4.0.3RC1 with HSQLDB 1.8.

      I am not sure if this post belongs here but i have tried the following forums with no lock installation/persistance. Surely someone from this forum has come accros this problem!!

      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

      -lp

      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] Star
      ting 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_TABL
      ES])
       at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:1002)
       at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.dropTableIfExists(HiLoKeyGenerat
      orFactory.java:308)
       at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.startService(HiLoKeyGeneratorFac
      tory.java:211)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:267)
       at