You might be running into this: http://www.mail-archive.com/[EMAIL PROTECTED]/msg99184.html
http://www.mail-archive.com/[EMAIL PROTECTED]/msg99331.html > -----Original Message----- > From: Angus Mezick [mailto:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 4:53 PM > To: Tomcat Users List > Subject: RE: Help! heavy traffic is crapping out our site > every 5 min! DBCP exceptions > > > You might want to switch over to the commons-dev list at this > point and talk to the dbcp people themselves. But for > starters I suggest you try to build the dbcp tip and see how > that goes. > > > -----Original Message----- > > From: Barclay A. Dunn [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 08, 2003 5:49 PM > > To: Tomcat Users List > > Subject: RE: Help! heavy traffic is crapping out our site > > every 5 min! DBCP exceptions > > > > > > ok, well, at least we have concrete proof of it. > > > > now, given that i can confirm that i am closing connections > > (calling close() > > on them, which returns them to the pool), can you suggest how > > i might locate > > where those connections are not getting released? i have read > > some stuff > > about dbcp not being entirely reliable in releasing > > connections. is that > > true? argh. > > > > thanks again, > > barclay > > > > -----Original Message----- > > From: Angus Mezick [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 08, 2003 4:27 PM > > To: Tomcat Users List > > Subject: RE: Help! heavy traffic is crapping out our site > every 5 min! > > DBCP exceptions > > > > > > Yup, and when nothing is happening, the # of active > connections should > > be 0. If it isn't you aren't releasing connections properly. > > > > > -----Original Message----- > > > From: Barclay A. Dunn [mailto:[EMAIL PROTECTED] > > > Sent: Friday, August 08, 2003 4:19 PM > > > To: Tomcat Users List > > > Subject: RE: Help! heavy traffic is crapping out our site every 5 > > > min! DBCP exceptions > > > > > > > > > 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] > > > > > > > > > > > --------------------------------------------------------------------- > > 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]