[GERONIMO-683] Unable to establish a connection between mysql and geronimo, the problem is at deployment

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Incomplete
• Affects Version/s: 1.0-M3
• Component/s: deployment

Environment

Microsoft windows 2000, using platform java -1.4

• Assignee: Unassigned
• Reporter: vidyasree
• Created: 20/Jun/05 14:07
• Updated: 07/Aug/06 15:05
• Resolved: 23/Jul/05 07:04

Description

The versions of mysql and the drivers that i am using:

Installed mysql version mysql-essential-4.1.12-win32 windows Installer package
and I am using one of the following drivers

1)mysql-connector-java-3.0.16-ga.tar.jar
2)mysql-connector-java-3.1.8-bin.jar
3)mysql-connector-java-3.1.8-bin-g.jar files for connecting and
the ODBCdriver I have installed is
4)mysql ODBC 3.51 Driver

The steps i which i am deploying:

I am setting the classpath of the mysql connector/J jar file which i am using.

1. creating a folder in c:\test and saving the mysql-plan.xml and geronimo-jetty.xml
2. Then creating another folder c:\test\WEB-INF\ and saving web.xml
3. Then creating another folder c:\test\jsp\ and saving dbtest.jsp file
4. creating a war file in c:\test with name GeronimoTestWebApp
5. starting geronimo server
6. Then deploying mysqlpool as mentioned
7. Then deploying GeronimoTestWebApp
8. Then running in the explorer as http://localhost:8080/GeronimoTestWebApp/jsp/dbtest.jsp
9. Then it is giving the exception "java.sql.SQLException"

Reply me as soon as possible