Problem to create a connection with Hypersonic database

Hi,

i'm using NetBeans 5.5.1 and JBoss 4.0.3SP1. Over Runtime-window i try to see and to use the JBoss's database, Hypersonic. But i become following exception:

(Socket creation error) The connection cannot be created with this driver: org.hsqldb.jdbcDriver.

This are the following configurations for my DB-Connection.

Name: HSQLDB

Driver: org.hsqldb.jdbcDriver

URL to the DB: jdbc:hsqldb:hsql://127.0.0.1:1701

Username: sa

Password : *****

Can anyone help me to solve this problem. Is it actually possible to create an connection with a hypersonic database?

Which databases are support by this Netbeans DB-Client?

Thank you

Best Regards

[732 byte] By [mrXa] at [2007-11-27 10:36:12]
# 1

In general, NetBeans db client should work with any jdbc client database/driver.

Are you able to connect to the database from outside the ide (using a standalone java program)?

You may also want to take a look at :

http://www.netbeans.org/kb/50/jboss-getting-started.html

http://weblogs.java.net/blog/bleonard/archive/2006/04/elvis_meet_port.html

KarthikRa at 2007-7-28 18:39:46 > top of Java-index,Development Tools,Java Tools...
# 2

Hi KarthikR,

thank you for your reply. now i can access to hyposonic from Netbeans DB client. this link below was very useful. i modified hsqldb-ds.xml from JBoss, so that now i can access the DB over tcp too. that's all.

http://weblogs.java.net/blog/bleonard/archive/2006/04/elvis_meet_port.html

thanks

best regards

mrXa at 2007-7-28 18:39:46 > top of Java-index,Development Tools,Java Tools...