Return-Path: 
 <users-return-149065-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: (qmail 85222 invoked from network); 31 Jul 2006 18:53:59 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 31 Jul 2006 18:53:59 -0000
Received: (qmail 5405 invoked by uid 500); 31 Jul 2006 18:53:35 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 5377 invoked by uid 500); 31 Jul 2006 18:53:35 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 5327 invoked by uid 99); 31 Jul 2006 18:53:35 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 Jul 2006 11:53:35 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [128.253.83.141] (HELO authusersmtp.mail.cornell.edu)
 (128.253.83.141)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 Jul 2006 11:53:34 -0700
Received: from [128.253.38.244] (defiant.ento.cornell.edu [128.253.38.244])
	(authenticated bits=0)
	by authusersmtp.mail.cornell.edu (8.13.1/8.12.10) with ESMTP id
 k6VIrDqQ018510
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT)
	for <users@tomcat.apache.org>; Mon, 31 Jul 2006 14:53:13 -0400 (EDT)
Message-ID: <44CE5198.6080806@cornell.edu>
Date: Mon, 31 Jul 2006 14:53:12 -0400
From: David Smith <dns4@cornell.edu>
User-Agent: Mozilla Thunderbird 1.0.6 (Macintosh/20050716)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
 JDBC driver of class '' for connect URL 'null'
References: <ED60006BDEDB4C4C90A31961F166FDAB070542@EXCHANGE3.uspto.gov>
In-Reply-To: <ED60006BDEDB4C4C90A31961F166FDAB070542@EXCHANGE3.uspto.gov>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Is your SQL JDBC driver in common/lib?  It has to be there for tomcat to 
set it up as a resource.

Also drop the <ResourceLink.../> tag from your context definition.  Not 
needed when the resource is defined inside the <Context...> tag and may 
confuse tomcat.

--David

Aynalem, Seblewengel (Trawick) wrote:

>Hi there:
>I am using tomcat 5.5.17 and SQL Server 2000 database with SQL Server 2005 JDBC Driver.  OS is Windows XP professional.  I have configured web.xml in WEB-INF directory and context.xml in META-INF directory of my application. Both are attached below with this email. I have a login.jsp page that asks for username and password... and when submit is hit, it gives the following error.
>org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' 
>I tried to google and tried the suggestion given but any of them doesn't seem to work. Is there anything wrong with my configuration? PLEASE HELP...it is higly appreciated. If something is not clear, please get back to me.  Thank you so much.
>context.xml file looks like this...
><?xml version="1.0" encoding="UTF-8"?>
><Context debug="0" displayName="ISOTracking" docBase="C:\Java\TomcatTestServer\apache-tomcat-5.5.17\webapps\ISOTrackingTest" path="/ISOTracking" reloadable="true">
>  	<Logger className="org.apache.catalina.logger.FileLogger" 
>	prefix="ISOTRackingTest_Log." suffix=".txt" timestamp="true"/>
>	<!-- Define a database connection pool for SQL SERVER 2000 -->
>  	<Resource name="jdbc/sqlserver" auth="Container" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>	url="jdbc:sqlserver://localhost:1433" username="xxx" password="xxx"maxActive="100" maxIdle="30" maxWait="10000" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>
>	<ResourceLink name="jdbc/sqlserver" type="javax.sql.DataSource" global="jdbc/sqlserver"/>
></Context>
>web.xml looks like this...
><?xml version="1.0" encoding="ISO-8859-1"?>
><!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
><web-app>
>  <display-name>ISOTracking</display-name>
>  <description>
>     Welcome TO ISO Tracking Application
>  </description>
><!-- JSPC servlet mappings start -->
>    <servlet>
>        <servlet-name>ISOTracking.Login_jsp</servlet-name>
>        <servlet-class>ISOTracking.Login_jsp</servlet-class>
>    </servlet>
>    <servlet-mapping>
>        <servlet-name>ISOTracking.Login_jsp</servlet-name>
>        <url-pattern>/Login.jsp</url-pattern>
>    </servlet-mapping>
>    <session-config>
>     <session-timeout>30</session-timeout>
>    </session-config>
><!-- JSPC servlet mappings end -->
>	<resource-ref>
>		<res-ref-name>jdbc/sqlserver</res-ref-name>
>		<res-type>javax.sql.DataSource</res-type>
>		<res-auth>Container</res-auth>
>	</resource-ref>
></web-app>
>
>
>
>
>---------------------------------------------------------------------
>To start a new topic, e-mail: users@tomcat.apache.org
>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>For additional commands, e-mail: users-help@tomcat.apache.org
>
>  
>


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org