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]