hi all,

i have change the hypersonic datasource to use the TCP server rather than the process mode. But the following errors are occuring when trying to create the HILOSEQUENCES.

I have read existing posts on the topic but the resolution is not clear.

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)

<mbean code="org.jboss.jdbc.HypersonicDatabase"
 name="jboss:service=Hypersonic">
 <attribute name="Port">1701</attribute>
 <attribute name="Silent">true</attribute>
 <attribute name="Database">default</attribute>
 <attribute name="Trace">false</attribute>
 <attribute name="No_system_exit">true</attribute>
 </mbean>