How to connect to HyperSonic DB on JBoss?

[wieza]

Hi, i'm learning jBoss and at the beginning i would like connect to data base on jBoss. I have here part of my code:
Connection con = null;
Statement stm = null;
ResultSet rs = null;
try
{
Class.forName("?????")
con = DriverManager.getConnection("????","user","password");
stm = con.createStatement();
rs = stm.executeQuery("select * from przedmioty");
while (rs.next())
{
System.out.println(rs.getString("nazwa"));
}
if (con != null)
con.close();

What drivers should I use to connect to the HyperSonic? Do I need to install them? Where can i find them? What should i put in firs paramater in DriverManager.getConnecton(???,"user", "password")?

[kpraveena]

Hi,

Which version u r using?With jboss-3.2.1 and latter u will find embedded hybersonic DB.

Praveena

[wieza]

I'm using JBoss 3.2.5. It has Hypersonic embedded, I created some tables using Database Manager but the problem is how to connect to it in Java application?

[darranl]

Is your application running inside JBoss?

If so you do not need to use the traditional JDBC aproach to obtain connect to the database, instead you need to look up the DataSource using JNDI.