Hello,
I am trying to get a
jsp page to run a SQL query on it. When I run the page it comes up with an error saying No Suitable Driver Found.
I am using a conext.xml and a web.xml file to define a Datasource. It works on my other computer which is running windows. But this page is on an ubuntu server. I put the mysql-connector-java-5.1.7-bin.jar in the /usr/share/tomcat6/lib folder. I also put it in the WEB-INF/lib directory. I wrote a
java application that uses the same connection
string and it works just fine. It errors on this line
<sql:query var="rs" dataSource="jdbc/TestDB">
The URL is
http://www.hitlessons.com/DBtest/test.jsp
Context file
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/DBtest" docBase="DBtest"
debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="****" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/testdb?autoReconnect=true"/>
</Context>
Do I need to change the path or something?
Thanks for any help