DB Test

Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org Received: (qmail 75758 invoked from network); 2 Jul 2004 16:40:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 2 Jul 2004 16:40:26 -0000 Received: (qmail 96589 invoked by uid 500); 2 Jul 2004 16:39:53 -0000 Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org Received: (qmail 96425 invoked by uid 500); 2 Jul 2004 16:39:52 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 96356 invoked by uid 99); 2 Jul 2004 16:39:51 -0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=HTML_60_70,HTML_MESSAGE X-Spam-Check-By: apache.org Received: from [216.127.34.198] (HELO tec-egta.clinitech.net) (216.127.34.198) by apache.org (qpsmtpd/0.27.1) with ESMTP; Fri, 02 Jul 2004 09:39:49 -0700 Received: from 172.20.224.60 by tec-egta.clinitech.net with ESMTP (SMTP Relay); Fri, 02 Jul 2004 09:40:32 -0700 X-Server-Uuid: C7F216EA-4BBE-4B77-A931-39F4DC6E366D Received: by TEC-EXCHANGE with Internet Mail Service (5.5.2657.72) id <31FGZBTY>; Fri, 2 Jul 2004 09:36:11 -0700 Message-ID: From: "Briggs, Patrick" To: "'Tomcat Users List'" Subject: RE: Tomcat -> MySQL = No suitable driver ERROR Date: Fri, 2 Jul 2004 09:36:11 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) X-WSS-ID: 6CFB4F8A1MC109934-01-01 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C46052.2FCA61D6" X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N ------_=_NextPart_001_01C46052.2FCA61D6 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit David had me do this following proceedure and that seemed to work, but my JSP does not return any data so far. The database finally connected though. When I view this JSP page, all it prints is: ${row.foo} ${row.bar} instead of the data that should be contained inside those variables. test.jsp: <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> select * from testdata DB Test

Results

>From David: Here's first what should be in {TOMCAT_HOME}/conf/Catalina/localhost/DBTest.xml: factory org.apache.commons.dbcp.BasicDataSourceFactory maxActive 100 maxIdle 30 maxWait 100000 username DBTestUser password ********* driverClassName com.mysql.jdbc.Driver url jdbc:mysql://localhost:3306/DBTest?autoReconnect=true ----------------------------------------------------- Ok, now what should be in {TOMCAT_HOME}/webapps/DBTest/WEB-INF/web.xml:

DbTest Application

DBTest Database

jdbc/DbTest

javax.sql.DataSource

Container

--------------------------------------------------------- This exact formula has worked for me in I can't even count how many apps I've setup. --David -----Original Message----- From: Jan Behrens [mailto:jan@diekleinedomain.de] Sent: Friday, July 02, 2004 1:50 AM To: 'Tomcat Users List' Subject: RE: Tomcat -> MySQL = No suitable driver ERROR yes patrick, i guess that is what david and i want so your dbtest works. allthough the posted contents of web.xml lack a doctype or schema definition (see hassans post). now, have you tried this? cheers, jan This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy the message. ------_=_NextPart_001_01C46052.2FCA61D6--