I used the MySQL and Oracle examples to create a server.xml file. I don't actually have Oracle. I could probably try to get MySQL configured, but I don't know if it worth the effort.
-----Original Message----- From: Rashmi Rubdi [mailto:[EMAIL PROTECTED] Sent: Monday, April 16, 2007 1:34 PM To: Tomcat Users List Subject: Re: Using a DataSource to access DB2. On 4/16/07, Fargusson.Alan <[EMAIL PROTECTED]> wrote: > 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. You are right, sorry I got corss-eyed looking at the XML and didn't notice the 2nd ReourceParams > > I am just about convinced that I will not be able to use a DataSource with > DB2. Can anyone convince me otherwise? > Unless it's documented somewhere that connection pooling is not possible with DB2 I think it should still work. In one of your earlier posts you had mentioned that you weren't able to connect to MySQL or Oracle either with Conneciton Pooling --- did you try those? I think once you have it working for one database it's simply a matter of switching the JDBC JAR file and the connection string. -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]
