I do not see any way to add the auth resource from the admin page, so I edited the server.xml to add it. The only change was the message "Caused by: java.sql.SQLException: No suitable driver" instead of the Null pointer exception. I tried changing the server.xml back and I still get the No suitable driver, so I suspect some timing issue here.
There are two ResourceParams. Below the one for UserDatabase is one for jdbc/TestDB. I am just about convinced that I will not be able to use a DataSource with DB2. Can anyone convince me otherwise? -----Original Message----- From: Rashmi Rubdi [mailto:[EMAIL PROTECTED] Sent: Monday, April 16, 2007 11:42 AM To: Tomcat Users List Subject: Re: Using a DataSource to access DB2. Thanks for providing adequate relevant details. I compare parts of your configuration to http://tomcat.apache.org/tomcat-5.0-doc/config/globalresources.html In the above link it says: <Resource auth="container" "This attribute is required if the web application will use a <resource-ref> element in the web application deployment descriptor, but is optional if the application uses a <resource-env-ref> instead." Since you have defined <resource-ref> in your web.xml the auth attribute is required, but you haven't specified it in this: <Resource name="jdbc/TestDB" type="javax.sql.DataSource"/> tag. Also the ResourceParams tag looks incorrect, it should be: <ResourceParams name="jdbc/TestDB"> but you have it as: <ResourceParams name="UserDatabase"> The above are some of the mis configurations I've identified so far, there could be more. -Rashmi --------------------------------------------------------------------- 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]
