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: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
