actually that may also be the jdbc connectivity ;) you are sure your database
listener is operational?
-----Original Message-----
From: Ed Sykes [mailto:[EMAIL PROTECTED]
Sent: Mon 15/11/2004 18:04
To: Tomcat Users List
Cc:
Subject: Re: Cannot create JDBC driver of class '' for connect URL
'null'
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" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]>
> To: "Tomcat Users List" <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
<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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
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]
