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:[EMAIL 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
