  | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | JSP - A mailing list about Java Server Pages specification and reference | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
  | | | Cannot create JDBC driver | Cannot create JDBC driver 2007-01-16 - By Ray Madigan
Back I have beat my head against this one long enough. I am hoping someone can help.
I cant get past the error message SQLException: Cannot create JDBC driver of class ' ' for connect url 'null'
I am using tomcat 5.5.17 and I am attempting to get a JDBC connection in a servlet using the instructions in the tomcat documentation pages.
My configuration is as follows:
$CATALINA_HOME/conf/server.xml - No changes
$CATALINA_BASE/webapps/Library/WEB-INF/web.xml <resource-ref> <res-ref-name>jdbc/library</res-ref-name> <res-type>javax.sql.DataSource </res-type> <res-auth>Container</res-auth> </resource-ref>
Between the <welcome... tag and the <taglib tag
$CATALINA_BASE/webapps/Library/META-INF/context.xml <Context path="/Library" docBase="Library" crossContext="true" reloadable="true" debug="1">
<Resource name="jdbc/library" auth="Container" type="javax.sql.DataSource " driverClassName="org.postgresql.Driver " url="jdbc:postgresql://192.xxx.xxx.xx/library" username="..." password="...."/> </Context>
Note: I was under the impression that Tomcat copied this to the $CATALINA_HOME/conf/Catalina/localhost/Library.xml but it isn't being copied?
The postgresql JDBC driver and commons-{pool,jdbc,collection}.jar are in $CATALINA_HOME/common/lib
My servlet source is straight forward
Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:comp/env"); DataSource ds = (DataSource)envContext.lookup("jdbc/library");
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ To start a new topic, e-mail: users@(protected) To unsubscribe, e-mail: users-unsubscribe@(protected) For additional commands, e-mail: users-help@(protected)
|
|
 |