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]
