-
FEATURED COMPONENTS
First time here? Check out the FAQ!
I tried many times to get the connection between my web application and Derby and I received these error messages in the eclipse console:
INFO: Server startup in 3772 ms ERROR: Cannot load JDBC driver class 'org.apache.derby.jdbc.ClientDriver' ERROR: Cannot load JDBC driver class 'org.apache.derby.jdbc.ClientDriver' 11/02/2011 19:08:53 org.apache.catalina.core.StandardContext reload
My class and database definition is showed bellow:
// Obtain our environment naming context
javax.naming.Context initCtx = new InitialContext(); javax.naming.Context envCtx = (Context) initCtx.lookup("java:comp/env");
// Look up our data source by the name we gave it when we created it. // In this case that's "jdbc/customer". javax.sql.DataSource ds = (DataSource) envCtx.lookup("jdbc/customer");
conn = ds.getConnection();
And my web.xml and context are showed bellow.
in context.xml ...
and in the web.xml ...
DB Connection jdbc/customer javax.sql.DataSource Container
jdbc/customer javax.sql.DataSource
I'm using tomcat 6 with eclipse wtp (europa) in windows. And I already put derby.jar and derbclinet.jar inside of WEB_INF\lib directory ...
There are something that I can do to solve this issue?
Thanks!
more information of web.xml and context.xml
in context.xml ...
Resource name="jdbc/customer"
auth="Container"
type="javax.sql.DataSource"
username="qwert"
password="asdf"
driverClassName="org.apache.derby.jdbc.ClientDriver"
url="jdbc:derby://localhost:1527/C:\testes_db\customer;create=true;"
maxActive="8"
and in the web.xml ...
res-ref-name jdbc/customer
res-type javax.sql.DataSource
res-auth Container
-- my second attempt
resource-env-ref-name jdbc/customer
resource-env-ref-type javax.sql.DataSource
Thanks again!
this is 100% a classpath issue...where'd you put the Derby jar file?
Asked: 2011-02-11 15:33:49 +0800
Seen: 426 times
Last updated: Feb 12 '11