An interesting twist to the situation is that if I delete the war file in
webapps the Exception does not occur and the application works. Also, the
context.xml is not copied, so I suspect it doesn't need to be.
What causes the application to operate differently when the war file is
present then when it isn't?
Thanks
-----Original Message-----
From: Ray Madigan [mailto:ray@(protected)]
Sent: Tuesday, January 16, 2007 12:19 PM
To: Tomcat Users List
Subject: Cannot create JDBC driver
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)
---------------------------------------------------------------------
To start a new topic, e-mail: users@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)
