Re: Reconnection from a dropped AS400 object
JOE SAM SHIRAH <[email protected]>
| Newsgroups | gmane.comp.lang.as400.java |
|---|---|
| Message-ID | <[email protected]> |
Hi Kelly,
I'd suggest looking into using a connection pool to handle the heavy lifting. The good ones check for stale connections, leaks, and timeouts. I've used HikariCP:
https://github.com/brettwooldridge/HikariCP
https://github.com/brettwooldridge/HikariCP/wiki/Bad-Behavior:-Handling-Database-Down
in a similar situation against SQL Server with good results. In general, Java connection pools should handle any driver that provides a standard DataSource.
Also, you might consider using an email without "verybigliar" in it for forum posts. ;-)
HTH,
Joe Sam
Joe Sam Shirah - www.conceptgo.com (904) 302-6870
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: www.ibm.com/developerworks/java
Just the JDBC FAQs: www.jguru.com/faq/JDBC
Going International? www.jguru.com/faq/I18N
Que Java400? www.jguru.com/faq/Java400
On Wednesday, August 21, 2019, 4:21:52 PM EDT, Kelly Beard <[email protected]> wrote:
I wonder if there's a tried-and-true technique to cause a Java program to
go to sleep when a connection of AS400 is dropped, say if a machine is
IPL'd. I'm playing with the ConnectionListener stuff and the AS400JPing
class. What I'm trying to do is cause a program to just go to sleep until
the box and any service that I want to use is restored. What I wish the
AS400 class had is a reconnect() method.
Anyone doing anything like this?
--
Kelly Beard
--
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.
Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com