I got this error displayed on browser
Error: org.apache.tomcat.dbcp.dbc
p.SQLNeste
dException
: Cannot create JDBC driver of class '' for connect URL 'null'
My code are in C:\Unleashed Book\deploy\apps\unleashed
resources.jsp
----
<html>
<%@ page language="java"
import="javax.sql.*,javax.
naming.*,j
ava.sql.*"
session="false"%>
<head>
<style type="text/css">
<!--
a { text-decoration: none }
body { font-family: verdana, helvetica, sans serif; font-size: 10pt; }
-->
</style>
</head>
<body>
<center>
<h3>This is a test of a Tomcat-managed connection pool</h3>
</center>
<%
try {
String jdbcname = "jdbc/unleashed";
String cmd = "select title, url from TomcatResources order by title";
Context ctx = new InitialContext();
Context envCtx = (Context)ctx.lookup("java:
comp/env")
;
DataSource ds = (DataSource)envCtx.lookup(
jdbcname);
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(cmd);
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
out.println("<table border\"1\">");
out.println("<tr bgcolor=\"lightGrey\">");
for (int i = 1; i <= cols; i++) {
out.println("<td align=\"center\" width=\"200\"><b>" +
rsmd.getColumnName(i) + "</b></td>");
}
out.println("</tr>");
while (rs.next()) {
out.println("<tr>");
for (int i = 1; i <= cols; i++) {
out.println("<td align=\"left\">" +
rs.getString(i) + "</td>");
}
out.println("</tr>");
}
out.println("</table>");
conn.close();
} catch(Exception e) {
out.println("Error: " + e);
e.printStackTrace();
}
%>
</body>
</html>
WEB-INF\web.xml
----
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app>
<display-name>This is display name</display-name>
<description>This is description</description>
</web-app>
My Context of my application is declared in C:\Program Files\Apache Software Foundation\Tomcat 5.5\conf\Catalina\localhos
t\unleashe
d.xml
<Context path="/unleashed" docBase="C:\Unleashed Book\deploy\apps\unleashed
" debug="0" privleged="true">
<Resource name="jdbc/unleashed" auth="Container"
type="javax.sql.DataSource
"/>
<ResourceParams name="jdbc/unleashed">
<parameter><name>username<
/name><val
ue>root</v
alue></par
ameter>
<parameter><name>password<
/name><val
ue>passwor
d</value><
/parameter
>
<parameter><name>driverCla
ssName</na
me>
<value>org.gjt.mm.mysql.Dr
iver</valu
e></parame
ter>
<parameter><name>url</name
>
<value>jdbc:mysql://localh
ost/unleas
hed</value
></paramet
er>
</ResourceParams>
</Context>
I just downloaded and installed MySQL 4.1. I also downloaded MySQL Connector 3.1 for my JDBC. I extracted the connector and found 2 .jar files. I chose mysql-connector-java-3.1.1
0-bin.jar and I hope I am correct. Am I correct? What is the other file for? I then placed in mysql-connector-java-3.1.1
0-bin.jar C:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib
Am I doing correct?
