SQLNestedException: Cannot create JDBC driver of class'' for connect URL

[vijay dadhwal]

Hi,

I am trying to deploy an web application in Tomcat 6.0.18.

Here is the xml files snap shots are as follows:

META-INF/context.xml file

<context >
<Resource override="true" auth="Container" driverClassName="com.mysql.jdbc.Driver"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" name="employee" password=""
type="javax.sql.DataSource" url="jdbc:mysql://localhost/employees" username="root"/>
</context>

WEB-INF/web.xml file

.....
<resource-ref>
               <description>Data source for MYSQL Employee database</description>
	<res-ref-name>employee</res-ref-name>
	<res-type>javax.sql.DataSource</res-type>
	<res-auth>Container</res-auth>
</resource-ref>
.....

jsp file

<h3>Test Employee Listing</h3>
<%@ page import="java.sql.*, javax.naming.*, javax.sql.*"%>
<%
InitialContext initctx=new InitialContext();
DataSource ds = (DataSource) initctx.lookup("java:comp/env/employee"); 

Connection con=null;
Statement stmt=null;
ResultSet rs=null;


try
{
	con=ds.getConnection();
	
	stmt=con.createStatement();
	rs=stmt.executeQuery("select * from employees");
	 while(rs.next())
	{
		out.println(rs.getString(1));
		out.println(rs.getString(2));
		
		out.println("<br>");
	}
}
 finally
	 {
	 	if (rs!=null) rs.close();
	 	if (stmt!=null) stmt.close();
	 	if (con!=null) con.close();
	 }
%>

When i deploy the war file of this application i.e. employees.war, Tomcat reads the file META-INF/context.xml file and copies it into the folder /conf/Catalina/localhost/employees.xml file.

But when i access the jsp file it gives me error "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class'' for connect URL"

If i put the

 <context><Resource override="true" auth="Container" driverClassName="com.mysql.jdbc.Driver"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" name="employee" password=""
type="javax.sql.DataSource" url="jdbc:mysql://localhost/employees" username="root"/>
</context>

in /conf/context.xml file in tomcat then my jsp file retrieves data from mysql normally.

What could be the problem ?

Regards
vijay

[Devaka Cooray]

More related to Tomcat. Moving to Tomcat forum.

[Tim Holloway]

I think maybe it's because you said "<context>". XML is case sensitive. It should be "<Context>".

[vijay dadhwal]

Thanks a ton Tim,

My p/b is resolved. This had kept me mad for a day.

Thanks a ton again.

Regards
vijay

[christo pher]

I like this forum.