tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From A Df <abbey_dragonfor...@yahoo.com>
Subject Tomcat 6 not working with JDBC driver for MySQL
Date Mon, 25 Jul 2011 20:40:45 GMT
Dear All:

I have read numerous posts and documentation and now I really need help.


I am using the following:

Product Version: NetBeans IDE 7.0 (Build 201104080000)
Java: 1.6.0_26; Java HotSpot(TM) Client VM 20.1-b02
System: Windows 7 version 6.1 running on x86; 
Apache Tomcat 6.0.26
MySQL Version: 5.5.14
MySQL Connector/J JDBC Driver 5.1.17


I performed the steps below as follows:

I have added the MySQL Connector/J JDBC Driver to the $CATALINA_HOME/lib directory

I have modify the web application deployment descriptor (/WEB-INF/web.xml) 
<CODE>
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
    <session-config>
        <session-timeout>
            30
        </session-timeout>
    </session-config>
    <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>
    <resource-ref>
        <description>
    Resource reference to a factory for java.sql.Connection
    instances that may be used for talking to a particular
    database that is configured in the Context
   
 configurartion for the web application.
        </description>
        <res-ref-name>
    jdbc/myDB
        </res-ref-name>
        <res-type>
    javax.sql.DataSource
        </res-type>
        <res-auth>
    Container
        </res-auth>
    </resource-ref>
</web-app>
</CODE>

I have modified the XML file (META-INF/context.xml) found in the project’s folders
<CODE>
<?xml version="1.0" encoding="UTF-8"?>
<Context crossContext="true" debug="5" docBase="TweetCollector" antiJARLocking="true" path="/TweetCollector"
 reloadable="true">  
    <Resource name="jdbc/myDB"
            auth="Container"
            type="javax.sql.DataSource"
            username="root"
            password="administrator"
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost:3306/myDB?autoReconnect=true"
            maxActive="8"
            maxIdle="4"/>
</Context>
</CODE>

I have modified the code in the java class for the database
 connection
<CODE>
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)
  envCtx.lookup("jdbc/myDB");

setConnectionDB(ds.getConnection());
</CODE>

I
 read the steps at 
http://tomcat.apache.org/tomcat-6.0-doc/jndi-resources-howto.html#JDBC_Data_Sources.
 I have also tried modifying the server.xml file. 

The connection in the log prints as
jdbc:mysql://localhost:3306/myDB?autoReconnect=true, UserName=root@localhost, MySQL-AB JDBC
Driver

However, it gives the error:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver
OR
java.sql.SQLException: No suitable driver

Is
 it that the version for the server needs to match specific version for 
MySQL and its driver? How can I solve the JDBC issue? I have tried so 
many posts and made so many changes that i am really frustrated and dont
 know
 what else to do. Thanks.

Cheers
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message