Article:
  Creating a Web Application with Ant and Tomcat 4
Subject:   solution to database connection problem
Date:   2003-06-12 03:57:36
From:   anonymous2
Hi,


I experienced similar problems in connecting to the database as mentioned by others. After changing to another version of the mysql connector it works fine! It could very well be the combination with the MySql version.


This one does not work:
mysql-connector-java-3.1.0-alpha-bin.jar


This one does work:
mysql-connector-java-3.0.8-stable-bin.jar


This file is to be placed in common/lib as mentioned.


OS: Win2000Pro EN
Tomcat: 4.1.24
Ant: 1.5.3-1
MySQL: 4.1.0-alpha-max-debug


One more detail: after 'create database public' a 'use public' command is necessary. Mysql automatically changes the name of the database to lower case.


Good article, thanks a lot!


Jan-Willem Arnold