Question:
Do you keep your connection all the time? If you
do, it is not adviced to do so. Close it when ever
you can.
Do you use connection pooling?
-D
----- Original Message -----
From: "Ian Hunter" <[EMAIL PROTECTED]>
To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 10:56 AM
Subject: Re: Can I avoid bouncing app when database goes down? (struts 1.0
.2) (try poolman) (use validationQuery)
> 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" <[EMAIL PROTECTED]>
> To: "'Struts Users Mailing List'" <[EMAIL PROTECTED]>
> 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" <[EMAIL PROTECTED]>
> > To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
> > 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" <[EMAIL PROTECTED]>
> > > To: "'Struts Users Mailing List'" <[EMAIL PROTECTED]>
> > > 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" <[EMAIL PROTECTED]>
> > > > To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
> > > > 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: [EMAIL PROTECTED]
> > > > > > 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>
>
--
To unsubscribe, e-mail: <mailto:struts-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:struts-user-help@;jakarta.apache.org>
