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.
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]
