No suitable driver Problem (not the usually problem) -
10-02-2003
, 02:01 AM
hi all,
first of all, I think i am not a naive MySql user and I have done some
research on this problem but got no luck.
I am trying to use JSTL tag lib and Tomcat 5.0 to access MySql
database.
I have an index.jsp file contains ONLY following lines
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<sql:setDataSource var="datasource" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/test"/>
I also put the Mysql JDBC connect driver into the /WEB-INF/lib folder.
However, the tomcat server throw out "No suitable driver" error
message.
I do not understand what's going wrong and I remember I have
succssfully run this program before!
I suspect this may relates to port problem, the default port 3306 may
already in use and I do not know how to change it.
Can any one give me some suggestion?
Thanks |