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>
- Re: problem with SQL tags John C Cartwright
- Re: problem with SQL tags Hans Bergsten
- Re: problem with SQL tags John C Cartwright
- Re: problem with SQL tags Hans Bergsten
- RE: problem with SQL tags Bell, Buck (c)
- Re: problem with SQL tags Hans Bergsten
- Re: problem with SQL tags John C Cartwright
- Re: problem with SQL tags John C Cartwright
- Re: problem with SQL tags Hans Bergsten
- RE: problem with SQL tags Bell, Buck (c)