You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "Aynalem, Seblewengel (Trawick)" <Se...@USPTO.GOV> on 2006/08/01 14:13:45 UTC
RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create JDBC driver of class '' for connect URL 'null'
Thanks David. I am able to connect to SQL Server 2000. Actually Tomcat 5.5.17 and SQL Server 2000 is on the same machine that I am working on. Could there be any other cause for this error:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect)
-----Original Message-----
From: David Smith [mailto:dns4@cornell.edu]
Sent: Monday, July 31, 2006 4:21 PM
To: Tomcat Users List
Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create JDBC driver of class '' for connect URL 'null'
Well.... this is supposed to be an "SQL Server 2000" database server.
Use it's client tool to connect to the database. If successful, your
server is running. I'm not familiar with the product, but if you can
find it in the preferences, make sure you connect via TCP just like
tomcat would.
--David
Aynalem, Seblewengel (Trawick) wrote:
>Sorry to ask this... how do you verify server connection independently. This is my first time configuring doing database connection. Thanks a lot,
>
>-----Original Message-----
>From: David Smith [mailto:dns4@cornell.edu]
>Sent: Monday, July 31, 2006 3:49 PM
>To: Tomcat Users List
>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>create JDBC driver of class '' for connect URL 'null'
>
>
>Hmmm.... connection refused. Is your server listening for connections
>at jdbc:sqlserver://localhost:1433 ? Can you verify it independently?
>
>--David
>
>
>
>Aynalem, Seblewengel (Trawick) wrote:
>
>
>
>>Thanks a lot... I do need to have a space in context.xml file. That solved the problem with xml syntax. I now seem to have problem with database connection. Here is the code I use to connect...
>>
>>InitialContext ic=null;
>>
>>DataSource ds=null;
>>
>>Connection conn = null;
>>
>>try {
>> // testing
>> ic = new InitialContext();
>> ds = (DataSource)ic.lookup("java:comp/env/jdbc/sqlserver");
>> conn = ds.getConnection();
>> } catch (Exception e) {
>> StringWriter sw = new StringWriter();
>> e.printStackTrace(new PrintWriter(sw, true));
>> lastError = sw.toString();
>> System.out.println(lastError);
>> return false;
>> }
>>
>>And the error I get is this...
>>
>>lasterror org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at ISOTracking.SessionBean.login(SessionBean.java:217) at org.apache.jsp.ISOTracking.LoginAction_jsp._jspService(LoginAction_jsp.java:57) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) ... 23 more error Cannot create PoolableConnectionFactory (The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect)
>>
>>-----Original Message-----
>>From: Saha Rabindra N [mailto:Rabindra.Saha@acs-hro.com]
>>Sent: Monday, July 31, 2006 3:21 PM
>>To: Tomcat Users List
>>Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>create JDBC driver of class '' for connect URL 'null'
>>
>>
>>You could open your context.xml file using IE browser and that will tell you the syntax problem, if any.
>>
>>
>>
>>-----Original Message-----
>>From: Aynalem, Seblewengel (Trawick)
>>[mailto:Seblewengel.Aynalem@USPTO.GOV]
>>Sent: Monday, July 31, 2006 3:18 PM
>>To: Tomcat Users List
>>Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>create JDBC driver of class '' for connect URL 'null'
>>
>>
>>Hi Filip:
>>
>>I checked it... what is it missing? Many thanks your help.
>>
>>-----Original Message-----
>>From: Filip Hanik - Dev Lists [mailto:devlists@hanik.com]
>>Sent: Monday, July 31, 2006 3:12 PM
>>To: Tomcat Users List
>>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>create JDBC driver of class '' for connect URL 'null'
>>
>>
>>looks like your context XML file is not a valid XML format
>>
>>Filip
>>
>>
>>Aynalem, Seblewengel (Trawick) wrote:
>>
>>
>>
>>
>>>Yes I do have SQL JDBC driver in common/lib as sqljdbc.jar and did drop <ResourceLink.../> from context.xml file. Another error comes ups as follows:
>>>
>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
>>>INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Java\jdk1.5.0_07\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Roxio Shared\DLLShared;C:\Java\jdk1.5.0_07\bin;%CATALINA_BASE%\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
>>>Jul 31, 2006 3:01:05 PM org.apache.coyote.http11.Http11BaseProtocol init
>>>INFO: Initializing Coyote HTTP/1.1 on http-8080
>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.startup.Catalina load
>>>INFO: Initialization processed in 1732 ms
>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardService start
>>>INFO: Starting service Catalina
>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardEngine start
>>>INFO: Starting Servlet Engine: Apache Tomcat/5.5.17
>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardHost start
>>>INFO: XML validation disabled
>>>Jul 31, 2006 3:01:08 PM org.apache.tomcat.util.digester.Digester fatalError
>>>SEVERE: Parse Fatal Error at line 11 column 79: Element type "Resource" must be followed by either attribute specifications, ">" or "/>".
>>>org.xml.sax.SAXParseException: Element type "Resource" must be followed by either attribute specifications, ">" or "/>".
>>> at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
>>> at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:215)
>>> at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:386)
>>> at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
>>> at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1438)
>>> at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:845)
>>> at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1693)
>>> at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
>>> at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
>>> at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
>>> at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
>>> at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
>>> at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561)
>>> at org.apache.catalina.startup.ContextConfig.processContextConfig(ContextConfig.java:781)
>>> at org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.java:721)
>>> at org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:977)
>>> at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:278)
>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>> at org.apache.catalina.core.StandardContext.init(StandardContext.java:5130)
>>> at org.apache.catalina.core.StandardContext.start(StandardContext.java:3945)
>>> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
>>> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
>>> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
>>> at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904)
>>> at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867)
>>> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)
>>> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
>>> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
>>> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
>>> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
>>> at org.apache.catalina.core.StandardService.start(StandardService.java:450)
>>> at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
>>> at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:585)
>>> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
>>> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfig processContextConfig
>>>SEVERE: Parse error in default web.xml
>>>org.xml.sax.SAXParseException: Element type "Resource" must be followed by either attribute specifications, ">" or "/>".
>>> at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1269)
>>> at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561)
>>> at org.apache.catalina.startup.ContextConfig.processContextConfig(ContextConfig.java:781)
>>> at org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.java:721)
>>> at org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:977)
>>> at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:278)
>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>> at org.apache.catalina.core.StandardContext.init(StandardContext.java:5130)
>>> at org.apache.catalina.core.StandardContext.start(StandardContext.java:3945)
>>> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
>>> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
>>> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
>>> at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904)
>>> at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867)
>>> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)
>>> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
>>> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
>>> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
>>> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
>>> at org.apache.catalina.core.StandardService.start(StandardService.java:450)
>>> at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
>>> at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:585)
>>> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
>>> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfig processContextConfig
>>>SEVERE: Occurred at line 11 column 79
>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfig start
>>>SEVERE: Marking this application unavailable due to previous error(s)
>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.core.StandardContext start
>>>SEVERE: Error getConfigured
>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.core.StandardContext start
>>>SEVERE: Context [/ISOTrackingTest] startup failed due to previous errors
>>>Jul 31, 2006 3:01:09 PM org.apache.coyote.http11.Http11BaseProtocol start
>>>INFO: Starting Coyote HTTP/1.1 on http-8080
>>>Jul 31, 2006 3:01:10 PM org.apache.jk.common.ChannelSocket init
>>>INFO: JK: ajp13 listening on /0.0.0.0:8009
>>>Jul 31, 2006 3:01:10 PM org.apache.jk.server.JkMain start
>>>INFO: Jk running ID=0 time=0/70 config=null
>>>Jul 31, 2006 3:01:10 PM org.apache.catalina.storeconfig.StoreLoader load
>>>INFO: Find registry server-registry.xml at classpath resource
>>>Jul 31, 2006 3:01:10 PM org.apache.catalina.startup.Catalina start
>>>INFO: Server startup in 5147 ms
>>>
>>>-----Original Message-----
>>>From: David Smith [mailto:dns4@cornell.edu]
>>>Sent: Monday, July 31, 2006 2:53 PM
>>>To: Tomcat Users List
>>>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>>create JDBC driver of class '' for connect URL 'null'
>>>
>>>
>>>Is your SQL JDBC driver in common/lib? It has to be there for tomcat to
>>>set it up as a resource.
>>>
>>>Also drop the <ResourceLink.../> tag from your context definition. Not
>>>needed when the resource is defined inside the <Context...> tag and may
>>>confuse tomcat.
>>>
>>>--David
>>>
>>>Aynalem, Seblewengel (Trawick) wrote:
>>>
>>>
>>>
>>>
>>>
>>>
>>>>Hi there:
>>>>I am using tomcat 5.5.17 and SQL Server 2000 database with SQL Server 2005 JDBC Driver. OS is Windows XP professional. I have configured web.xml in WEB-INF directory and context.xml in META-INF directory of my application. Both are attached below with this email. I have a login.jsp page that asks for username and password... and when submit is hit, it gives the following error.
>>>>org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
>>>>I tried to google and tried the suggestion given but any of them doesn't seem to work. Is there anything wrong with my configuration? PLEASE HELP...it is higly appreciated. If something is not clear, please get back to me. Thank you so much.
>>>>context.xml file looks like this...
>>>><?xml version="1.0" encoding="UTF-8"?>
>>>><Context debug="0" displayName="ISOTracking" docBase="C:\Java\TomcatTestServer\apache-tomcat-5.5.17\webapps\ISOTrackingTest" path="/ISOTracking" reloadable="true">
>>>> <Logger className="org.apache.catalina.logger.FileLogger"
>>>> prefix="ISOTRackingTest_Log." suffix=".txt" timestamp="true"/>
>>>> <!-- Define a database connection pool for SQL SERVER 2000 -->
>>>> <Resource name="jdbc/sqlserver" auth="Container" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>>>> url="jdbc:sqlserver://localhost:1433" username="xxx" password="xxx"maxActive="100" maxIdle="30" maxWait="10000" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>
>>>> <ResourceLink name="jdbc/sqlserver" type="javax.sql.DataSource" global="jdbc/sqlserver"/>
>>>></Context>
>>>>web.xml looks like this...
>>>><?xml version="1.0" encoding="ISO-8859-1"?>
>>>><!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
>>>><web-app>
>>>><display-name>ISOTracking</display-name>
>>>><description>
>>>> Welcome TO ISO Tracking Application
>>>></description>
>>>><!-- JSPC servlet mappings start -->
>>>> <servlet>
>>>> <servlet-name>ISOTracking.Login_jsp</servlet-name>
>>>> <servlet-class>ISOTracking.Login_jsp</servlet-class>
>>>> </servlet>
>>>> <servlet-mapping>
>>>> <servlet-name>ISOTracking.Login_jsp</servlet-name>
>>>> <url-pattern>/Login.jsp</url-pattern>
>>>> </servlet-mapping>
>>>> <session-config>
>>>> <session-timeout>30</session-timeout>
>>>> </session-config>
>>>><!-- JSPC servlet mappings end -->
>>>> <resource-ref>
>>>> <res-ref-name>jdbc/sqlserver</res-ref-name>
>>>> <res-type>javax.sql.DataSource</res-type>
>>>> <res-auth>Container</res-auth>
>>>> </resource-ref>
>>>></web-app>
>>>>
>>>>
>>>>
>>>>
>>>>---------------------------------------------------------------------
>>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>---------------------------------------------------------------------
>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>---------------------------------------------------------------------
>>To start a new topic, e-mail: users@tomcat.apache.org
>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>To start a new topic, e-mail: users@tomcat.apache.org
>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>---------------------------------------------------------------------
>>To start a new topic, e-mail: users@tomcat.apache.org
>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>To start a new topic, e-mail: users@tomcat.apache.org
>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>>
>>
>>
>
>
>
>---------------------------------------------------------------------
>To start a new topic, e-mail: users@tomcat.apache.org
>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
>
>---------------------------------------------------------------------
>To start a new topic, e-mail: users@tomcat.apache.org
>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
Posted by Raju Balugu <ra...@gmail.com>.
Hi ,
1.Have you fallowed the same steps whic is mentioned in this
link.Pleasecheck once again .
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
and check one more link they also having the same problem
http://forum.sun.com/jive/thread.jspa?threadID=101183&tstart=0
2.Check your system weather its blocking the ports by navigating to virus
scanner console if its there.
Regards
Raju
On 8/1/06, David Smith <dn...@cornell.edu> wrote:
>
> And you are sure your test with the client software was via TCP, not
> some other piped/ODBC connection scheme? I'm guessing this is a Windows
> system. Have you checked your firewall for allowing the connections?
> Also try using TCPMon from sysinternals.org to see what's happening with
> connections to the database. It's good at showing net connection on a
> Windows box in real time.
>
> --David
>
> Aynalem, Seblewengel (Trawick) wrote:
>
> >Thanks David. I am able to connect to SQL Server 2000. Actually Tomcat
> 5.5.17 and SQL Server 2000 is on the same machine that I am working on.
> Could there be any other cause for this error:
> >
> >org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (The TCP/IP connection to the host has failed.
> java.net.ConnectException: Connection refused: connect)
> >
> >-----Original Message-----
> >From: David Smith [mailto:dns4@cornell.edu]
> >Sent: Monday, July 31, 2006 4:21 PM
> >To: Tomcat Users List
> >Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
> >create JDBC driver of class '' for connect URL 'null'
> >
> >
> >Well.... this is supposed to be an "SQL Server 2000" database server.
> >Use it's client tool to connect to the database. If successful, your
> >server is running. I'm not familiar with the product, but if you can
> >find it in the preferences, make sure you connect via TCP just like
> >tomcat would.
> >
> >--David
> >
> >Aynalem, Seblewengel (Trawick) wrote:
> >
> >
> >
> >>Sorry to ask this... how do you verify server connection
> independently. This is my first time configuring doing database connection.
> Thanks a lot,
> >>
> >>-----Original Message-----
> >>From: David Smith [mailto:dns4@cornell.edu]
> >>Sent: Monday, July 31, 2006 3:49 PM
> >>To: Tomcat Users List
> >>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
> >>create JDBC driver of class '' for connect URL 'null'
> >>
> >>
> >>Hmmm.... connection refused. Is your server listening for connections
> >>at jdbc:sqlserver://localhost:1433 ? Can you verify it independently?
> >>
> >>--David
> >>
> >>
> >>
> >>Aynalem, Seblewengel (Trawick) wrote:
> >>
> >>
> >>
> >>
> >>
> >>>Thanks a lot... I do need to have a space in context.xml file. That
> solved the problem with xml syntax. I now seem to have problem with
> database connection. Here is the code I use to connect...
> >>>
> >>>InitialContext ic=null;
> >>>
> >>>DataSource ds=null;
> >>>
> >>>Connection conn = null;
> >>>
> >>>try {
> >>> // testing
> >>> ic = new InitialContext();
> >>> ds = (DataSource)ic.lookup("java:comp/env/jdbc/sqlserver");
> >>> conn = ds.getConnection();
> >>> } catch (Exception e) {
> >>> StringWriter sw = new StringWriter();
> >>> e.printStackTrace(new PrintWriter(sw, true));
> >>> lastError = sw.toString();
> >>> System.out.println(lastError);
> >>> return false;
> >>> }
> >>>
> >>>And the error I get is this...
> >>>
> >>>lasterror org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (The TCP/IP connection to the host has failed.
> java.net.ConnectException: Connection refused:
> connect) at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(
> BasicDataSource.java:855)
> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(
> BasicDataSource.java:540) at
> ISOTracking.SessionBean.login(SessionBean.java:217) at
> org.apache.jsp.ISOTracking.LoginAction_jsp._jspService(LoginAction_jsp.java:57) at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at org.apache.jasper.servlet.JspServletWrapper.service(
> JspServletWrapper.java:332) at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:252) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:173) at
> org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:213) at
> org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:178) at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at
> org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:107) at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> (Http11BaseProtocol.java:664) at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:527)
> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:80) at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:684)
> at java.lang.Thread.run(Thread.java:595) Caused
> by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection
> to the host has failed. java.net.ConnectException: Connection refused:
> connect
> at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
> Source) at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown
> Source)
> at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
> Source) at
> org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(
> DriverConnectionFactory.java:37) at
> org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(
> PoolableConnectionFactory.java:290)
> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(
> BasicDataSource.java:877) at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(
> BasicDataSource.java:851)
> ... 23
> more
> error Cannot create PoolableConnectionFactory (The TCP/IP connection to the
> host has failed. java.net.ConnectException: Connection refused: connect)
> >>>
> >>>-----Original Message-----
> >>>From: Saha Rabindra N [mailto:Rabindra.Saha@acs-hro.com]
> >>>Sent: Monday, July 31, 2006 3:21 PM
> >>>To: Tomcat Users List
> >>>Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
> >>>create JDBC driver of class '' for connect URL 'null'
> >>>
> >>>
> >>>You could open your context.xml file using IE browser and that will
> tell you the syntax problem, if any.
> >>>
> >>>
> >>>
> >>>-----Original Message-----
> >>>From: Aynalem, Seblewengel (Trawick)
> >>>[mailto:Seblewengel.Aynalem@USPTO.GOV]
> >>>Sent: Monday, July 31, 2006 3:18 PM
> >>>To: Tomcat Users List
> >>>Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
> >>>create JDBC driver of class '' for connect URL 'null'
> >>>
> >>>
> >>>Hi Filip:
> >>>
> >>>I checked it... what is it missing? Many thanks your help.
> >>>
> >>>-----Original Message-----
> >>>From: Filip Hanik - Dev Lists [mailto:devlists@hanik.com]
> >>>Sent: Monday, July 31, 2006 3:12 PM
> >>>To: Tomcat Users List
> >>>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
> >>>create JDBC driver of class '' for connect URL 'null'
> >>>
> >>>
> >>>looks like your context XML file is not a valid XML format
> >>>
> >>>Filip
> >>>
> >>>
> >>>Aynalem, Seblewengel (Trawick) wrote:
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>>Yes I do have SQL JDBC driver in common/lib as sqljdbc.jar and did
> drop <ResourceLink.../> from context.xml file. Another error comes ups as
> follows:
> >>>>
> >>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.AprLifecycleListenerlifecycleEvent
> >>>>INFO: The Apache Tomcat Native library which allows optimal
> performance in production environments was not found on the
> java.library.path:
> C:\Java\jdk1.5.0_07\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program
> Files\Common Files\Roxio
> Shared\DLLShared;C:\Java\jdk1.5.0_07\bin;%CATALINA_BASE%\bin;C:\Program
> Files\Microsoft SQL Server\80\Tools\BINN
> >>>>Jul 31, 2006 3:01:05 PM org.apache.coyote.http11.Http11BaseProtocolinit
> >>>>INFO: Initializing Coyote HTTP/1.1 on http-8080
> >>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.startup.Catalina load
> >>>>INFO: Initialization processed in 1732 ms
> >>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardService start
> >>>>INFO: Starting service Catalina
> >>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardEngine start
> >>>>INFO: Starting Servlet Engine: Apache Tomcat/5.5.17
> >>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardHost start
> >>>>INFO: XML validation disabled
> >>>>Jul 31, 2006 3:01:08 PM org.apache.tomcat.util.digester.DigesterfatalError
> >>>>SEVERE: Parse Fatal Error at line 11 column 79: Element type
> "Resource" must be followed by either attribute specifications, ">" or "/>".
> >>>>org.xml.sax.SAXParseException: Element type "Resource" must be
> followed by either attribute specifications, ">" or "/>".
> >>>> at
> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException
> (ErrorHandlerWrapper.java:236)
> >>>> at
> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(
> ErrorHandlerWrapper.java:215)
> >>>> at
> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(
> XMLErrorReporter.java:386)
> >>>> at
> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(
> XMLErrorReporter.java:316)
> >>>> at
> com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(
> XMLScanner.java:1438)
> >>>> at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement
> (XMLDocumentFragmentScannerImpl.java:845)
> >>>> at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch
> (XMLDocumentFragmentScannerImpl.java:1693)
> >>>> at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument
> (XMLDocumentFragmentScannerImpl.java:368)
> >>>> at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(
> XML11Configuration.java:834)
> >>>> at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(
> XML11Configuration.java:764)
> >>>> at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(
> XMLParser.java:148)
> >>>> at
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(
> AbstractSAXParser.java:1242)
> >>>> at org.apache.tomcat.util.digester.Digester.parse(Digester.java
> :1561)
> >>>> at org.apache.catalina.startup.ContextConfig.processContextConfig(
> ContextConfig.java:781)
> >>>> at org.apache.catalina.startup.ContextConfig.contextConfig(
> ContextConfig.java:721)
> >>>> at org.apache.catalina.startup.ContextConfig.init(
> ContextConfig.java:977)
> >>>> at org.apache.catalina.startup.ContextConfig.lifecycleEvent(
> ContextConfig.java:278)
> >>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> LifecycleSupport.java:119)
> >>>> at org.apache.catalina.core.StandardContext.init(
> StandardContext.java:5130)
> >>>> at org.apache.catalina.core.StandardContext.start(
> StandardContext.java:3945)
> >>>> at org.apache.catalina.core.ContainerBase.addChildInternal(
> ContainerBase.java:759)
> >>>> at org.apache.catalina.core.ContainerBase.addChild(
> ContainerBase.java:739)
> >>>> at org.apache.catalina.core.StandardHost.addChild(
> StandardHost.java:524)
> >>>> at org.apache.catalina.startup.HostConfig.deployDirectory(
> HostConfig.java:904)
> >>>> at org.apache.catalina.startup.HostConfig.deployDirectories(
> HostConfig.java:867)
> >>>> at org.apache.catalina.startup.HostConfig.deployApps(
> HostConfig.java:474)
> >>>> at org.apache.catalina.startup.HostConfig.start(HostConfig.java
> :1122)
> >>>> at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> HostConfig.java:310)
> >>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> LifecycleSupport.java:119)
> >>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1021)
> >>>> at org.apache.catalina.core.StandardHost.start(StandardHost.java
> :718)
> >>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1013)
> >>>> at org.apache.catalina.core.StandardEngine.start(
> StandardEngine.java:442)
> >>>> at org.apache.catalina.core.StandardService.start(
> StandardService.java:450)
> >>>> at org.apache.catalina.core.StandardServer.start(
> StandardServer.java:709)
> >>>> at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
> >>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >>>> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:39)
> >>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
> >>>> at java.lang.reflect.Method.invoke(Method.java:585)
> >>>> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
> >>>> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
> >>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfigprocessContextConfig
> >>>>SEVERE: Parse error in default web.xml
> >>>>org.xml.sax.SAXParseException: Element type "Resource" must be
> followed by either attribute specifications, ">" or "/>".
> >>>> at
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(
> AbstractSAXParser.java:1269)
> >>>> at org.apache.tomcat.util.digester.Digester.parse(Digester.java
> :1561)
> >>>> at org.apache.catalina.startup.ContextConfig.processContextConfig(
> ContextConfig.java:781)
> >>>> at org.apache.catalina.startup.ContextConfig.contextConfig(
> ContextConfig.java:721)
> >>>> at org.apache.catalina.startup.ContextConfig.init(
> ContextConfig.java:977)
> >>>> at org.apache.catalina.startup.ContextConfig.lifecycleEvent(
> ContextConfig.java:278)
> >>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> LifecycleSupport.java:119)
> >>>> at org.apache.catalina.core.StandardContext.init(
> StandardContext.java:5130)
> >>>> at org.apache.catalina.core.StandardContext.start(
> StandardContext.java:3945)
> >>>> at org.apache.catalina.core.ContainerBase.addChildInternal(
> ContainerBase.java:759)
> >>>> at org.apache.catalina.core.ContainerBase.addChild(
> ContainerBase.java:739)
> >>>> at org.apache.catalina.core.StandardHost.addChild(
> StandardHost.java:524)
> >>>> at org.apache.catalina.startup.HostConfig.deployDirectory(
> HostConfig.java:904)
> >>>> at org.apache.catalina.startup.HostConfig.deployDirectories(
> HostConfig.java:867)
> >>>> at org.apache.catalina.startup.HostConfig.deployApps(
> HostConfig.java:474)
> >>>> at org.apache.catalina.startup.HostConfig.start(HostConfig.java
> :1122)
> >>>> at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> HostConfig.java:310)
> >>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> LifecycleSupport.java:119)
> >>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1021)
> >>>> at org.apache.catalina.core.StandardHost.start(StandardHost.java
> :718)
> >>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1013)
> >>>> at org.apache.catalina.core.StandardEngine.start(
> StandardEngine.java:442)
> >>>> at org.apache.catalina.core.StandardService.start(
> StandardService.java:450)
> >>>> at org.apache.catalina.core.StandardServer.start(
> StandardServer.java:709)
> >>>> at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
> >>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >>>> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:39)
> >>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
> >>>> at java.lang.reflect.Method.invoke(Method.java:585)
> >>>> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
> >>>> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
> >>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfigprocessContextConfig
> >>>>SEVERE: Occurred at line 11 column 79
> >>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfigstart
> >>>>SEVERE: Marking this application unavailable due to previous error(s)
> >>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.core.StandardContext start
> >>>>SEVERE: Error getConfigured
> >>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.core.StandardContext start
> >>>>SEVERE: Context [/ISOTrackingTest] startup failed due to previous
> errors
> >>>>Jul 31, 2006 3:01:09 PM org.apache.coyote.http11.Http11BaseProtocolstart
> >>>>INFO: Starting Coyote HTTP/1.1 on http-8080
> >>>>Jul 31, 2006 3:01:10 PM org.apache.jk.common.ChannelSocket init
> >>>>INFO: JK: ajp13 listening on /0.0.0.0:8009
> >>>>Jul 31, 2006 3:01:10 PM org.apache.jk.server.JkMain start
> >>>>INFO: Jk running ID=0 time=0/70 config=null
> >>>>Jul 31, 2006 3:01:10 PM org.apache.catalina.storeconfig.StoreLoaderload
> >>>>INFO: Find registry server-registry.xml at classpath resource
> >>>>Jul 31, 2006 3:01:10 PM org.apache.catalina.startup.Catalina start
> >>>>INFO: Server startup in 5147 ms
> >>>>
> >>>>-----Original Message-----
> >>>>From: David Smith [mailto:dns4@cornell.edu]
> >>>>Sent: Monday, July 31, 2006 2:53 PM
> >>>>To: Tomcat Users List
> >>>>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
> >>>>create JDBC driver of class '' for connect URL 'null'
> >>>>
> >>>>
> >>>>Is your SQL JDBC driver in common/lib? It has to be there for tomcat
> to
> >>>>set it up as a resource.
> >>>>
> >>>>Also drop the <ResourceLink.../> tag from your context
> definition. Not
> >>>>needed when the resource is defined inside the <Context...> tag and
> may
> >>>>confuse tomcat.
> >>>>
> >>>>--David
> >>>>
> >>>>Aynalem, Seblewengel (Trawick) wrote:
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>Hi there:
> >>>>>I am using tomcat 5.5.17 and SQL Server 2000 database with SQL Server
> 2005 JDBC Driver. OS is Windows XP professional. I have configured
> web.xml in WEB-INF directory and context.xml in META-INF directory of my
> application. Both are attached below with this email. I have a login.jsppage that asks for username and password... and when submit is hit, it gives
> the following error.
> >>>>>org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
> driver of class '' for connect URL 'null'
> >>>>>I tried to google and tried the suggestion given but any of them
> doesn't seem to work. Is there anything wrong with my configuration? PLEASE
> HELP...it is higly appreciated. If something is not clear, please get back
> to me. Thank you so much.
> >>>>>context.xml file looks like this...
> >>>>><?xml version="1.0" encoding="UTF-8"?>
> >>>>><Context debug="0" displayName="ISOTracking"
> docBase="C:\Java\TomcatTestServer\apache-
> tomcat-5.5.17\webapps\ISOTrackingTest" path="/ISOTracking"
> reloadable="true">
> >>>>> <Logger className="org.apache.catalina.logger.FileLogger"
> >>>>> prefix="ISOTRackingTest_Log." suffix=".txt" timestamp="true"/>
> >>>>> <!-- Define a database connection pool for SQL SERVER 2000 -->
> >>>>> <Resource name="jdbc/sqlserver" auth="Container" factory="
> org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" type="
> javax.sql.DataSource" driverClassName="
> com.microsoft.sqlserver.jdbc.SQLServerDriver"
> >>>>> url="jdbc:sqlserver://localhost:1433" username="xxx"
> password="xxx"maxActive="100" maxIdle="30" maxWait="10000"
> removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>
> >>>>> <ResourceLink name="jdbc/sqlserver" type="javax.sql.DataSource"
> global="jdbc/sqlserver"/>
> >>>>></Context>
> >>>>>web.xml looks like this...
> >>>>><?xml version="1.0" encoding="ISO-8859-1"?>
> >>>>><!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web
> Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
> >>>>><web-app>
> >>>>><display-name>ISOTracking</display-name>
> >>>>><description>
> >>>>> Welcome TO ISO Tracking Application
> >>>>></description>
> >>>>><!-- JSPC servlet mappings start -->
> >>>>> <servlet>
> >>>>> <servlet-name>ISOTracking.Login_jsp</servlet-name>
> >>>>> <servlet-class>ISOTracking.Login_jsp</servlet-class>
> >>>>> </servlet>
> >>>>> <servlet-mapping>
> >>>>> <servlet-name>ISOTracking.Login_jsp</servlet-name>
> >>>>> <url-pattern>/Login.jsp</url-pattern>
> >>>>> </servlet-mapping>
> >>>>> <session-config>
> >>>>> <session-timeout>30</session-timeout>
> >>>>> </session-config>
> >>>>><!-- JSPC servlet mappings end -->
> >>>>> <resource-ref>
> >>>>> <res-ref-name>jdbc/sqlserver</res-ref-name>
> >>>>> <res-type>javax.sql.DataSource</res-type>
> >>>>> <res-auth>Container</res-auth>
> >>>>> </resource-ref>
> >>>>></web-app>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>---------------------------------------------------------------------
> >>>>>To start a new topic, e-mail: users@tomcat.apache.org
> >>>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>>>>For additional commands, e-mail: users-help@tomcat.apache.org
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>---------------------------------------------------------------------
> >>>>To start a new topic, e-mail: users@tomcat.apache.org
> >>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>>>For additional commands, e-mail: users-help@tomcat.apache.org
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>---------------------------------------------------------------------
> >>>>To start a new topic, e-mail: users@tomcat.apache.org
> >>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>>>For additional commands, e-mail: users-help@tomcat.apache.org
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>---------------------------------------------------------------------
> >>>To start a new topic, e-mail: users@tomcat.apache.org
> >>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>>For additional commands, e-mail: users-help@tomcat.apache.org
> >>>
> >>>
> >>>
> >>>
> >>>---------------------------------------------------------------------
> >>>To start a new topic, e-mail: users@tomcat.apache.org
> >>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>>For additional commands, e-mail: users-help@tomcat.apache.org
> >>>
> >>>---------------------------------------------------------------------
> >>>To start a new topic, e-mail: users@tomcat.apache.org
> >>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>>For additional commands, e-mail: users-help@tomcat.apache.org
> >>>
> >>>
> >>>
> >>>
> >>>---------------------------------------------------------------------
> >>>To start a new topic, e-mail: users@tomcat.apache.org
> >>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>>For additional commands, e-mail: users-help@tomcat.apache.org
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>---------------------------------------------------------------------
> >>To start a new topic, e-mail: users@tomcat.apache.org
> >>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>For additional commands, e-mail: users-help@tomcat.apache.org
> >>
> >>
> >>
> >>
> >>---------------------------------------------------------------------
> >>To start a new topic, e-mail: users@tomcat.apache.org
> >>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>For additional commands, e-mail: users-help@tomcat.apache.org
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >---------------------------------------------------------------------
> >To start a new topic, e-mail: users@tomcat.apache.org
> >To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >For additional commands, e-mail: users-help@tomcat.apache.org
> >
> >
> >
> >
> >---------------------------------------------------------------------
> >To start a new topic, e-mail: users@tomcat.apache.org
> >To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >For additional commands, e-mail: users-help@tomcat.apache.org
> >
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
JDBC driver of class '' for connect URL 'null'
Posted by David Smith <dn...@cornell.edu>.
And you are sure your test with the client software was via TCP, not
some other piped/ODBC connection scheme? I'm guessing this is a Windows
system. Have you checked your firewall for allowing the connections?
Also try using TCPMon from sysinternals.org to see what's happening with
connections to the database. It's good at showing net connection on a
Windows box in real time.
--David
Aynalem, Seblewengel (Trawick) wrote:
>Thanks David. I am able to connect to SQL Server 2000. Actually Tomcat 5.5.17 and SQL Server 2000 is on the same machine that I am working on. Could there be any other cause for this error:
>
>org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect)
>
>-----Original Message-----
>From: David Smith [mailto:dns4@cornell.edu]
>Sent: Monday, July 31, 2006 4:21 PM
>To: Tomcat Users List
>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>create JDBC driver of class '' for connect URL 'null'
>
>
>Well.... this is supposed to be an "SQL Server 2000" database server.
>Use it's client tool to connect to the database. If successful, your
>server is running. I'm not familiar with the product, but if you can
>find it in the preferences, make sure you connect via TCP just like
>tomcat would.
>
>--David
>
>Aynalem, Seblewengel (Trawick) wrote:
>
>
>
>>Sorry to ask this... how do you verify server connection independently. This is my first time configuring doing database connection. Thanks a lot,
>>
>>-----Original Message-----
>>From: David Smith [mailto:dns4@cornell.edu]
>>Sent: Monday, July 31, 2006 3:49 PM
>>To: Tomcat Users List
>>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>create JDBC driver of class '' for connect URL 'null'
>>
>>
>>Hmmm.... connection refused. Is your server listening for connections
>>at jdbc:sqlserver://localhost:1433 ? Can you verify it independently?
>>
>>--David
>>
>>
>>
>>Aynalem, Seblewengel (Trawick) wrote:
>>
>>
>>
>>
>>
>>>Thanks a lot... I do need to have a space in context.xml file. That solved the problem with xml syntax. I now seem to have problem with database connection. Here is the code I use to connect...
>>>
>>>InitialContext ic=null;
>>>
>>>DataSource ds=null;
>>>
>>>Connection conn = null;
>>>
>>>try {
>>> // testing
>>> ic = new InitialContext();
>>> ds = (DataSource)ic.lookup("java:comp/env/jdbc/sqlserver");
>>> conn = ds.getConnection();
>>> } catch (Exception e) {
>>> StringWriter sw = new StringWriter();
>>> e.printStackTrace(new PrintWriter(sw, true));
>>> lastError = sw.toString();
>>> System.out.println(lastError);
>>> return false;
>>> }
>>>
>>>And the error I get is this...
>>>
>>>lasterror org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at ISOTracking.SessionBean.login(SessionBean.java:217) at org.apache.jsp.ISOTracking.LoginAction_jsp._jspService(LoginAction_jsp.java:57) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) ... 23 more error Cannot create PoolableConnectionFactory (The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect)
>>>
>>>-----Original Message-----
>>>From: Saha Rabindra N [mailto:Rabindra.Saha@acs-hro.com]
>>>Sent: Monday, July 31, 2006 3:21 PM
>>>To: Tomcat Users List
>>>Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>>create JDBC driver of class '' for connect URL 'null'
>>>
>>>
>>>You could open your context.xml file using IE browser and that will tell you the syntax problem, if any.
>>>
>>>
>>>
>>>-----Original Message-----
>>>From: Aynalem, Seblewengel (Trawick)
>>>[mailto:Seblewengel.Aynalem@USPTO.GOV]
>>>Sent: Monday, July 31, 2006 3:18 PM
>>>To: Tomcat Users List
>>>Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>>create JDBC driver of class '' for connect URL 'null'
>>>
>>>
>>>Hi Filip:
>>>
>>>I checked it... what is it missing? Many thanks your help.
>>>
>>>-----Original Message-----
>>>From: Filip Hanik - Dev Lists [mailto:devlists@hanik.com]
>>>Sent: Monday, July 31, 2006 3:12 PM
>>>To: Tomcat Users List
>>>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>>create JDBC driver of class '' for connect URL 'null'
>>>
>>>
>>>looks like your context XML file is not a valid XML format
>>>
>>>Filip
>>>
>>>
>>>Aynalem, Seblewengel (Trawick) wrote:
>>>
>>>
>>>
>>>
>>>
>>>
>>>>Yes I do have SQL JDBC driver in common/lib as sqljdbc.jar and did drop <ResourceLink.../> from context.xml file. Another error comes ups as follows:
>>>>
>>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
>>>>INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Java\jdk1.5.0_07\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Roxio Shared\DLLShared;C:\Java\jdk1.5.0_07\bin;%CATALINA_BASE%\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
>>>>Jul 31, 2006 3:01:05 PM org.apache.coyote.http11.Http11BaseProtocol init
>>>>INFO: Initializing Coyote HTTP/1.1 on http-8080
>>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.startup.Catalina load
>>>>INFO: Initialization processed in 1732 ms
>>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardService start
>>>>INFO: Starting service Catalina
>>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardEngine start
>>>>INFO: Starting Servlet Engine: Apache Tomcat/5.5.17
>>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardHost start
>>>>INFO: XML validation disabled
>>>>Jul 31, 2006 3:01:08 PM org.apache.tomcat.util.digester.Digester fatalError
>>>>SEVERE: Parse Fatal Error at line 11 column 79: Element type "Resource" must be followed by either attribute specifications, ">" or "/>".
>>>>org.xml.sax.SAXParseException: Element type "Resource" must be followed by either attribute specifications, ">" or "/>".
>>>> at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
>>>> at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:215)
>>>> at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:386)
>>>> at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
>>>> at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1438)
>>>> at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:845)
>>>> at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1693)
>>>> at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
>>>> at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
>>>> at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
>>>> at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
>>>> at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
>>>> at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561)
>>>> at org.apache.catalina.startup.ContextConfig.processContextConfig(ContextConfig.java:781)
>>>> at org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.java:721)
>>>> at org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:977)
>>>> at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:278)
>>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>>> at org.apache.catalina.core.StandardContext.init(StandardContext.java:5130)
>>>> at org.apache.catalina.core.StandardContext.start(StandardContext.java:3945)
>>>> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
>>>> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
>>>> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
>>>> at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904)
>>>> at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867)
>>>> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)
>>>> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
>>>> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
>>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
>>>> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
>>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
>>>> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
>>>> at org.apache.catalina.core.StandardService.start(StandardService.java:450)
>>>> at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
>>>> at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>> at java.lang.reflect.Method.invoke(Method.java:585)
>>>> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
>>>> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
>>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfig processContextConfig
>>>>SEVERE: Parse error in default web.xml
>>>>org.xml.sax.SAXParseException: Element type "Resource" must be followed by either attribute specifications, ">" or "/>".
>>>> at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1269)
>>>> at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561)
>>>> at org.apache.catalina.startup.ContextConfig.processContextConfig(ContextConfig.java:781)
>>>> at org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.java:721)
>>>> at org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:977)
>>>> at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:278)
>>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>>> at org.apache.catalina.core.StandardContext.init(StandardContext.java:5130)
>>>> at org.apache.catalina.core.StandardContext.start(StandardContext.java:3945)
>>>> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
>>>> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
>>>> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
>>>> at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904)
>>>> at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867)
>>>> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)
>>>> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
>>>> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
>>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
>>>> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
>>>> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
>>>> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
>>>> at org.apache.catalina.core.StandardService.start(StandardService.java:450)
>>>> at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
>>>> at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>> at java.lang.reflect.Method.invoke(Method.java:585)
>>>> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
>>>> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
>>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfig processContextConfig
>>>>SEVERE: Occurred at line 11 column 79
>>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfig start
>>>>SEVERE: Marking this application unavailable due to previous error(s)
>>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.core.StandardContext start
>>>>SEVERE: Error getConfigured
>>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.core.StandardContext start
>>>>SEVERE: Context [/ISOTrackingTest] startup failed due to previous errors
>>>>Jul 31, 2006 3:01:09 PM org.apache.coyote.http11.Http11BaseProtocol start
>>>>INFO: Starting Coyote HTTP/1.1 on http-8080
>>>>Jul 31, 2006 3:01:10 PM org.apache.jk.common.ChannelSocket init
>>>>INFO: JK: ajp13 listening on /0.0.0.0:8009
>>>>Jul 31, 2006 3:01:10 PM org.apache.jk.server.JkMain start
>>>>INFO: Jk running ID=0 time=0/70 config=null
>>>>Jul 31, 2006 3:01:10 PM org.apache.catalina.storeconfig.StoreLoader load
>>>>INFO: Find registry server-registry.xml at classpath resource
>>>>Jul 31, 2006 3:01:10 PM org.apache.catalina.startup.Catalina start
>>>>INFO: Server startup in 5147 ms
>>>>
>>>>-----Original Message-----
>>>>From: David Smith [mailto:dns4@cornell.edu]
>>>>Sent: Monday, July 31, 2006 2:53 PM
>>>>To: Tomcat Users List
>>>>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>>>create JDBC driver of class '' for connect URL 'null'
>>>>
>>>>
>>>>Is your SQL JDBC driver in common/lib? It has to be there for tomcat to
>>>>set it up as a resource.
>>>>
>>>>Also drop the <ResourceLink.../> tag from your context definition. Not
>>>>needed when the resource is defined inside the <Context...> tag and may
>>>>confuse tomcat.
>>>>
>>>>--David
>>>>
>>>>Aynalem, Seblewengel (Trawick) wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Hi there:
>>>>>I am using tomcat 5.5.17 and SQL Server 2000 database with SQL Server 2005 JDBC Driver. OS is Windows XP professional. I have configured web.xml in WEB-INF directory and context.xml in META-INF directory of my application. Both are attached below with this email. I have a login.jsp page that asks for username and password... and when submit is hit, it gives the following error.
>>>>>org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
>>>>>I tried to google and tried the suggestion given but any of them doesn't seem to work. Is there anything wrong with my configuration? PLEASE HELP...it is higly appreciated. If something is not clear, please get back to me. Thank you so much.
>>>>>context.xml file looks like this...
>>>>><?xml version="1.0" encoding="UTF-8"?>
>>>>><Context debug="0" displayName="ISOTracking" docBase="C:\Java\TomcatTestServer\apache-tomcat-5.5.17\webapps\ISOTrackingTest" path="/ISOTracking" reloadable="true">
>>>>> <Logger className="org.apache.catalina.logger.FileLogger"
>>>>> prefix="ISOTRackingTest_Log." suffix=".txt" timestamp="true"/>
>>>>> <!-- Define a database connection pool for SQL SERVER 2000 -->
>>>>> <Resource name="jdbc/sqlserver" auth="Container" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>>>>> url="jdbc:sqlserver://localhost:1433" username="xxx" password="xxx"maxActive="100" maxIdle="30" maxWait="10000" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>
>>>>> <ResourceLink name="jdbc/sqlserver" type="javax.sql.DataSource" global="jdbc/sqlserver"/>
>>>>></Context>
>>>>>web.xml looks like this...
>>>>><?xml version="1.0" encoding="ISO-8859-1"?>
>>>>><!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
>>>>><web-app>
>>>>><display-name>ISOTracking</display-name>
>>>>><description>
>>>>> Welcome TO ISO Tracking Application
>>>>></description>
>>>>><!-- JSPC servlet mappings start -->
>>>>> <servlet>
>>>>> <servlet-name>ISOTracking.Login_jsp</servlet-name>
>>>>> <servlet-class>ISOTracking.Login_jsp</servlet-class>
>>>>> </servlet>
>>>>> <servlet-mapping>
>>>>> <servlet-name>ISOTracking.Login_jsp</servlet-name>
>>>>> <url-pattern>/Login.jsp</url-pattern>
>>>>> </servlet-mapping>
>>>>> <session-config>
>>>>> <session-timeout>30</session-timeout>
>>>>> </session-config>
>>>>><!-- JSPC servlet mappings end -->
>>>>> <resource-ref>
>>>>> <res-ref-name>jdbc/sqlserver</res-ref-name>
>>>>> <res-type>javax.sql.DataSource</res-type>
>>>>> <res-auth>Container</res-auth>
>>>>> </resource-ref>
>>>>></web-app>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>---------------------------------------------------------------------
>>>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>---------------------------------------------------------------------
>>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>>
>>>>
>>>>
>>>>
>>>>---------------------------------------------------------------------
>>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>---------------------------------------------------------------------
>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>---------------------------------------------------------------------
>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>---------------------------------------------------------------------
>>To start a new topic, e-mail: users@tomcat.apache.org
>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>To start a new topic, e-mail: users@tomcat.apache.org
>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>>
>>
>>
>
>
>
>---------------------------------------------------------------------
>To start a new topic, e-mail: users@tomcat.apache.org
>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
>
>---------------------------------------------------------------------
>To start a new topic, e-mail: users@tomcat.apache.org
>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'
Posted by jo...@dancik.com.
Just a thought.... Is the SQL server installed as a non-default named
instance? If so, the port probably not 1433. You can check it by using
the Server Network Utility (select TCP/IP and click on properties).
Good luck,
Johnny
"Aynalem, Seblewengel (Trawick)" <Se...@USPTO.GOV>
08/01/2006 08:13 AM
Please respond to
"Tomcat Users List" <us...@tomcat.apache.org>
To
"Tomcat Users List" <us...@tomcat.apache.org>
cc
Subject
[***Probable Spam***] RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot create JDBC driver of class '' for connect URL 'null'
Thanks David. I am able to connect to SQL Server 2000. Actually Tomcat
5.5.17 and SQL Server 2000 is on the same machine that I am working on.
Could there be any other cause for this error:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (The TCP/IP connection to the host has failed.
java.net.ConnectException: Connection refused: connect)
-----Original Message-----
From: David Smith [mailto:dns4@cornell.edu]
Sent: Monday, July 31, 2006 4:21 PM
To: Tomcat Users List
Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create JDBC driver of class '' for connect URL 'null'
Well.... this is supposed to be an "SQL Server 2000" database server.
Use it's client tool to connect to the database. If successful, your
server is running. I'm not familiar with the product, but if you can
find it in the preferences, make sure you connect via TCP just like
tomcat would.
--David
Aynalem, Seblewengel (Trawick) wrote:
>Sorry to ask this... how do you verify server connection independently.
This is my first time configuring doing database connection. Thanks a lot,
>
>-----Original Message-----
>From: David Smith [mailto:dns4@cornell.edu]
>Sent: Monday, July 31, 2006 3:49 PM
>To: Tomcat Users List
>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>create JDBC driver of class '' for connect URL 'null'
>
>
>Hmmm.... connection refused. Is your server listening for connections
>at jdbc:sqlserver://localhost:1433 ? Can you verify it independently?
>
>--David
>
>
>
>Aynalem, Seblewengel (Trawick) wrote:
>
>
>
>>Thanks a lot... I do need to have a space in context.xml file. That
solved the problem with xml syntax. I now seem to have problem with
database connection. Here is the code I use to connect...
>>
>>InitialContext ic=null;
>>
>>DataSource ds=null;
>>
>>Connection conn = null;
>>
>>try {
>> // testing
>> ic = new InitialContext();
>> ds = (DataSource)ic.lookup("java:comp/env/jdbc/sqlserver");
>> conn = ds.getConnection();
>> } catch (Exception e) {
>> StringWriter sw = new StringWriter();
>> e.printStackTrace(new PrintWriter(sw, true));
>> lastError = sw.toString();
>> System.out.println(lastError);
>> return false;
>> }
>>
>>And the error I get is this...
>>
>>lasterror org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (The TCP/IP connection to the host has failed.
java.net.ConnectException: Connection refused: connect) at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at ISOTracking.SessionBean.login(SessionBean.java:217) at
org.apache.jsp.ISOTracking.LoginAction_jsp._jspService(LoginAction_jsp.java:57)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595) Caused by:
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to
the host has failed. java.net.ConnectException: Connection refused:
connect at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source) at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
Source) at
org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
...
23 more error Cannot create PoolableConnectionFactory (The TCP/IP
connection to the host has failed. java.net.ConnectException: Connection
refused: connect)
>>
>>-----Original Message-----
>>From: Saha Rabindra N [mailto:Rabindra.Saha@acs-hro.com]
>>Sent: Monday, July 31, 2006 3:21 PM
>>To: Tomcat Users List
>>Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>create JDBC driver of class '' for connect URL 'null'
>>
>>
>>You could open your context.xml file using IE browser and that will tell
you the syntax problem, if any.
>>
>>
>>
>>-----Original Message-----
>>From: Aynalem, Seblewengel (Trawick)
>>[mailto:Seblewengel.Aynalem@USPTO.GOV]
>>Sent: Monday, July 31, 2006 3:18 PM
>>To: Tomcat Users List
>>Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>create JDBC driver of class '' for connect URL 'null'
>>
>>
>>Hi Filip:
>>
>>I checked it... what is it missing? Many thanks your help.
>>
>>-----Original Message-----
>>From: Filip Hanik - Dev Lists [mailto:devlists@hanik.com]
>>Sent: Monday, July 31, 2006 3:12 PM
>>To: Tomcat Users List
>>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>create JDBC driver of class '' for connect URL 'null'
>>
>>
>>looks like your context XML file is not a valid XML format
>>
>>Filip
>>
>>
>>Aynalem, Seblewengel (Trawick) wrote:
>>
>>
>>
>>
>>>Yes I do have SQL JDBC driver in common/lib as sqljdbc.jar and did drop
<ResourceLink.../> from context.xml file. Another error comes ups as
follows:
>>>
>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
>>>INFO: The Apache Tomcat Native library which allows optimal performance
in production environments was not found on the java.library.path:
C:\Java\jdk1.5.0_07\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program
Files\Common Files\Roxio
Shared\DLLShared;C:\Java\jdk1.5.0_07\bin;%CATALINA_BASE%\bin;C:\Program
Files\Microsoft SQL Server\80\Tools\BINN
>>>Jul 31, 2006 3:01:05 PM org.apache.coyote.http11.Http11BaseProtocol
init
>>>INFO: Initializing Coyote HTTP/1.1 on http-8080
>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.startup.Catalina load
>>>INFO: Initialization processed in 1732 ms
>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardService start
>>>INFO: Starting service Catalina
>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardEngine start
>>>INFO: Starting Servlet Engine: Apache Tomcat/5.5.17
>>>Jul 31, 2006 3:01:05 PM org.apache.catalina.core.StandardHost start
>>>INFO: XML validation disabled
>>>Jul 31, 2006 3:01:08 PM org.apache.tomcat.util.digester.Digester
fatalError
>>>SEVERE: Parse Fatal Error at line 11 column 79: Element type "Resource"
must be followed by either attribute specifications, ">" or "/>".
>>>org.xml.sax.SAXParseException: Element type "Resource" must be followed
by either attribute specifications, ">" or "/>".
>>> at
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
>>> at
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:215)
>>> at
com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:386)
>>> at
com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
>>> at
com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1438)
>>> at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:845)
>>> at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1693)
>>> at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
>>> at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
>>> at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
>>> at
com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
>>> at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
>>> at
org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561)
>>> at
org.apache.catalina.startup.ContextConfig.processContextConfig(ContextConfig.java:781)
>>> at
org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.java:721)
>>> at
org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:977)
>>> at
org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:278)
>>> at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>> at
org.apache.catalina.core.StandardContext.init(StandardContext.java:5130)
>>> at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3945)
>>> at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
>>> at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
>>> at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
>>> at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904)
>>> at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867)
>>> at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)
>>> at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
>>> at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
>>> at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>> at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
>>> at
org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
>>> at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
>>> at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
>>> at
org.apache.catalina.core.StandardService.start(StandardService.java:450)
>>> at
org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
>>> at
org.apache.catalina.startup.Catalina.start(Catalina.java:551)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
>>> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:585)
>>> at
org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
>>> at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfig
processContextConfig
>>>SEVERE: Parse error in default web.xml
>>>org.xml.sax.SAXParseException: Element type "Resource" must be followed
by either attribute specifications, ">" or "/>".
>>> at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1269)
>>> at
org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561)
>>> at
org.apache.catalina.startup.ContextConfig.processContextConfig(ContextConfig.java:781)
>>> at
org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.java:721)
>>> at
org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:977)
>>> at
org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:278)
>>> at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>> at
org.apache.catalina.core.StandardContext.init(StandardContext.java:5130)
>>> at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3945)
>>> at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
>>> at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
>>> at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
>>> at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904)
>>> at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867)
>>> at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)
>>> at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
>>> at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
>>> at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>>> at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
>>> at
org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
>>> at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
>>> at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
>>> at
org.apache.catalina.core.StandardService.start(StandardService.java:450)
>>> at
org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
>>> at
org.apache.catalina.startup.Catalina.start(Catalina.java:551)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
>>> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:585)
>>> at
org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
>>> at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfig
processContextConfig
>>>SEVERE: Occurred at line 11 column 79
>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.startup.ContextConfig start
>>>SEVERE: Marking this application unavailable due to previous error(s)
>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.core.StandardContext start
>>>SEVERE: Error getConfigured
>>>Jul 31, 2006 3:01:08 PM org.apache.catalina.core.StandardContext start
>>>SEVERE: Context [/ISOTrackingTest] startup failed due to previous
errors
>>>Jul 31, 2006 3:01:09 PM org.apache.coyote.http11.Http11BaseProtocol
start
>>>INFO: Starting Coyote HTTP/1.1 on http-8080
>>>Jul 31, 2006 3:01:10 PM org.apache.jk.common.ChannelSocket init
>>>INFO: JK: ajp13 listening on /0.0.0.0:8009
>>>Jul 31, 2006 3:01:10 PM org.apache.jk.server.JkMain start
>>>INFO: Jk running ID=0 time=0/70 config=null
>>>Jul 31, 2006 3:01:10 PM org.apache.catalina.storeconfig.StoreLoader
load
>>>INFO: Find registry server-registry.xml at classpath resource
>>>Jul 31, 2006 3:01:10 PM org.apache.catalina.startup.Catalina start
>>>INFO: Server startup in 5147 ms
>>>
>>>-----Original Message-----
>>>From: David Smith [mailto:dns4@cornell.edu]
>>>Sent: Monday, July 31, 2006 2:53 PM
>>>To: Tomcat Users List
>>>Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
>>>create JDBC driver of class '' for connect URL 'null'
>>>
>>>
>>>Is your SQL JDBC driver in common/lib? It has to be there for tomcat
to
>>>set it up as a resource.
>>>
>>>Also drop the <ResourceLink.../> tag from your context definition. Not
>>>needed when the resource is defined inside the <Context...> tag and may
>>>confuse tomcat.
>>>
>>>--David
>>>
>>>Aynalem, Seblewengel (Trawick) wrote:
>>>
>>>
>>>
>>>
>>>
>>>
>>>>Hi there:
>>>>I am using tomcat 5.5.17 and SQL Server 2000 database with SQL Server
2005 JDBC Driver. OS is Windows XP professional. I have configured
web.xml in WEB-INF directory and context.xml in META-INF directory of my
application. Both are attached below with this email. I have a login.jsp
page that asks for username and password... and when submit is hit, it
gives the following error.
>>>>org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'
>>>>I tried to google and tried the suggestion given but any of them
doesn't seem to work. Is there anything wrong with my configuration?
PLEASE HELP...it is higly appreciated. If something is not clear, please
get back to me. Thank you so much.
>>>>context.xml file looks like this...
>>>><?xml version="1.0" encoding="UTF-8"?>
>>>><Context debug="0" displayName="ISOTracking"
docBase="C:\Java\TomcatTestServer\apache-tomcat-5.5.17\webapps\ISOTrackingTest"
path="/ISOTracking" reloadable="true">
>>>> <Logger className="org.apache.catalina.logger.FileLogger"
>>>> prefix="ISOTRackingTest_Log." suffix=".txt"
timestamp="true"/>
>>>> <!-- Define a database connection pool for SQL SERVER
2000 -->
>>>> <Resource name="jdbc/sqlserver" auth="Container"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>>>> url="jdbc:sqlserver://localhost:1433" username="xxx"
password="xxx"maxActive="100" maxIdle="30" maxWait="10000"
removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>
>>>> <ResourceLink name="jdbc/sqlserver"
type="javax.sql.DataSource" global="jdbc/sqlserver"/>
>>>></Context>
>>>>web.xml looks like this...
>>>><?xml version="1.0" encoding="ISO-8859-1"?>
>>>><!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web
Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
>>>><web-app>
>>>><display-name>ISOTracking</display-name>
>>>><description>
>>>> Welcome TO ISO Tracking Application
>>>></description>
>>>><!-- JSPC servlet mappings start -->
>>>> <servlet>
>>>> <servlet-name>ISOTracking.Login_jsp</servlet-name>
>>>> <servlet-class>ISOTracking.Login_jsp</servlet-class>
>>>> </servlet>
>>>> <servlet-mapping>
>>>> <servlet-name>ISOTracking.Login_jsp</servlet-name>
>>>> <url-pattern>/Login.jsp</url-pattern>
>>>> </servlet-mapping>
>>>> <session-config>
>>>> <session-timeout>30</session-timeout>
>>>> </session-config>
>>>><!-- JSPC servlet mappings end -->
>>>> <resource-ref>
>>>> <res-ref-name>jdbc/sqlserver</res-ref-name>
>>>> <res-type>javax.sql.DataSource</res-type>
>>>> <res-auth>Container</res-auth>
>>>> </resource-ref>
>>>></web-app>
>>>>
>>>>
>>>>
>>>>
>>>>---------------------------------------------------------------------
>>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>---------------------------------------------------------------------
>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>To start a new topic, e-mail: users@tomcat.apache.org
>>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>---------------------------------------------------------------------
>>To start a new topic, e-mail: users@tomcat.apache.org
>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>To start a new topic, e-mail: users@tomcat.apache.org
>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>---------------------------------------------------------------------
>>To start a new topic, e-mail: users@tomcat.apache.org
>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>To start a new topic, e-mail: users@tomcat.apache.org
>>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>>
>>
>>
>
>
>
>---------------------------------------------------------------------
>To start a new topic, e-mail: users@tomcat.apache.org
>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
>
>---------------------------------------------------------------------
>To start a new topic, e-mail: users@tomcat.apache.org
>To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org