Hi,
I followed this article: "Creating Database Web Applications with
Eclipse" <http://www.eclipse.org/articles/article.php?file=Article-
EclipseDbWebapps/index.html> using Eclipse Java EE 1.2.1.20090918-0703
Apache Derby 10.5.3 and jakarta-taglibs-standard-1.1.2 to the letter,
except using later versions of Eclipse and Derby. All this running in
Apache Tomcat 5.5.28 under builtin J2SE-05 of OS X 10.5 (Leopard).
At "Testing the Application" when I run the demo.jsp on Server I get the
following root cause error:
javax.servlet.ServletException: Unable to get connection, DataSource
invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load
JDBC driver class 'org.apache.derby.jdbc.ClientDriver'"
org.apache.jasper.runtime.PageContex
tImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContex
tImpl.handlePageException(PageContextImpl.java:774)
org.apache.jsp.demo_jsp._jspService(demo_jsp.java:101)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServlet
Wrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
possibly indicating some problem with the jdbc driver. However if I
startup "ij" I can use the connection string:
connect 'jdbc:derby://localhost:1527/sample';
which is the same DB URL as in my context.xml file and I can then
execute SQL commands within that connection.
I'm not a newbie to core java, but I am new to both the Eclipse Java EE
app and Derby. Any pointers in finding start points for analyzing these
errors or a better approach for creating a database connection reliably
in Eclipse Java EE with derby would be most helpful.
/MB
