dev@glassfish.java.net

JavaDB no suitable driver form JSP....

From: Doug Donahue <douglas.donahue_at_oracle.com>
Date: Mon, 03 Jan 2011 15:45:52 -0500

When using a the <sql:query> JSTL tag in a JSP page I am seeing the
following failure.

Could not execute the query SELECT * FROM jstl_tab1
when using jdbc:derby://localhost:1527/derbyDB;create=true,org.apache.derby.jdbc.ClientDriver,cts1,cts1
for the dataSource attribute! The Exception that was raised is:javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/derbyDB;create=true


     Now if I copy /glassfish3/javadb/lib/derbyclient.jar to
/glassfish3/glassfish/lib/endorsed/ and run the webapp, the driver is
found with no issues at all.

     Should I have to copy this jarfile into the endorsed dir?

     Thanks
     Doug



Oracle <http://www.oracle.com>
Doug Donahue| Principal Member of Technical Staff | +1.781.442.2089
Oracle Java Engineering
35 Network Drive
Burlington, MA 01803
Douglas.Donahue_at_oracle.com

Green Oracle <http://www.oracle.com/commitment> Oracle is committed to
developing practices and products that help protect the environment