problem with SQL tags

Fri, 15 Nov 2002 16:26:02 -0800

Hello All,

I am hoping that someone can help me to get going with the SQL tags. I'm trying to connect to a mysql database using tomcat4.1.12 and version 1.0.2 of the library.

Here's my JSP:

<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql"; %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core"; %>

<HTML>
<HEAD>
</HEAD>
<BODY>
<sql:setDataSource var="monitorDS"
url="jdbc:mysql://myhost.noaa.gov:3306/testdb"
driver="org.gjt.mm.mysql.Driver"
user="testuser"
password="testpass"
/>
</BODY>
</HTML>

I'm getting a:
org.apache.jasper.JasperException: Unable to get connection, DataSource invalid: "No suitable driver"

exception thrown even though a very similar JSP using standard JDBC connection methods (listed below) works fine.

Connection con;
try {
Class.forName("org.gjt.mm.mysql.Driver");
con = DriverManager.getConnection("jdbc:mysql://myhost.noaa.gov:3306/testdb","testuser","testpass");
} catch (Exception e) {
throw (new ServletException("Error loading Driver: " +e.getMessage()));
}



Can someone help me?

Thanks!


-- john

=====================================================
John Cartwright
Associate Scientist
Geospatial Data Services Group
CIRES, National Geophysical Data Center/NOAA
(303) 497-6284
[EMAIL PROTECTED]
=====================================================



--
To unsubscribe, e-mail: <mailto:taglibs-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:taglibs-user-help@;jakarta.apache.org>

Reply via email to