Re: Need Help w. Servlets And The JDBC.
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 [EMAIL PROTECTED] wrote: 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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? 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 [EMAIL PROTECTED] wrote: 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Need Help w. Servlets And The JDBC.
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 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 COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Need Help w. Servlets And The JDBC.
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 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 COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Henry McClain Life is hard. Wear a helmet Tell your wife that she looks pretty, even if she looks like a truck. --
Re: Need Help w. Servlets And The JDBC.
The Type 4 drivers are available on Microsoft's web site at the following URL: http://search.microsoft.com/results.aspx?mkt=en-USsetlang=en-USq=JDBC Henry McClain [EMAIL PROTECTED] 09/21/06 1:35 PM 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 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 COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Henry McClain Life is hard. Wear a helmet Tell your wife that she looks pretty, even if she looks like a truck. -- - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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. 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 , 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 COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Need Help w. Servlets And The JDBC.
I would be interested in seeing a TypeIV JDBC driver for that DB- yeas ago we had a similar situation using a bridge (JDBC-ODBC) 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. - 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 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. 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 , 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 COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Need Help w. Servlets And The JDBC.
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 yet another... http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html This last one might be the best, but all three should do the trick. There is no fundamental difference between using JDBC from a servlet vs. a straight Java app. Frank Steve R Burrus wrote: 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Frank W. Zammetti Founder and Chief Software Architect Omnytex Technologies http://www.omnytex.com AIM/Yahoo: fzammetti MSN: [EMAIL PROTECTED] Author of Practical Ajax Projects With Java Technology (2006, Apress, ISBN 1-59059-695-1) Java Web Parts - http://javawebparts.sourceforge.net Supplying the wheel, so you don't have to reinvent it! - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Need Help w. Servlets And The JDBC.
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: 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 yet another... http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html This last one might be the best, but all three should do the trick. There is no fundamental difference between using JDBC from a servlet vs. a straight Java app. Frank Steve R Burrus wrote: 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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]