db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mikael Byström <micke.byst...@gmail.com>
Subject newbie: Eclipse Java EE 1.2.1 and Derby 10.5.3: DataSource invalid
Date Mon, 04 Jan 2010 04:19:51 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.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


Mime
View raw message