I think I have all the jar files in the right place. In fact I can access DB2 when I use DriverManager.
-----Original Message----- From: Foo Shyn [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 11:14 PM To: Tomcat Users List Cc: Martin Gainty Subject: Re: DB2 DataSource. Hi, I'd been using connection pooling setting in Tomcat for MySQL, MSSQL and Derby(or Cloudscape) so i guess DB2 could be setup just as same. Make sure your driver jar file includes the Driver which is packaged as you had declared in the XML. And place it in the Tomcat common lib folder (In Tomcat 4.1's case, Tomcat 4.1\common\lib). Thanx. Regards, FooShyn ----- Original Message ----- From: "Pulkit Singhal" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Cc: "Martin Gainty" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2007 1:05 PM Subject: Re: DB2 DataSource. > The following is copy/pasted from > http://jtds.sourceforge.net/faq.html#noSuitableDriver > > Why do I get a java.sql.SQLException: "No suitable driver" when trying to > get a connection? > > The "No suitable driver" exception is thrown by the DriverManager when > none > of the registered Driver implementations recognizes the supplied URL. This > means that you either did not register jTDS with the DriverManager first > (by > calling Class.forName("net.sourceforge.jtds.jdbc.Driver")) or you mistyped > the URL (e.g. "jbdc:jtds:..." instead of "jdbc:jtds:..."). > > A common mistake is to append a semicolon (";") to the end of the URL > (e.g. > "jdbc:jtds:sqlserver://server/db;TDS=7.0;" is wrong!). > > For more information about URL format and the properties that may be > passed > to jTDS have a look at the jTDS URL > format<http://jtds.sourceforge.net/faq.html#urlFormat> > . > > > On 4/12/07, Fargusson.Alan <[EMAIL PROTECTED]> wrote: >> >> Thanks. Unfortunately I did try this example before. It doesn't work. >> I >> get an exception, and along with the stack dump I display I get "Caused >> by: >> java.sql.SQLException: No suitable driver". >> >> I am hoping that someone has a working example that they actually tested. >> >> -----Original Message----- >> From: Martin Gainty [mailto:[EMAIL PROTECTED] >> Sent: Thursday, April 12, 2007 3:19 PM >> To: Tomcat Users List >> Subject: Re: DB2 DataSource. >> >> >> Alan- >> >> http://www.itjungle.com/fhg/fhg051204-story01.html >> >> Viel Gluck/Buena Suerte >> >> Martin-- >> This email message and any files transmitted with it contain confidential >> information intended only for the person(s) to whom this email message is >> addressed. If you have received this email message in error, please >> notify >> the sender immediately by telephone or email and destroy the original >> message without making a copy. Thank you. >> >> ----- Original Message ----- >> From: "Fargusson.Alan" <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Thursday, April 12, 2007 6:01 PM >> Subject: DB2 DataSource. >> >> >> Can someone point me to documentation on setting up a DataSource to DB2? >> >> I tried to use the examples for Oracle and MySql, but I have not been >> able >> to get it to work. >> >> I am able to access DB2 using the DriverManager. >> >> --------------------------------------------------------------------- >> To start a new topic, e-mail: [EMAIL PROTECTED] >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> --------------------------------------------------------------------- >> To start a new topic, e-mail: [EMAIL PROTECTED] >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> --------------------------------------------------------------------- >> To start a new topic, e-mail: [EMAIL PROTECTED] >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > -------------------------------------------------------------------------------- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.3.0/758 - Release Date: 4/12/2007 11:52 AM --------------------------------------------------------------------- To start a new topic, e-mail: [EMAIL PROTECTED] To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: [EMAIL PROTECTED] To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
