db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From M B <digital.disc...@gmail.com>
Subject newbie: Eclipse Java EE 1.2.1 and Derby 10.5.3: DataSource invalid
Date Mon, 04 Jan 2010 05:55:38 GMT
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.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.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.JspServletWrapper.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 derby database
connection reliably in Eclipse Java EE with derby would be most
helpful.

/MB

Mime
View raw message