Aaron Mulder wrote:
>
> First of all, if you're not using Minerva, please do.
> Second, Minerva doesn't test connections before it hands them out.
> If we can think of a good way to test a connection, I'd certainly be
> happy to add that. I mean, you could create a statement and close it
> immediately, but there's no way of knowing whether that actually goes
> through to the database or just creates a new data structure on the client
> side. You could execute an invalid SQL statement and catch the exception,
> but that seems kind of heavyweight. There's no "ping" in JDBC!
> There currently is a setting for "InvalidateOnError" that you can
> set to true and it will drop a connection from the pool every time there's
> a SQLException on it (you can change this in jboss.jcml). But that still
> doesn't catch anything util there's a problem. If you can think of a way
> to validate a connection before it leaves the pool, I'm all ears.
I'm not 100% sure of the problem you're trying to solve here, but would
it be possible to use one of the JDBC connections to read the database
metadata, and from that create a JDBC query that could be executed to,
for example, just read some data from one of the tables?
> Oh, and the timeout varies by DB - Oracle connections don't seem
> to timeout (or at least, the timeout is months or longer). You may be
> able to set this in your DBMS or its JDBC driver, but it may be out of
> your hands.
>
> Aaron
>
> On Thu, 14 Sep 2000, Bauer_Wolfgang wrote:
> > Hello,
> >
> > we have the following problem using JBoss with Interbase:
> >
> > JBoss is running on a Linux machine, Interbase 6 is running on another Linux
> > machine.
> > Everything works fine for half an hour. After that time we get a
> >
> > "connection reset by peer" exception
> >
> > when trying to connect to the database.
> >
> > 1) Does anybody know whether JDBC connections are assumed to timeout?
> > If yes, can this timeout be configured somewhere?
> > Is this a operation system issue or does it depend on the database?
> >
> > 2) Given that connections do get lost for some reason (DB server down, etc.)
> > shouldn't
> > jBoss check that and asure that only valid connections are used for data
> > access?
> >
> > Mit freundlichen Gr��en
> >
> > Wolfgang Bauer
> > Softwareentwicklung
> > ______________________________________________________
> >
> > sympat GmbH
> > Automatisierungstechnik & Informationstechnologie
> > ______________________________________________________
> > mailto:[EMAIL PROTECTED]
> > ______________________________________________________
> >
> >
> >
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Problems?: [EMAIL PROTECTED]
> >
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
