Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » Tomcat Users »

Re: Problem while accessing the MSSQL from tomcat

Sale Rahul

2004-02-04

Replies:

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 <singh_a@(protected):
> 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@(protected)>
> To: "Tomcat Users List"
> <tomcat-user@(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 <singh_a@(protected):
> > > Can you post the Database URL you are using to
> > > connect to the Database?
> > >
> > > ----- Original Message -----
> > > From: "Sale Rahul" <rahulsale@(protected)>
> > > To: <tomcat-user@(protected)>
> > > Cc: <rsaley@(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: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)


©2008 junlu.com - Jax Systems, LLC, U.S.A.