Actually my program works when I use DriverManager. It only failes when I use a DataSource.
-----Original Message----- From: Pulkit Singhal [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 10:06 PM To: Tomcat Users List Cc: Martin Gainty 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] > > --------------------------------------------------------------------- To start a new topic, e-mail: [EMAIL PROTECTED] To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
