Re: Cannot create JDBC driver of class '' for connect URL 'null'

[Ed Sykes]

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]