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 context.xml) , also you will
need the JDBC drivers for whatever database you are
connecting to.
-Sameer
Steve R Burrus <burrus1 (AT) swbell (DOT) netwrote:
Hi all. I am an admitted newbie when it comes to
using a database
connection for a servlet to access. So can someone
please tell me the
basics about how exactly I should go about doing
this? I have been very
much "stumped" about how I should do this for quite
a long time now! I
just know that I should use 1 of 3 getConnection( )
methods to start to
do this and create a Connection object but little
else.
To start a new topic, e-mail:
users (AT) tomcat (DOT) apache.org
To unsubscribe, e-mail:
users-unsubscribe (AT) tomcat (DOT) apache.org
For additional commands, e-mail:
users-help (AT) tomcat (DOT) apache.org
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
To start a new topic, e-mail: users (AT) tomcat (DOT) apache.org
To unsubscribe, e-mail: users-unsubscribe (AT) tomcat (DOT) apache.org
For additional commands, e-mail: users-help (AT) tomcat (DOT) apache.org

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 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 context.xml) , also you will
>need the JDBC drivers for whatever database you are
>connecting to.
>-Sameer
>
Steve R Burrus <burrus1 (AT) swbell (DOT) netwrote:


>
>>Hi all. I am an admitted newbie when it comes to
>>using a database
>>connection for a servlet to access. So can someone
>>please tell me the
>>basics about how exactly I should go about doing
>>this? I have been very
>>much "stumped" about how I should do this for quite
>>a long time now! I
>>just know that I should use 1 of 3 getConnection( )
>>methods to start to
>>do this and create a Connection object but little
>>else.
>>
>>
>>
>>
>
>>
>

>
>>To start a new topic, e-mail:
>>users (AT) tomcat (DOT) apache.org
>>To unsubscribe, e-mail:
>>users-unsubscribe (AT) tomcat (DOT) apache.org
>>For additional commands, e-mail:
>>users-help (AT) tomcat (DOT) apache.org
>>
>>
>
>>
>
>
>
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>
>To start a new topic, e-mail: users (AT) tomcat (DOT) apache.org
>To unsubscribe, e-mail: users-unsubscribe (AT) tomcat (DOT) apache.org
>For additional commands, e-mail: users-help (AT) tomcat (DOT) apache.org
>
>
>

Well this Microsoft SQL Server 2005 JDBC Driver. is it a Type 4 pure
Java driver or not? I should think that anything from Microsoft would
tend to kind of de-emphasize Java.

Henry McClain wrote:

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.

9/21/06, Caldarale, Charles R <Chuck.Caldarale (AT) unisys (DOT) comwrote:
>
>>
>From: Steve R Burrus [mailto:burrus1 (AT) swbell (DOT) net]
>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 can always get at java.sun.com?
>>
>Your assumptions are incorrect. Each data base vendor must supply an
>appropriate JDBC driver, hopefully a type 4 (pure Java) version. There
>is no generic, all purpose JDBC driver.
>>
>- Chuck
>>
>>
>THIS CMMUNICATIN MAY CNTAIN CNFIDENTIAL AND/R THERWISE PRPRIETARY
>MATERIAL and is thus for use only by the intended recipient. If you
>received this in error, please contact the sender and delete the e-mail
>and its attachments from all computers.
>>
>
>To start a new topic, e-mail: users (AT) tomcat (DOT) apache.org
>To unsubscribe, e-mail: users-unsubscribe (AT) tomcat (DOT) apache.org
>For additional commands, e-mail: users-help (AT) tomcat (DOT) apache.org
>>
>>
>
>

To start a new topic, e-mail: users (AT) tomcat (DOT) apache.org
To unsubscribe, e-mail: users-unsubscribe (AT) tomcat (DOT) apache.org
For additional commands, e-mail: users-help (AT) tomcat (DOT) apache.org

I would be interested in seeing a TypeIV JDBC driver for that DB-
yeas ago we had a similar situation using a bridge (JDBCDBC) that was considerably slow until the vendor supplied driver was supplied
M-
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.

Message
From: "Steve R Burrus" <burrus1 (AT) swbell (DOT) net>
To: "Tomcat Users List" <users (AT) tomcat (DOT) 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
Java driver or not? I should think that anything from Microsoft would
tend to kind of de-emphasize Java.

Henry McClain wrote:


>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.

>>

>9/21/06, Caldarale, Charles R <Chuck.Caldarale (AT) unisys (DOT) comwrote:

>>


From: Steve R Burrus [mailto:burrus1 (AT) swbell (DOT) net]
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 can always get at java.sun.com?

Your assumptions are incorrect. Each data base vendor must supply an
appropriate JDBC driver, hopefully a type 4 (pure Java) version. There
is no generic, all purpose JDBC driver.

- Chuck

THIS CMMUNICATIN MAY CNTAIN CNFIDENTIAL AND/R THERWISE PRPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you
received this in error, please contact the sender and delete the e-mail
and its attachments from all computers.

To start a new topic, e-mail: users (AT) tomcat (DOT) apache.org
To unsubscribe, e-mail: users-unsubscribe (AT) tomcat (DOT) apache.org
For additional commands, e-mail: users-help (AT) tomcat (DOT) apache.org


>>
>>


To start a new topic, e-mail: users (AT) tomcat (DOT) apache.org
To unsubscribe, e-mail: users-unsubscribe (AT) tomcat (DOT) apache.org
For additional commands, e-mail: users-help (AT) tomcat (DOT) apache.org