I have two connection The Server and the BackupServer.
The task is running one table at the time. Time between for the next table to process is about 1 Minute.
In this Minute checks will be done like have connection and some other thinks.
Before the next table is processed a Ping is done to the Network.
If we have connect it will process otherwise it stops and some other process will go on to check if we have the connection back and we start over again.
Wait For is not helping in this
I try to check the Resultset for changes with.
Sub IsValidConnection(RS As ResultSet) As Boolean
Try
Dim JO As JavaObject
Dim TimeoutSecs As Int = 1
JO = RS
' JO = JO.GetFieldJO("connection")
' JO = JO.GetFieldJO("")
Return JO.RunMethod("isClosed", Null) 'Array As Object (TimeoutSecs))
Catch
Log("Error in Is ValidConnection")
End Try
End Sub
Somehow something has to change in this resultset if the Connection is lost.