does anybody has some sample to connect to external hypersonic db intead of the one under JBoss? I am having a hard time to configure the data source.
Take a look at the hsql-db-ds.xml file in the deploy directory. Hypersonic, by default, does not allow for external TCP connections. There are sections in the file that allow you to uncomment this and enable external connectivity.
Also, the JMX console allows you to fire up a Swing GUI client that allows you to do JDBC based tasks against the Hypersonic instance.