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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] >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:[EMAIL PROTECTED] >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:[EMAIL PROTECTED] >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:[EMAIL PROTECTED] >>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: [EMAIL PROTECTED] >>>For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >>> >>> >>> >>> >>--------------------------------------------------------------------- >>To start a new topic, e-mail: users@tomcat.apache.org >>To unsubscribe, e-mail: [EMAIL PROTECTED] >>For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> >>--------------------------------------------------------------------- >>To start a new topic, e-mail: users@tomcat.apache.org >>To unsubscribe, e-mail: [EMAIL PROTECTED] >>For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> >> >> > > >--------------------------------------------------------------------- >To start a new topic, e-mail: users@tomcat.apache.org >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > > >--------------------------------------------------------------------- >To start a new topic, e-mail: users@tomcat.apache.org >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > >--------------------------------------------------------------------- >To start a new topic, e-mail: users@tomcat.apache.org >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > > >--------------------------------------------------------------------- >To start a new topic, e-mail: users@tomcat.apache.org >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]