Well your suggestion was good advice, I was using the wrong driver and
JDK version so I down downloaded the ojdbc5.jar to go with correct JDK
1.5 but no luck, Also tried ojdbc6.jar and jdk 1.6 same results.I do not
get an error message in the JVM console for Jboss 5.1 when server
loads:13:56:46,754 INFO [ConnectionFactoryBindingService] Bound
ConnectionManager
'jboss.jca:service=DataSourceBinding,name=HERS2DataSource' to JNDI name
'java:HERS2DataSource'13:56:46,832 INFO
[ConnectionFactoryBindingjdbc:hsqldb:hsql://${jboss.bind.address}:1701
-->jdbc:hsqldb:. -->org.jboss.resource.adapter.jdbc.vendor.DummyExceptionSorterselect *
from something -->some arbitrary
sql -->some arbitrary
sql -->org.jboss.resource.adapter.jdbc.vendor.DummyValidConnectionChecker
--> -->HsqlDbRealm
-->jboss:service=Hypersonic -->
true default false true -->...