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]
