tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Smith <d...@cornell.edu>
Subject Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
Date Tue, 01 Aug 2006 14:01:17 GMT
I think you have your answer.  The SQL Server is not setup to listen on 
1433 or not running.  Address this and things should start working.

--David

Aynalem, Seblewengel (Trawick) wrote:

>Thanks David, Raju and Johnny for your time and valuable suggestions.  
>
>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.  
>
>Jonny - SQL Server is installed as default instance... TCP/IP was enabled on port 1433.
>
>Any further help is higly appreciated.  
>
>Thanks a lot. 
>
>-----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 
>some other piped/ODBC connection scheme?  I'm guessing this is a Windows 
>system.  Have you checked your firewall for allowing the connections?  
>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 
>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.  
>>Use it's client tool to connect to the database.  If successful, your 
>>server is running.  I'm not familiar with the product, but if you can 
>>find it in the preferences, make sure you connect via TCP just like 
>>tomcat would.
>>
>>--David
>>
>>Aynalem, Seblewengel (Trawick) wrote:
>>
>> 
>>
>>    
>>
>>>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 
>>>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: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:
>>>>
>>>>
>>>>  
>>>>
>>>>     
>>>>
>>>>        
>>>>
>>>>>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: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 
>>>>>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: 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
>>>>
>>>>
>>>>
>>>>
>>>>---------------------------------------------------------------------
>>>>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
>>>
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>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
>
>
>
>
>---------------------------------------------------------------------
>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


Mime
View raw message