Problem Using DataSource and Creating Connection Pool
Joined: Jan 12, 2007
hi all 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:
Alright I managed to work around the DataSource part of the problem by using the embeded derby driver in the connection pool. I created a new data source in JDBC DataSource then did the binding in web.xml. And now I can use DataSource instead of Class.forName(). I know this might be elementary stuff to some. But I still can't add an external db driver to the connection pool and use it. If anyone has an idea why it's such a problem or how to solve it I will appreciate their output. thank you.