tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ed Sykes" <esykes...@cogeco.ca>
Subject Re: Cannot create JDBC driver of class '' for connect URL 'null'
Date Wed, 17 Nov 2004 16:11:48 GMT
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" <Allistair.Crossley@QAS.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
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:esykes001@cogeco.ca]
> 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" <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
>
>
>
>


--------------------------------------------------------------------------------


> ---------------------------------------------------------------------
> 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


Mime
View raw message