Oh ya. That was the problem. :-)) It was searching for the resource in
the context. But i am surprised that its not able to access a Global
resource. Logically the top level resource ought to be available at the
lower levels too.
regards,
Isen
Shapira, Yoav wrote:
Hi,
If it's inside GlobalNamingResources, you need a <ResourceLink> to it in
your Context.
You should also place a <resource-ref> in your web.xml, but you may have
done that already (you didn't post web.xml).
Yoav Shapira
Millennium Research Informatics
-----Original Message-----
From: Isen,Ciji [mailto:[EMAIL PROTECTED]
Sent: Monday, August 02, 2004 3:49 PM
To: Tomcat Users List
Subject: Re: javax.servlet.ServletException: Cannot create JDBC driver
of
class '' for connect URL 'null', cause: No suitable driver
I wanted to tinker around hence i decide to just test using a jsp. The
jsp code is pasted below.
<[EMAIL PROTECTED] contentType="text/html"%>
<%@ page import="java.util.*" %>
<html>
<head><title>JSP Page</title></head>
<body>
<%
Connection conn = null;
DBManager dbMan = null;
Context ctx = new InitialContext();
if(ctx == null )
throw new DBLibraryBaseException("Boom - No
Context");
Context envContext=(Context)ctx.lookup("java:comp/env");
if(envContext == null )
throw new DBLibraryBaseException("Boom -
java:comp/env - No Context");
DataSource myDataSource
=(DataSource)envContext.lookup("jdbc/EconDollarsDB");
if (myDataSource != null) {
conn = myDataSource.getConnection();
}else{
System.out.println("jdbc/EconDollarsDB' is
an unknown DataSource");
}
%>
</body>
</html>
Pasted below is the server.xml files part that i added.
<Resource auth="Container" name="jdbc/EconDollarsDB"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/EconDollarsDB">
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/EconDollars?autoReconnect=true</valu
e>
</parameter>
<parameter>
<name>validationQuery</name>
<value>select * from major</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>asdf</value>
</parameter>
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>password</name>
<value>asdf</value>
</parameter>
</ResourceParams>
This is placed inside GlobalNamingResources.
Robert Bateman wrote:
Please show us the source that is causing this error...
On Monday 02 August 2004 02:44 pm, Isen,Ciji wrote:
Hi,
I am using tomcat-5. I was trying out the connection pooling in it. I
did
things as per their documentation but ended up with this error.
javax.servlet.ServletException: Cannot create JDBC driver of class ''
for
connect URL 'null', cause: No suitable driver Does anyone have any
idea
what and what this is. I am at loss why after finding the JDNI
resource
its
not able to pick up its parameters.
regards,
Isen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
This e-mail, including any attachments, is a confidential business communication, and
may contain information that is confidential, proprietary and/or privileged. This
e-mail is intended only for the individual(s) to whom it is addressed, and may not be
saved, copied, printed, disclosed or used by anyone else. If you are not the(an)
intended recipient, please immediately delete this e-mail from your computer system
and notify the sender. Thank you.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
