Hi, Maybe something like this would be helpful for you: http://www.developer.com/java/data/print.php/10932_2172891_3.
As far as Tomcat is concerned, all DBs are the same. Tomcat provides support for connection pooling for J2EE DataSources. By default the implementation uses DBCP (http://jakarta.apache.org/commons/dbcp). The Tomcat DataSources how-to has MySQL configuration examples: http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples -howto.html. The application code is standard again, not specific to Tomcat or MySQL. Any JDBC app will do. Yoav Shapira Millennium Research Informatics >-----Original Message----- >From: Harold Pritchett [mailto:[EMAIL PROTECTED] >Sent: Monday, August 02, 2004 3:55 PM >To: Tomcat Users List >Subject: looking for tomcat/mysql examples > >Hello again. In a couple of weeks, I am giving a seminar on >installing and configuring software to create an open-source >web site. This is to be a hands-on lab with the attendees >actually installing and configuring the software. It's an >all day affair. > >The software I'm using for this program includes: > > SuSE Standard Server 8.0 > openssl 0.9.7d > Apache HTTPD 2.0.50 > Sun Java j2sdk-1_4_2_05 > Jakarta Tomcat 4.1.30 > Jakarta Tomcat Connector jk2-2.0.4 > MySQL 4.0.20 > >I need one more thing for this. I'd like to find a simple >application demonstrating the accessing of a MySQL database >from the web via a tomcat application. Either a JSP or a >servlet (which ever is simpler.) > >Does anyone have any suggestions where I can find such an >application (or have any code they wish to donate to my >cause?) > >Thanks again for the help > >Harold >-- >Harold Pritchett >[EMAIL PROTECTED] +1.706.546.0692 >pgp public key: http://www.arches.uga.edu/~harold/pgpkey.html > >"They that can give up essential liberty to obtain a little >temporary safety deserve neither liberty nor safety." > Benjamin Franklin, Historical Review of Pennsylvania, 1759. > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]