Hi David:
Thanks for your quick reply. I don't have <Resource .../> tag in web.xml.
Here is the updated context.xml, <ResourceLink .../> dropped from it and
web.xml as it were before.
context.xml file
<?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"/>
</Context>
web.xml file
<?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>
-----Original Message-----
From: David Smith [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 3:17 PM
To: Tomcat Users List
Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create JDBC driver of class '' for connect URL 'null'
The stack traces mention that the <Resource .../> tag is in web.xml (and
apparently not well formed xml to boot). Please remove it. It should
only be in context.xml with a <resource-ref> tag in web.xml. If there
are further stack traces, could you post your new context.xml and web.xml?
--David
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]
