× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




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 <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?


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.