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]
