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:
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. ;-)
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 <kenverybigliar@xxxxxxxxx> 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?