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
-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
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3888821#3888821
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3888821
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
