Re: Newbie Question: Problem with Tomcat and MySql
asd <nos...@nospam.com> wrote:
Copied "mysql-connector-java-5.0.5-bin.jar" file under
TOMCAT_DIR//common/lib
Why the double slash?
Andrew Thompson wrote:
To the best of my knowledge, archived classes
need to be put in WEB-INF/lib to be accessible
to the web-app (but I am no expert, especially
when it comes to D/B's).
common/lib/ and shared/lib/ are two places one can put JARs in Tomcat.
shared/lib/ is where libraries go that any app running on that app server can
use; common/lib/ is accessible to Tomcat itself as well. So one might put,
say, Apache commons libs in shared/lib/ wher all apps can get them, and a JDBC
JAR in common/lib/ so Tomcat itself can perform authentication via the DB.
asd wrote:
I changed my TOMCAT_DIR/webapps/ROOT/WEB-INF/web.xml file to
Is your test web app running in the root context? If not, you likely will need
to change the web.xml for the application you are running.
Your posted code did not have a
Class.forName( "com.mysql.jdbc.Driver" );
Did you have that code anywhere that you didn't show us? Did you set up the
load of the driver class in a property file?
asd wrote:
out.println(docType +
"<HTML>\n" +
You should start getting in the habit of using lower-case tags and attributes
in HTML.
-- Lew