Raible, Matt wrote:
I've discovered that this problem is related to a 90-minute timeout on our
firewall. Tomcat sits outside of the firewall, and Oracle resides inside.
Since there's no activity for 90 minutes, it closes the connection. Anyone
know of a workaround (+ sample code) for this? I'm
uming a ping of some
sort using the database connection pool would work.
Thanks,
Matt
> -Original Message-
> From: Ryan Cornia [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 29, 2003 10:03 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Can the JNDI Connection Pool re-co
CTED]>
Sent: Wednesday, January 29, 2003 3:55 PM
Subject: Re: Can the JNDI Connection Pool re-connect after failure?
> Ryan Cornia wrote:
> > This solution seems to work great for me. After adding this and
> > re-booting the database server, it re-connected and worked great
>
Ok Thank you very much...
I'm going to test that...
- Original Message -
From: "Ryan Cornia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 29, 2003 3:48 PM
Subject: RE: Can the JNDI Connection Pool re-connect after failure?
> Thi
Ryan Cornia wrote:
> This solution seems to work great for me. After adding this and
> re-booting the database server, it re-connected and worked great
> automatically
Same for me. It works too with postgresql. It would be interesting to know
how big the overhead is for this check. Is the chec
I don't have any timeout settings set. I'm also not using the driver
from Oracle. I'm using a third party driver from inetsoftware.de. If
it's not working in 24 hours, I'll let your know.
Ryan
>>> [EMAIL PROTECTED] 01/29/03 09:43AM >>>
Will it work for 24 hours is the question... ;) If it does,
> From: Ryan Cornia [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 29, 2003 7:49 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Can the JNDI Connection Pool re-connect after failure?
>
>
> This solution seems to work great for me. After adding this and
> re-booting the
This solution seems to work great for me. After adding this and
re-booting the database server, it re-connected and worked great
automatically
Thanks a ton Nix.
Ryan
>>> [EMAIL PROTECTED] 01/29/03 07:11AM >>>
I've tried adding the following and I still have the same problem as
Ryan.
sers List
> Subject: Re: Can the JNDI Connection Pool re-connect after failure?
>
>
> Boris Folgmann wrote:
> > Ryan Cornia wrote:
> >
> >
> >>Anyone using JNDI datasources that reconnect in case of a
> lost link to
> >>the DB server?
> >&g
Nikola Milutinovic wrote:
> I believe that if you set up "connection verification query" in your DataSource
> definition in server.xml it will reconnect. Haven't tried it, though.
Do you know that it was made for this purpose or are you simpley guessing
from the Javavdoc?
--
Boris Folgmann wrote:
Ryan Cornia wrote:
Anyone using JNDI datasources that reconnect in case of a lost link to
the DB server?
Any examples? I'm using the I-net driver for Oracle
Interesting question. In fact I have the same problem, using DBCP and
PostgreSQL. I looked trough the Javadocs a
I'm not sure whether the "parameter" functions as a Tomcat datasource
parameter or MySQL driver parameter. I've never done it with an
Oracle
driver.
-Original Message-
From: Ryan Cornia [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 07:43
To: >
Subject: Ca
Oracle
driver.
-Original Message-
From: Ryan Cornia [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 07:43
To: >
Subject: Can the JNDI Connection Pool re-connect after failure?
I have set a JNDI connection pool up in server.xml that works, however
if the database server goes
e: Can the JNDI Connection Pool re-connect after failure?
>
>Ryan Cornia wrote:
>
>> Anyone using JNDI datasources that reconnect in case of a lost link
to
>> the DB server?
>>
>> Any examples? I'm using the I-net driver for Oracle
>
>Interesting question. In
Ryan Cornia wrote:
> Anyone using JNDI datasources that reconnect in case of a lost link to
> the DB server?
>
> Any examples? I'm using the I-net driver for Oracle
Interesting question. In fact I have the same problem, using DBCP and
PostgreSQL. I looked trough the Javadocs at
http://jakarta.ap
I have set a JNDI connection pool up in server.xml that works, however
if the database server goes down, it doesn't re-connect when it comes
back up.
Anyone using JNDI datasources that reconnect in case of a lost link to
the DB server?
Any examples? I'm using the I-net driver for Oracle.
Thanks
16 matches
Mail list logo
