tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "arvind singh" <sing...@hotmail.com>
Subject Re: Problem while accessing the MSSQL from tomcat
Date Wed, 04 Feb 2004 17:55:25 GMT
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" <rahulsale@yahoo.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
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 <singh_a@hotmail.com> wrote:
> > Can you post the Database URL you are using to
> > connect to the Database?
> >
> > ----- Original Message -----
> > From: "Sale Rahul" <rahulsale@yahoo.com>
> > To: <tomcat-user@jakarta.apache.org>
> > Cc: <rsaley@apsora.com>
> > 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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message