Hello arvind, Thanks a lot for this. can you send me some pointers where i can get some more info.
Thanks , thanks again. Sincerly Rahul --- arvind singh <[EMAIL PROTECTED]> wrote: > 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 > === 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]
