Hi,
I was away for 2 weeks.
Now checked:
>> As soon as I copy mysql-connector-java-5.1.5-bin.jar
>> into /usr/share/tomcat5/common/lib, --restart tomcat5--
>> and try test.jsp, I get this:
>> javax.servlet.ServletException: Unable to get connection, DataSource
>> invalid: "java.sql.SQLException: No suitable driver found for
>> jdbc:mysql://localhost:3306/javatest?user=javauser&password=javadude"
>Did you restart tomcat after the move? It's required when you change
>the contents of common/lib.
I restarted tomcat after having moved the driver. (/etc/init.d/tomcat5 restart)
If I rename the driver in
/usr/share/tomcat5/common/lib to xmysql-connector-java-5.1.5-bin.jar
and restart tomcat, I get again:
Results
${row.foo} ${row.bar}
----------------
jsp code:
---------
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql"; prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core"; prefix="c" %>
<sql:query var="rs"
dataSource="jdbc:mysql://localhost:3306/javatest?user=javauser&password=javadude">
select id, foo, bar from testdata
</sql:query>
<html>
<head>
<title>DB Test</title>
</head>
<body>
<h2>Results</h2>
<table>
<c:forEach var="row" items="${rs.rows}">
<tr>
<td> <c:out value="${row.foo}"/></td>
<td> <c:out value="${row.bar}"/></td>
</tr>
</c:forEach>
</table>
</body>
</html>
------
Servlet still works perfectly, just jsp fails.
Thanks in advance for any help
-eleonora
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
