I dont want your web URL. I want the connection URL you are using to connect to DB.
e.g. DBName=/yourdb?autoReconnect=true DBUserName=your user DBPassword=your password JDBCDriverName=jdbc:mysql:// These are connection parameters for MySQL. Note "?autoReconnect=true" if you driver supports this please try adding to your connection URL. ----- Original Message ----- From: "Sale Rahul" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Wednesday, February 04, 2004 12:49 PM Subject: Re: Problem while accessing the MSSQL from tomcat > Hello arvind , > I donot mind giving you the URL. Which is little > secure one.But let me know what are yo ulooking > at.Hope you understand. > Thanks for kind attention.... > > Sincerly > Rahul > --- arvind singh <[EMAIL PROTECTED]> wrote: > > Can you post the Database URL you are using to > > connect to the Database? > > > > ----- Original Message ----- > > From: "Sale Rahul" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Wednesday, February 04, 2004 12:05 PM > > Subject: Problem while accessing the MSSQL from > > tomcat > > > > > > > Hello All, > > > We are in deep trouble.Here is the problem, we are > > > facing. > > > First let me elobarate the scenario. > > > We have Tomcat 4 running on the Linux box.We are > > > trying to access the MS-SQL which is running on > > the > > > Win2k . > > > We are using Datasource to access the MS-SQL from > > Java > > > Servlets. It has been observed that ,after hardly > > 10 > > > to 20 requests there is Pipe broken error. > > > We are accessing servlet from web browser.And we > > are > > > NOT pressing STOP button when we can this URL.Why > > I am > > > saying this is , in one of the bug report with ID > > > 4663, > > > it has been mentioned that in case the user > > presses > > > the stop button in between , then in that case > > there > > > is a problem of pipe broken.But we are not doing > > it > > > any time.So not sure why is hat happening and how > > to > > > fix it. > > > > > > Actual Exception in the catalina.out is as follows > > : > > > > > > 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 > > > > > > java.sql.DriverManager.getConnection(DriverManager.java:512) > > > at > > > > > > java.sql.DriverManager.getConnection(DriverManager.java:171) > > > at com.apsora.jsp.DataSrc.connect(DataSrc.java:24) > > > at > > > > > > com.apsora.jsp.DataSrc.getQueryResult(DataSrc.java:38) > > > at > > > > > > org.apache.jsp.TestJSP_jsp._jspService(TestJSP_jsp.java:123) > > > at > > > > > > org.apache.jasper.runtime.HttpJspBase.service(Unknown > > > Source) > > > at > > > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java) > > > at > > > > > > org.apache.jasper.servlet.JspServletWrapper.service(Unknown > > > Source) > > > at > > > > > > org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown > > > Source) > > > at > > > > > org.apache.jasper.servlet.JspServlet.service(Unknown > > > Source) > > > at > > > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java) > > > at > > > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardWrapperValve.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.ContainerBase.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardContextValve.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.valves.AccessLogValve.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.ContainerBase.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardContext.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardHostValve.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.valves.ErrorReportValve.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.StandardPipeline.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.core.ContainerBase.invoke(Unknown > > > === message truncated === > > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free web site building tool. Try it! > http://webhosting.yahoo.com/ps/sb/ > > --------------------------------------------------------------------- > 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]
