Hi,
I am getting error: Cannot load
JDBC driver class 'com.mysql.jdbc.Driver'
my classpath is set as C:\tomcat\common\lib\mysql-connector-java-3.1.12 which is where the com.mysql.jdbc.driver is located.
I think the problem is in my servlet.xml below:
<Resource auth="Container"description="DB Connection" name="jdbc/TestDB"
type="javax.sql.DataSource" />
<ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost/etest?autoReconnect=true</value>
</parameter>
<parameter>
<name>password</name>
<value>admin</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>