JavaWorld Forums: Tomcat 5.5 MySQL JNDI Datasource configuration pro

Hi... I've been trying to configure my MySQL Database with Tomcat JNDI but I can't. It's always throwing the following exception:
Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver found for jdbc/TestDB"

My context.xml source is given below:




<Context>

<WatchedResource>WEB-INF/web.xml</WatchedResource>




<Resource name="jdbc/testDB" auth="Container"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000"
removeAbandoned="true" username="root" password="root" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/test?autoReconnect=true&useUnicode=true"
removeAbandonedTimeout="60" logAbandoned="true"/>

</Context>

Also I put mysql-connector-java-5.1.6-bin.jar in common/lib folder of tomcat.

Could anyone tell me what's happening with my JNDI configuration?

Thanks

Rashed

InfoWorld: Modernizing IT

JavaWorld: Solutions for Java Developers