You can configure a tomcat datasource to get a
connection or you can load your database driver and
get a connection object.
The advantage with using tomcat datasource is that it
will handle connection pooling for you.
The tomcat docs explain how to define a datasource
(you have to do it in
I don't suppose that on the Tomcat site there is a Type 4 database
driver , which I have read is the preferred driver to get because it is
pure Java, is there instead of the 1 which I assume I can always get at
java.sun.com?
Sameer Acharya wrote:
You can configure a tomcat datasource to get
From: Steve R Burrus [mailto:[EMAIL PROTECTED]
Subject: Re: Need Help w. Servlets And The JDBC.
I don't suppose that on the Tomcat site there is a Type 4
database driver , which I have read is the preferred driver
to get because it is pure Java, is there instead of the 1
which I assume I
I am currently using the Microsoft SQL Server 2005 JDBC Driver. It is free.
If you need to connect to a SQL Server 2000 or 2005, this is a good driver.
On 9/21/06, Caldarale, Charles R [EMAIL PROTECTED] wrote:
From: Steve R Burrus [mailto:[EMAIL PROTECTED]
Subject: Re: Need Help w. Servlets
to connect to a SQL Server 2000 or 2005, this is a good
driver.
On 9/21/06, Caldarale, Charles R [EMAIL PROTECTED] wrote:
From: Steve R Burrus [mailto:[EMAIL PROTECTED]
Subject: Re: Need Help w. Servlets And The JDBC.
I don't suppose that on the Tomcat site there is a Type 4
database driver
to connect to a SQL Server 2000 or 2005, this is a good
driver.
On 9/21/06, Caldarale, Charles R [EMAIL PROTECTED] wrote:
From: Steve R Burrus [mailto:[EMAIL PROTECTED]
Subject: Re: Need Help w. Servlets And The JDBC.
I don't suppose that on the Tomcat site there is a Type 4
database driver
a copy. Thank you.
- Original Message -
From: Steve R Burrus [EMAIL PROTECTED]
To: Tomcat Users List users@tomcat.apache.org
Sent: Thursday, September 21, 2006 6:31 PM
Subject: Re: Need Help w. Servlets And The JDBC.
Well this Microsoft SQL Server 2005 JDBC Driver. is it a Type 4 pure
Google is your friend... here's a quick hit:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/cjvjdbas.htm
...and another (although slightly older, still looks to be valid)...
http://www.cs.bham.ac.uk/~aps/syllabi/2004_2005/issws/h01/jdbc.html
...and
Adding to that, you should try using a connection pool rather than
direct JDBC connection, once you get familiar with the fundamentals.
With connection pools the application performs better than not.
Santosh.
Frank W. Zammetti wrote:
Google is your friend... here's a quick hit: