Hi,
My Development PC:
Windows XP
Netbeans 5.5.1 with tomcat 5.5.17
Mysql Database on external machine 192.168.158.240
When I test my Page1.jsp with a table (table data from external mysql DB), all it´s ok in my xp netbeans 5.5.1 develompent environment.
My Production Server (192.168.158.240):
Linux Suse 10.2 Standard Installation 64bit with
Mysql Database
Tomcat5.5-0.30-53
Apache2-2.2
When i deploy the war file to this server i get following error, when i test it.
at java.lang.Thread.run(Thread.java:595)
Cannot create JDBC driver of class '' for connect URL 'null'
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:243)
at org.apache.commons.dbcp.Basic
I put the mysql-connector-java-3.1.12.jar into /usr/share/tomcat5/common/lib but the error is always there.
Here is my context.xml from the application
/srv/www/tomcat5/base/webapps/test/META-INF/context.xml
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/test">
<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/dataSource5" password="xxxxx" type="javax.sql.DataSource" url="jdbc:mysql://192.168.158.240:3306/jamal" username="xxxx"/>
</Context>
Whenn i create a JNDI Datasoure mit the TOMCAT admin WEB Interface, the error is always there.
JNDI Name: jdbc/dataSource5
Data Source URL: jdbc:mysql://localhost:3306/jamal
JDBC Driver Class: com.mysql.jdbc.Driver
User Name: xxxxx
Password: xxxxxxx
Max. Active Connections: 20
Max. Idle Connections: 2
Max. Wait for Connection: 5000
Validation Query: SELECT 1
Please Help,
Thanks Markus
