Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 61782 invoked from network); 1 Aug 2006 13:53:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Aug 2006 13:53:12 -0000 Received: (qmail 50860 invoked by uid 500); 1 Aug 2006 13:52:56 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 50746 invoked by uid 500); 1 Aug 2006 13:52:56 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 50734 invoked by uid 99); 1 Aug 2006 13:52:56 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Aug 2006 06:52:56 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [63.71.228.81] (HELO smtpedge2.uspto.gov) (63.71.228.81) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Aug 2006 06:52:55 -0700 Received: from emfserver2 (emfserver2.uspto.gov [10.240.6.91]) by smtpedge2.uspto.gov (Tumbleweed MailGate) with ESMTP id 579A9E015FAC for ; Tue, 1 Aug 2006 09:52:20 -0400 (EDT) Received: from 10.112.161.154 by emfserver2 with ESMTP (Authorized ESMTP users only. All activity may be monitored and reported. (Email Firewall v6.2.2)); Tue, 01 Aug 2006 09:53:35 -0400 X-Server-Uuid: 2780124C-904F-47F2-9CD2-686A933EECEC Received: from exchange3.uspto.gov ([10.112.171.193]) by uspto-smtp-1.uspto.gov with Microsoft SMTPSVC(6.0.3790.1830); Tue, 1 Aug 2006 09:52:17 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' Date: Tue, 1 Aug 2006 09:52:16 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' Thread-Index: Aca1ZbaIbbwOWJNmTdGResngWxkyuQACBLMQ From: "Aynalem, Seblewengel (Trawick)" To: "Tomcat Users List" X-OriginalArrivalTime: 01 Aug 2006 13:52:17.0139 (UTC) FILETIME=[B356F430:01C6B571] X-WSS-ID: 68D183551O44438172-03-01 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Thanks David, Raju and Johnny for your time and valuable suggestions. =20 To David's question: I checked Client Network Utility service for SQL = server 2000 and saw that TCP/IP is enabled on port 1433. I do check the = firewall, yes it was on. It has the option of adding exceptions to = allow programs/service to connect to the machine. So I added SQL server = 2000 on port 1433. I did netstat -an on command prompt to see active = connection... but port 1433 is not listed. I also used sysinternals.org = as suggested and SQL Server is not listed. This might mean SQL Server is = not using TCP/IP on port 1433??? To Raju's question... I have tried to read and re-read tomcat manual... = I will check if there is anything I missed. I am also trying to see how = I can apply the solution suggested on the link provided. =20 Jonny - SQL Server is installed as default instance... TCP/IP was = enabled on port 1433. Any further help is higly appreciated. =20 Thanks a lot.=20 -----Original Message----- From: David Smith [mailto:dns4@cornell.edu] Sent: Tuesday, August 01, 2006 8:26 AM To: Tomcat Users List Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' And you are sure your test with the client software was via TCP, not=20 some other piped/ODBC connection scheme? I'm guessing this is a Windows = system. Have you checked your firewall for allowing the connections? =20 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=20 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. =20 >Use it's client tool to connect to the database. If successful, your=20 >server is running. I'm not familiar with the product, but if you can=20 >find it in the preferences, make sure you connect via TCP just like=20 >tomcat would. > >--David > >Aynalem, Seblewengel (Trawick) wrote: > > =20 > >>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=20 >>at jdbc:sqlserver://localhost:1433 ? Can you verify it independently? >> >>--David >> >> >> >>Aynalem, Seblewengel (Trawick) wrote: >> >>=20 >> >> =20 >> >>>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=3Dnull; >>> >>>DataSource ds=3Dnull; >>> >>>Connection conn =3D null; >>> >>>try { >>> // testing >>> ic =3D new InitialContext(); >>> ds =3D (DataSource)ic.lookup("java:comp/env/jdbc/sqlserver"); >>> conn =3D ds.getConnection(); >>> } catch (Exception e) { >>> StringWriter sw =3D new StringWriter(); >>> e.printStackTrace(new PrintWriter(sw, true)); >>> lastError =3D 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(BasicDataSou= rce.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.ja= va: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.jav= a: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(Applicat= ionFilterChain.java:252) = at = org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte= rChain.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.j= ava:107) = at = org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14= 8) = at = org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869= ) = at = org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proce= ssConnection(Http11BaseProtocol.java:664) = at = org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.= java:527) = at = org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowe= rWorkerThread.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(Unkno= wn 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(Driv= erConnectionFactory.java:37) = at = org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(Poolable= ConnectionFactory.java:290) = at = org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(Bas= icDataSource.java:877) = at = org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSou= rce.java:851) = ... 23 more = = error Cannot create PoolableConnectionFactory (The = TCP/IP connection to the host has failed. java.net.ConnectException: = Connection refused: connect) =20 >>> >>>-----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: >>> >>> >>> =20 >>> >>> =20 >>> >>>>Yes I do have SQL JDBC driver in common/lib as sqljdbc.jar and did = drop 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\syste= m32;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.createSAXPars= eException(ErrorHandlerWrapper.java:236) >>>> at = com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Er= rorHandlerWrapper.java:215) >>>> at = com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLE= rrorReporter.java:386) >>>> at = com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLE= rrorReporter.java:316) >>>> at = com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLSc= anner.java:1438) >>>> at = com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.sc= anStartElement(XMLDocumentFragmentScannerImpl.java:845) >>>> at = com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$Fr= agmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1693= ) >>>> at = com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.sc= anDocument(XMLDocumentFragmentScannerImpl.java:368) >>>> at = com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11= Configuration.java:834) >>>> at = com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11= Configuration.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(Abstra= ctSAXParser.java:1242) >>>> at = org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561) >>>> at = org.apache.catalina.startup.ContextConfig.processContextConfig(ContextCon= fig.java:781) >>>> at = org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.jav= a:721) >>>> at = org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:977) >>>> at = org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.ja= va:278) >>>> at = org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSup= port.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.jav= a: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:90= 4) >>>> 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(LifecycleSup= port.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(DelegatingMethodAccessorI= mpl.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(Abstra= ctSAXParser.java:1269) >>>> at = org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561) >>>> at = org.apache.catalina.startup.ContextConfig.processContextConfig(ContextCon= fig.java:781) >>>> at = org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.jav= a:721) >>>> at = org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:977) >>>> at = org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.ja= va:278) >>>> at = org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSup= port.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.jav= a: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:90= 4) >>>> 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(LifecycleSup= port.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(DelegatingMethodAccessorI= mpl.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=3D0 time=3D0/70 config=3Dnull >>>>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=20 >>>>set it up as a resource. >>>> >>>>Also drop the tag from your context definition. = Not=20 >>>>needed when the resource is defined inside the tag and = may=20 >>>>confuse tomcat. >>>> >>>>--David >>>> >>>>Aynalem, Seblewengel (Trawick) wrote: >>>> >>>> >>>> =20 >>>> >>>> =20 >>>> >>>> =20 >>>> >>>>>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'=20 >>>>>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... >>>>> >>>>> >>>>> >>>> prefix=3D"ISOTRackingTest_Log." suffix=3D".txt" = timestamp=3D"true"/> >>>>> >>>>> >>>> url=3D"jdbc:sqlserver://localhost:1433" username=3D"xxx" = password=3D"xxx"maxActive=3D"100" maxIdle=3D"30" maxWait=3D"10000" = removeAbandoned=3D"true" removeAbandonedTimeout=3D"60" = logAbandoned=3D"true"/> >>>>> >>>>> >>>>>web.xml looks like this... >>>>> >>>>> >>>>> >>>>>ISOTracking >>>>> >>>>> Welcome TO ISO Tracking Application >>>>> >>>>> >>>>> >>>>> ISOTracking.Login_jsp >>>>> ISOTracking.Login_jsp >>>>> >>>>> >>>>> ISOTracking.Login_jsp >>>>> /Login.jsp >>>>> >>>>> >>>>> 30 >>>>> >>>>> >>>>> >>>>> jdbc/sqlserver >>>>> javax.sql.DataSource >>>>> Container >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>--------------------------------------------------------------------= - >>>>>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 >>>>> >>>>> >>>>> >>>>> =20 >>>>> =20 >>>>> >>>>> =20 >>>>> >>>>> =20 >>>>> >>>>---------------------------------------------------------------------= >>>>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 >>>> >>>> >>>> >>>> >>>> =20 >>>> >>>> =20 >>>> >>>> =20 >>>> >>>--------------------------------------------------------------------- >>>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 >>> >>> >>> >>> =20 >>> >>> =20 >>> >> >>--------------------------------------------------------------------- >>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 >> >>=20 >> >> =20 >> > > > >--------------------------------------------------------------------- >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 > > =20 > --------------------------------------------------------------------- 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