-----Original Message----- From: Ignacio J. Ortega [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 9:15 AM To: Tuan H. Le Subject: RE: Tomcat --> JDBC ---> SQL Server Connection refused This is a user question, use [EMAIL PROTECTED] instead.. Saludos , Ignacio J. Ortega > -----Mensaje original----- > De: Tuan H. Le [mailto:[EMAIL PROTECTED]] > Enviado el: 1 de octubre de 2002 2:15 > Para: [EMAIL PROTECTED] > Asunto: Tomcat --> JDBC ---> SQL Server Connection refused > > > Hi, > > I'm having a problem of connecting to SQL Server db. I'm > using Opta2000 v4.14 driver with SQL Server 2000 on XP with > Tomcat 4.1.10. > > Context initCtx = new InitialContext(); > Context envCtx = (Context)initCtx.lookup( "java:comp/env" ); > > DataSource ds = (DataSource)envCtx.lookup( "jdbc/ezhr" ); > Connection conn = ds.getConnection(); <--- connection refused > happens here !!!!!! > > > Here're my settings > > 1) SQL Server uses SQL Server authentication > 2) SQL Server network protocol settings: both Named Pipes and TCP/IP > 3) Tomcat settings > ---- server.xml ----- > <!-- Tomcat Context --> > <Context path="/ezhr" docBase="ezhr" debug="0" > reloadable="true" crossContext="true"> > <Logger className="org.apache.catalina.logger.FileLogger" > prefix="ezhrdb." suffix=".txt" > timestamp="true"/> > <!-- Datasource --> > <Resource name="jdbc/ezhr" auth="Container" > type="javax.sql.DataSource"/> > <ResourceParams name="jdbc/ezhr"> > <parameter> > <name>maxActive</name> > <value>10</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>10</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>10000</value> > </parameter> > <parameter> > <name>username</name> > <value>xxxx</value> > </parameter> > <parameter> > <name>password</name> > <value>yyyyy</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>com.inet.tds.TdsDriver</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:inetdae7://localhost:1433</value> > </parameter> > </ResourceParams> > </Context> > > --- web.xml ----- > > <resource-ref> > <res-ref-name>jdbc/ezhr</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > > ---- Exception ----- > javax.servlet.ServletException: com.inet.tds.SQLException: > Connection refused: connect > at > org.apache.struts.action.RequestProcessor.processException(Req > uestProcessor.java:507) > at > org.apache.struts.action.RequestProcessor.processActionPerform > (RequestProcessor.java:448) > at > org.apache.struts.action.RequestProcessor.process(RequestProce > ssor.java:266) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.j > ava:1292) > at > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > er(ApplicationFilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > cationFilterChain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > rapperValve.java:260) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invokeNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardC > ontextValve.java:191) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invokeNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContext.invoke(StandardContex > t.java:2397) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > Valve.java:180) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invokeNext(StandardPipeline.java:643) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > spatcherValve.java:170) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invokeNext(StandardPipeline.java:641) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > Valve.java:171) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invokeNext(StandardPipeline.java:641) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > gineValve.java:174) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > eContext.invokeNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter. > java:223) > at > org.apache.coyote.http11.Http11Processor.process(Http11Process > or.java:405) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle > r.processConnection(Http11Protocol.java:380) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoi > nt.java:508) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run( > ThreadPool.java:533) > at java.lang.Thread.run(Thread.java:479) > > > Do you know what I'm missing? > > TIA!!! > Tuan > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>