cool. that works for me. so, let's say i want to watch my sql server connections monitor and run this pool monitor from a jsp at the same time. shouldn't i expect to see the # of active + # of idle on the jsp add up to the # of connections that sql server knows about? (assuming tomcat is the only user of connections to this db)
trying to check my assumptions here. barclay -----Original Message----- From: Angus Mezick [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 4:00 PM To: [EMAIL PROTECTED] Subject: RE: Help! heavy traffic is crapping out our site every 5 min! DBCP exceptions Oh, here is the code that will work with a JNDI resource: javax.naming.Context initContext; try { initContext = new InitialContext(); javax.naming.Context envContext = (javax.naming.Context)initContext.lookup("java:/comp/env"); BasicDataSource ds = (BasicDataSource)envContext.lookup("jdbc/SessionDB"); if(ds!=null){ pageContext.getOut().println(" jdbc/SessionDB: Active: " + ds.getNumActive() + " Idle: " + ds.getNumIdle() + "<br>"); } } catch (NamingException e) { // TODO Auto-generated catch block //e.printStackTrace(); } > -----Original Message----- > From: Angus Mezick > Sent: Friday, August 08, 2003 3:26 PM > To: 'Tomcat Users List' > Subject: RE: Help! heavy traffic is crapping out our site > every 5 min! DBCP exceptions > > > Here is a little snippet I use inside of a custom tag to > disply pool health: > private void printPoolStatus() throws IOException { > PoolingDriver driver = new PoolingDriver(); > pageContext.getOut().println("<br><b>Dbcp Pool > Data:</b> <br>"); > ObjectPool gop = driver.getPool("SessionManager"); > if (gop != null) { > pageContext.getOut().println(" SessionManager: > Active: " + gop.getNumActive() + " Idle: " + gop.getNumIdle() > + "<br>"); > } > gop = driver.getPool("CommerceServer"); > if (gop != null) { > pageContext.getOut().println(" CommerceServer: > Active: " + gop.getNumActive() + " Idle: " + gop.getNumIdle() > + "<br>"); > } > } > > You WILL need to change the getPool names. > --Angus > > > -----Original Message----- > > From: Barclay A. Dunn [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 08, 2003 2:47 PM > > To: Tomcat Users List > > Subject: RE: Help! heavy traffic is crapping out our site > > every 5 min! DBCP exceptions > > > > > > ah! there's the rub. i am also searching the archives of the > > jakarta-commons-users list for insight and must also post to > > that list if i > > can't figure it out myself, but we think no, they are not > > getting closed > > correctly. i can claim 100% of the time i am calling > > conn_.close(), but when > > we watch our db connections they go up but they never come > > down. so we think > > no. > > > > as i mentioned before, i do not fully grok the workings of > > dbcp and am thus > > in over my head. i could use a little step-by-step on how > to test this > > (other than the logical deduction my sysadmin and i are using > > right now). > > > > thanks a million everybody for trying to be so helpful. > > > > barclay > > > > -----Original Message----- > > From: Angus Mezick [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 08, 2003 2:23 PM > > To: Tomcat Users List > > Subject: RE: Help! heavy traffic is crapping out our site > every 5 min! > > DBCP exceptions > > > > > > All of these connections are being correctly closed, right? > > --Angus > > > > > -----Original Message----- > > > From: rob engstrom [mailto:[EMAIL PROTECTED] > > > Sent: Friday, August 08, 2003 2:08 PM > > > To: 'Tomcat Users List' > > > Subject: RE: Help! heavy traffic is crapping out our site > > > every 5 min! DBCP exceptions > > > > > > > > > Ok, I'm the sysamdin of which is being spoken. So I checked > > > netstat, as I > > > normally do. Here's a bit of info: > > > > > > netstat -an | grep 172.16 | grep ESTABLISHED | wc -l > > > (172.16 refers to the DB connection on the internal network, > > > on a separate > > > VLAN than the rest of the network traffic) > > > > > > This elicits a response of : 45 , which if I watch the sysmon > > > on the SQL > > > server, it shows 45 connections currently. Same command with > > > TIME_WAIT > > > instead, shows: 15 > > > > > > So at least right now, it doesn't seem to be so much a > > > connection problem to > > > the DB. We did his some "too many open files" errors in the > > > Catalina.out, > > > which I temporarily resolved by changing ulimit -n from > > 1024 to 8092. > > > > > > > > > --- > > > robert engstrom > > > > > > > > > -----Original Message----- > > > From: Lawrence, Gabriel [mailto:[EMAIL PROTECTED] > > > Sent: Friday, August 08, 2003 1:47 PM > > > To: Tomcat Users List > > > Subject: RE: Help! heavy traffic is crapping out our site > > > every 5 min! DBCP > > > exceptions > > > > > > Try running netstat on the linux box to see how many > > > connections are out > > > there. This might give you some more visibility into what network > > > connections are actually being used and where they are going. > > > > > > -gabe > > > > > > -----Original Message----- > > > From: Barclay A. Dunn [mailto:[EMAIL PROTECTED] > > > Sent: Friday, August 08, 2003 10:43 AM > > > To: Tomcat Users List > > > Subject: RE: Help! heavy traffic is crapping out our site > > every 5 min! > > > DBCP exceptions > > > > > > your logic seems on target to me. > > > > > > my sysadmin (who's just as stymied as i am) says that > > according to his > > > sources, sockets on linux are open files so if the open > > file limit is > > > exceeded, it would affect sockets as well. any thoughts on this? > > > > > > barclay > > > > > > -----Original Message----- > > > From: Eric J. Pinnell [mailto:[EMAIL PROTECTED] > > > Sent: Friday, August 08, 2003 1:38 PM > > > To: Tomcat Users List > > > Subject: RE: Help! heavy traffic is crapping out our site > > every 5 min! > > > DBCP exceptions > > > > > > > > > I'm pretty sure "can't create socket" means it can't > > connect to the DB > > > for > > > some reason. I would wager the DB (or something) is refusing the > > > connection. The fact that it said "can't create socket" > means that > > > tomcat > > > is trying to do so. So that part of it seems alright. > > > > > > -e > > > > > > On Fri, 8 Aug 2003, Barclay A. Dunn wrote: > > > > > > > well, i followed the dbcp comment that says "set to 0 for > > unlimited" > > > and > > > > that turns out to be wrong. > > > > > > > > i also tried -1 and that is equally unuseful in terms of > > > setting it to > > > > unlimited. > > > > > > > > so i tried setting maxActive to 1000000000 and so far it is > > > generating > > > no > > > > errors. no, i'm wrong. connecs shot up to around 600 or > > maybe more, > > > then > > > we > > > > started getting the java.sql.SQLException: > > > [Microsoft][SQLServer 2000 > > > Driver > > > > for JDBC]Error establishing socket. > > > > > > > > the db has an insanely huge connection limit of 99,999 we think. > > > > > > > > barclay > > > > > > > > -----Original Message----- > > > > From: Eric J. Pinnell [mailto:[EMAIL PROTECTED] > > > > Sent: Friday, August 08, 2003 1:27 PM > > > > To: Tomcat Users List > > > > Subject: RE: Help! heavy traffic is crapping out our site > > > every 5 min! > > > > DBCP exceptions > > > > > > > > > > > > Is it also unlimited (or insanely huge) on the database? > > > > > > > > -e > > > > > > > > On Fri, 8 Aug 2003, Barclay A. Dunn wrote: > > > > > > > > > i adjusted the pool to unlimited and am still getting > > > these errors. > > > > > something else seems to be fekachte. > > > > > > > > > > barclay > > > > > > > > > > -----Original Message----- > > > > > From: Eric J. Pinnell [mailto:[EMAIL PROTECTED] > > > > > Sent: Friday, August 08, 2003 1:11 PM > > > > > To: Tomcat Users List > > > > > Subject: Re: Help! heavy traffic is crapping out our > > site every 5 > > > min! > > > > > DBCP exceptions > > > > > > > > > > > > > > > Hi, > > > > > > > > > > Your pool of connections to your database is exhausted. > > > Try upping > > > the > > > > > number. > > > > > > > > > > -e > > > > > > > > > > On Fri, 8 Aug 2003, Barclay A. Dunn wrote: > > > > > > > > > > > we are getting a ton of these errors in our > catalina.out and i > > > could > > > use > > > > > > help in fixing it. > > > > > > > > > > > > i know they are related to our connection pooling, but > > > not what to > > > do > > > to > > > > > > fix. my understanding of the underlying mechanics of > > connection > > > pooling > > > > is > > > > > > somewhat limited. > > > > > > > > > > > > i have put two different but related error messages in here: > > > > > > > > > > > > java.sql.SQLException: DBCP could not obtain an idle db > > > connection, > > > pool > > > > > > exhausted > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(Aband > > > onedObject > > > Pool > > > > > > .java:123) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.PoolingDataSource.getConnection(Poolin > > > gDataSourc > > > e.ja > > > > > > va:110) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDat > > > aSource.ja > > > va:3 > > > > > > 12) > > > > > > at > > > com.happypuppy.util.HPSql.getConnection(HPSql.java:21) > > > > > > at > > > org.apache.jsp.index_jsp._jspService(index_jsp.java:222) > > > > > > at > > > > > > > > > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > > > > > > at > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServlet > > > Wrapper.ja > > > va:2 > > > > > > 04) > > > > > > at > > > > > > > > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet > > > .java:295) > > > > > > at > > > > > > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > > > > > > at > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.ApplicationDispatcher.invoke(Applicat > > > ionDispatc > > > her. > > > > > > java:684) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.ApplicationDispatcher.doInclude(Appli > > > cationDisp > > > atch > > > > > > er.java:575) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.ApplicationDispatcher.include(Applica > > > tionDispat > > > cher > > > > > > .java:498) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntime > > > Library.ja > > > va:8 > > > > > > 22) > > > > > > at > > > org.apache.jsp._404_jsp._jspService(_404_jsp.java:373) > > > > > > at > > > > > > > > > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > > > > > > at > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServlet > > > Wrapper.ja > > > va:2 > > > > > > 04) > > > > > > at > > > > > > > > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet > > > .java:295) > > > > > > at > > > > > > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > > > > > > at > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > > > er(Applica > > > tion > > > > > > FilterChain.java:247) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > > > cationFilt > > > erCh > > > > > > ain.java:193) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > > > rapperValv > > > e.ja > > > > > > va:260) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > > > eContext.i > > > nvok > > > > > > eNext(StandardPipeline.java:643) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > ine.java:4 > > > 80) > > > > > > at > > > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardC > > > ontextValv > > > e.ja > > > > > > va:191) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > > > eContext.i > > > nvok > > > > > > eNext(StandardPipeline.java:643) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > ine.java:4 > > > 80) > > > > > > at > > > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > > > > > at > > > > > > > > > > > > > org.apache.catalina.core.StandardContext.invoke(StandardContex > > > t.java:241 > > > 5) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > > > Valve.java > > > :180 > > > > > > ) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > > > eContext.i > > > nvok > > > > > > eNext(StandardPipeline.java:643) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > > > spatcherVa > > > lve. > > > > > > java:170) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > > > eContext.i > > > nvok > > > > > > eNext(StandardPipeline.java:641) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > > > Valve.java > > > :172 > > > > > > ) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > > > eContext.i > > > nvok > > > > > > eNext(StandardPipeline.java:641) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > ine.java:4 > > > 80) > > > > > > 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.i > > > nvok > > > > > > eNext(StandardPipeline.java:643) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > ine.java:4 > > > 80) > > > > > > at > > > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > > > > > at > > > > > > > > > > > > org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458) > > > > > > at > > > > > > > > > org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551) > > > > > > at java.lang.Thread.run(Thread.java:536) > > > > > > > > > > > > org.apache.commons.dbcp.DbcpException: > java.sql.SQLException: > > > > > > [Microsoft][SQLServer 2000 Driver for JDBC]Error > establishing > > > socket. > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.DriverConnectionFactory.createConnecti > > > on(DriverC > > > onne > > > > > > ctionFactory.java:85) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(P > > > oolableCon > > > nect > > > > > > ionFactory.java:184) > > > > > > at > > > > > > > > > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown > > > > > Source) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(Aband > > > onedObject > > > Pool > > > > > > .java:117) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.PoolingDataSource.getConnection(Poolin > > > gDataSourc > > > e.ja > > > > > > va:110) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDat > > > aSource.ja > > > va:3 > > > > > > 12) > > > > > > at > > > com.happypuppy.util.HPSql.getConnection(HPSql.java:21) > > > > > > at > > > com.happypuppy.util.HPUser.isLoggedIn(HPUser.java:121) > > > > > > at > > > > > > > > > org.apache.jsp.checkLoggedIn_jsp._jspService(checkLoggedIn_jsp > > > .java:56) > > > > > > at > > > > > > > > > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > > > > > > at > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServlet > > > Wrapper.ja > > > va:2 > > > > > > 04) > > > > > > at > > > > > > > > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet > > > .java:295) > > > > > > at > > > > > > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > > > > > > at > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.ApplicationDispatcher.invoke(Applicat > > > ionDispatc > > > her. > > > > > > java:684) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.ApplicationDispatcher.doInclude(Appli > > > cationDisp > > > atch > > > > > > er.java:575) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.ApplicationDispatcher.include(Applica > > > tionDispat > > > cher > > > > > > .java:498) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntime > > > Library.ja > > > va:8 > > > > > > 22) > > > > > > at > > > org.apache.jsp._404_jsp._jspService(_404_jsp.java:351) > > > > > > at > > > > > > > > > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > > > > > > at > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServlet > > > Wrapper.ja > > > va:2 > > > > > > 04) > > > > > > at > > > > > > > > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet > > > .java:295) > > > > > > at > > > > > > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > > > > > > at > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > > > er(Applica > > > tion > > > > > > FilterChain.java:247) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > > > cationFilt > > > erCh > > > > > > ain.java:193) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > > > rapperValv > > > e.ja > > > > > > va:260) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > > > eContext.i > > > nvok > > > > > > eNext(StandardPipeline.java:643) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > ine.java:4 > > > 80) > > > > > > at > > > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardC > > > ontextValv > > > e.ja > > > > > > va:191) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > > > eContext.i > > > nvok > > > > > > eNext(StandardPipeline.java:643) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > ine.java:4 > > > 80) > > > > > > at > > > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > > > > > at > > > > > > > > > > > > > org.apache.catalina.core.StandardContext.invoke(StandardContex > > > t.java:241 > > > 5) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > > > Valve.java > > > :180 > > > > > > ) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > > > eContext.i > > > nvok > > > > > > eNext(StandardPipeline.java:643) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > > > spatcherVa > > > lve. > > > > > > java:170) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > > > eContext.i > > > nvok > > > > > > eNext(StandardPipeline.java:641) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > > > Valve.java > > > :172 > > > > > > ) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValv > > > eContext.i > > > nvok > > > > > > eNext(StandardPipeline.java:641) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > ine.java:4 > > > 80) > > > > > > 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.i > > > nvok > > > > > > eNext(StandardPipeline.java:643) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > ine.java:4 > > > 80) > > > > > > at > > > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > > > > > at > > > > > > > > > > > > org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458) > > > > > > at > > > > > > > > > org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551) > > > > > > at java.lang.Thread.run(Thread.java:536) > > > > > > Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 > > > Driver > > > for > > > > > > JDBC]Error establishing socket. > > > > > > at > > > > com.microsoft.jdbc.base.BaseExceptions.createException(Unknown > > > > > > Source) > > > > > > at > > > com.microsoft.jdbc.base.BaseExceptions.getException(Unknown > > > > > > Source) > > > > > > at > > > com.microsoft.jdbc.base.BaseExceptions.getException(Unknown > > > > > > Source) > > > > > > at > > > com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown > > > > > > Source) > > > > > > at > > > > > > > com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown > > > > > > Source) > > > > > > at > > > > > > > > > > com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown > > > > > Source) > > > > > > at > com.microsoft.jdbc.base.BaseConnection.open(Unknown > > > Source) > > > > > > at > com.microsoft.jdbc.base.BaseDriver.connect(Unknown > > > Source) > > > > > > at > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.DriverConnectionFactory.createConnecti > > > on(DriverC > > > onne > > > > > > ctionFactory.java:83) > > > > > > ... 51 more > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > > To unsubscribe, e-mail: > > > [EMAIL PROTECTED] > > > > > > For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > > > For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > > > For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
