struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ian Hunter" <ihun...@hunterweb.net>
Subject Re: Can I avoid bouncing app when database goes down? (struts 1.0 .2) (try poolman) (use validationQuery)
Date Wed, 30 Oct 2002 18:56:48 GMT
OK, I implemented that throughout my app and it worked so long as I kept the
database up, but if I logged into my app, dropped the database and brought
it back up, I would get this:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection
reset by peer: socket write error
 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.TDSRPCRequest.submitRequest(Unknown
Source)
 at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown
Source)
 at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown
Source)
 at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
 at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown
Source)
 at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
 at
com.codestudio.sql.PoolManStatement.executeQuery(PoolManStatement.java:105)

So I implemented a "validationQuery" (I used "select 0") to ensure that
connections were up.  I imagine this will slow things down a hair, but I
think I have a workable solution.

Comments?

----- Original Message -----
From: "Zeltser, Mark" <Mark.Zeltser@lehman.com>
To: "'Struts Users Mailing List'" <struts-user@jakarta.apache.org>
Sent: Wednesday, October 30, 2002 11:26 AM
Subject: RE: Can I avoid bouncing app when database goes down? (struts 1.0
.2) (try poolman)


> Ian,
>
> You will need to configure poolman.xml and put it in your
> app/WEB-INF/classes directory.
>
> Then you can do the following:
>
> DataSource dataSource =  PoolMan.findDataSource(
Constants.DATASOURCE_KEY );
> Connection connection =  dataSource.getConnection();
>
> Take a look at docs included with Poolman for configuration options.
>
> Mark.
>
> -----Original Message-----
> From: Ian Hunter [mailto:ihunter@hunterweb.net]
> Sent: Wednesday, October 30, 2002 11:18 AM
> To: Struts Users Mailing List
> Subject: Re: Can I avoid bouncing app when database goes down? (struts
> 1.0 .2) (try poolman)
>
>
> http://www.codestudio.com/index.shtml allowed me to download it.  That's
so
> weird.
>
> Anyway, is there any way to implement this just by specifying the class in
> struts-config.xml, so I wind up with code like this?
>
>             ds = (PoolmanConnection)
> servlet.getServletContext().getAttribute(Constants.DATABASE_KEY);
>             conn = ds.getConnection();
>
> Or do I have to jump through all kinds of hoops?
>
> ----- Original Message -----
> From: "Ian Hunter" <ihunter@hunterweb.net>
> To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
> Sent: Wednesday, October 30, 2002 11:04 AM
> Subject: Re: Can I avoid bouncing app when database goes down? (struts 1.0
> .2) (try poolman)
>
>
> > http://www.codestudio.com says it is no longer supported.  I'll keep
> > looking, but if you have any suggestions...
> >
> > ----- Original Message -----
> > From: "Zeltser, Mark" <Mark.Zeltser@lehman.com>
> > To: "'Struts Users Mailing List'" <struts-user@jakarta.apache.org>
> > Sent: Wednesday, October 30, 2002 9:49 AM
> > Subject: RE: Can I avoid bouncing app when database goes down? (struts
1.0
> > .2)
> >
> >
> > > I had the same problem. Try using poolman (I had to patch it since it
> was
> > > running in endless loop whenever sybase server was rebooted)
> > >
> > > -----Original Message-----
> > > From: Ian Hunter [mailto:ihunter@hunterweb.net]
> > > Sent: Wednesday, October 30, 2002 8:39 AM
> > > To: Struts Users Mailing List
> > > Subject: Re: Can I avoid bouncing app when database goes down? (struts
> > > 1.0.2)
> > >
> > >
> > > 1.0.2; kinda old, I guess...
> > >
> > > ----- Original Message -----
> > > From: "James Mitchell" <jmitchtx@telocity.com>
> > > To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
> > > Sent: Wednesday, October 30, 2002 12:14 AM
> > > Subject: RE: Can I avoid bouncing app when database goes down?
> > >
> > >
> > > > What version of Struts are you using?
> > > >
> > > > There were some changes made in DBCP a few weeks ago that might help
> > with
> > > > that, but I could be wrong.
> > > >
> > > > James Mitchell
> > > > Software Engineer/Struts Evangelist
> > > > http://www.open-tools.org
> > > >
> > > > "Only two things are infinite, the universe and human stupidity, and
> I'm
> > > not
> > > > sure about the former."
> > > > - Albert Einstein (1879-1955)
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: Ian Hunter [mailto:ihunter@hunterweb.net]
> > > > > Sent: Tuesday, October 29, 2002 11:29 PM
> > > > > To: struts-user@jakarta.apache.org
> > > > > Subject: Can I avoid bouncing app when database goes down?
> > > > >
> > > > >
> > > > > I have struts app that works great until MSDE (MS SQL Server)
drops
> a
> > > > > connection, then I have to reset the whole app.  I'm connecting to
a
> > > > > datasource defined in struts-config.xml and using the ms sql
native
> > jdbc
> > > > > drivers.
> > > > >
> > > > > Any ideas?


--
To unsubscribe, e-mail:   <mailto:struts-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:struts-user-help@jakarta.apache.org>


Mime
View raw message