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-connect after failure?
I don't have
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
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
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?
Users 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?
Any examples? I'm using the I-net driver for Oracle
Interesting
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.
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 database server, it re-connected and worked great
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, maybe
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 check
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?
This solution seems to work great for me
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
automatically
Same for me. It works too with postgresql. It would
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.
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
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 fact I have the same problem, using DBCP and
PostgreSQL. I looked trough
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: Can the JNDI Connection Pool re-connect after failure?
I have set a JNDI connection pool up in server.xml that works
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 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
16 matches
Mail list logo