I have 2 problems which I think could be connected.
I am using glassfish which is JavaServerApplication 9 compliant and ( am using HSQLDB driver for database. here are the problems:
1) I can not create a connection pool using the HSQLDB driver in the GUI of asadmin> resources>jdbc>connection pool. After supplying all details and when I ping the new connection the ping fails with the message: org.hsqldb.jdbcDriver.
This is the name of the class in the driver. The jar file of the db driver is already in lib directory of glassfish/javadb. so what am I doing wrong here?
2) the second problem has to do with using DataSource to make a connection instead of Class.forName(). I am still using HSQLDB and netbeans5.5 and glassfish. now this code works fine:
Connection connection = DriverManager.getConnection(url, user,password);
However when trying to use DataSource object to get a connection like this:
InitialContext ctx = new javax.naming.InitialContext();
DataSource ds = (javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/jspbook");
Connection connection = ds.getConnection();
I get the following exception:
javax.servlet.ServletException: javax.naming.NameNotFoundException: jspbook not found
And the root cause is:
javax.naming.NameNotFoundException: jspbook not found
jspbook is the name of the database.
Any idea what's wrong here?
thanks in advance