Return-Path: 
 <tomcat-user-return-115062-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 88386 invoked from network); 15 Nov 2004 18:05:29 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 15 Nov 2004 18:05:29 -0000
Received: (qmail 70916 invoked by uid 500); 15 Nov 2004 18:04:45 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 70897 invoked by uid 500); 15 Nov 2004 18:04:45 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 70874 invoked by uid 99); 15 Nov 2004 18:04:44 -0000
X-ASF-Spam-Status: No, hits=0.6 required=10.0
	tests=FROM_ENDS_IN_NUMS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from [216.221.81.25] (HELO fep1.cogeco.net) (216.221.81.25)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 15 Nov 2004 10:04:41 -0800
Received: from t (d57-187-107.home.cgocable.net [24.57.187.107])
	by fep1.cogeco.net (Postfix) with SMTP id 511BD6883
	for <tomcat-user@jakarta.apache.org>; Mon, 15 Nov 2004 13:04:35 -0500 (EST)
Message-ID: <009c01c4cb3d$91ff7ca0$6bbb3918@t>
From: "Ed Sykes" <esykes001@cogeco.ca>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
References: <5684A7E6FB10504393A2806C1F4C021003B0E6BB@orion.qas.com>
Subject: Re: Cannot create JDBC driver of class '' for connect URL 'null'
Date: Mon, 15 Nov 2004 13:04:37 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Hi Allistair,

Thank you very much for helping.

Here's my revised server.xml :

<Context docBase="/ROOT" reloadable="true">

   <Resource name="jdbc/myoracle" auth="Container"
              type="javax.sql.DataSource" 
driverClassName="oracle.jdbc.driver.OracleDriver"
              url="jdbc:oracle:thin:@newton.sheridanc.on.ca:1522:DB2"
              username="jits" password="testing" maxActive="20" maxIdle="10"
              maxWait="-1"/>


    </Context>


it is located inside   the <Host>  </Host>  tag

Unfortunately, Tomcat responds with:

SEVERE:  Catalina.stop:
java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)

etc.

and doesn't start.


Just to make things clear here is the location of the important stuff:

my JDBC files:
C:\jakarta-tomcat-5.5.4\common\lib

my server.xml:
C:\jakarta-tomcat-5.5.4\conf

my web app:
C:\jakarta-tomcat-5.5.4\webapps\ROOT\WEB-INF\classes\JITS

the web app web.xml file:
C:\jakarta-tomcat-5.5.4\webapps\ROOT\WEB-INF


Thanks,
Ed Sykes



----- Original Message ----- 
From: "Allistair Crossley" <Allistair.Crossley@QAS.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Monday, November 15, 2004 12:25 PM
Subject: RE: Cannot create JDBC driver of class '' for connect URL 'null'


your docBase should be /ROOT which should in turn contain WEB-INF/web.xml 
and path can be scrapped

<Context docBase="/ROOT" reloadable="true">

ADC

> -----Original Message-----
> From: Ed Sykes [mailto:esykes001@cogeco.ca]
> Sent: 15 November 2004 17:24
> To: Tomcat Users List
> Subject: Re: Cannot create JDBC driver of class '' for connect URL
> 'null'
>
>
> Hi Yoav Shapira,
>
> Thank you for your help.
>
> I've corrected my server.xml file.  the first line now looks like:
> <Context path="ROOT" docBase=""
>
> Tomcat starts up properly.
>
> The Oracle JDBC driver (classes12.jar, classes12dms.jar, and
> nls_charset12.jar)  are in:
>
> C:\jakarta-tomcat-5.5.4\common\lib
>
>
> One thing I am worried about is, during Tomcat startup, the
> log produces:
> INFO: Missing application web.xml, using defaults only
> StandardEngine[Catalina].StandardHost[localhost].StandardContext[ROOT]
>
> do you think this is related to the problem?
> it is curious because Tomcat can find and serve up the
> Servlet which is
> defined in the web.xml file...
>
> Thanks
> -Ed Sykes
>
>
>
>
> ----- Original Message ----- 
> From: "Shapira, Yoav" <Yoav.Shapira@mpi.com>
> To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> Sent: Monday, November 15, 2004 11:59 AM
> Subject: RE: Cannot create JDBC driver of class '' for
> connect URL 'null'
>
>
>
> Hi,
>
> ><Context path="/ROOT/WEB-INF/classes"
> docBase="ROOT/WEB-INF/classes/JITS"
>
> I really doubt you mean these.  The context path attribute is the URL
> path used by browsers to retrieve your web pages, i.e.
> http://yourhost:yourport/path.  It's not a filesystem path.
>
> The context docBase is the root of your webapp.  It should point to a
> directory which has a WEB-INF subdirectory containing web.xml.
> Therefore, I'm guessting your docBase is just "ROOT" and your path is
> "".  Drop the Web-INF/classes part from both.
>
> >   <Resource name="jdbc/myoracle" auth="Container"
> >
> >              type="javax.sql.DataSource"
> >driverClassName="oracle.jdbc.driver.OracleDriver"
> >
> >              url="jdbc:oracle:thin:@newton.sheridanc.on.ca:1522:DB2"
> >
> >              username="jits" password="mypassword" maxActive="20"
> >maxIdle="10"
> >
> >              maxWait="-1"/>
>
> This looks reasonable.
>
> ><ResourceParams name="jdbc/myoracle">
>
> As Allistair pointed out and the docs explain, this is no
> longer needed
> in Tomcat 5.5, and should be removed.
>
> >org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
> driver
> >of class '' for connect URL 'null'
>
> Where is your JDBC driver file?  In common/lib or WEB-INF/lib?  It
> should be the former if you're using DBCP this way.  The latter would
> work using the primitive DriverManager approach and fail with DBCP.
>
> Yoav Shapira http://www.yoavshapira.com
>
>
>
> 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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>


<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href="http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org