Hi,
does anyone have any other suggestions that I should try? should i try an earlier version of Tomcat?
thanks,
Ed Sykes
----- Original Message ----- From: "Allistair Crossley" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Monday, November 15, 2004 1:28 PM
Subject: RE: Cannot create JDBC driver of class '' for connect URL 'null'
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
