<font size=2 face="sans-serif">Nikos,</font>
<br>
<br><font size=2 face="sans-serif">I have just remembered something Putty
lets you do this </font>
<br><font size=2 face="sans-serif">Sending Null packets - until I set this
my sessions were closing whether connected to Ingres or not . </font>
<br>
<br><font size=2 face="sans-serif">notice I have ticked the TCP_keepalive
option </font>
<br>
<br><font size=2 face="sans-serif">Set at 600 it very rarely loses connection
over Putty - remember I am over Aventail VPN connecting into the
company network</font>
<br><font size=2 face="sans-serif">It would be nice if IngresNet had an
option like this. </font>
<br>
<br><font size=2 face="sans-serif">maybe this will help </font>
<br><font size=2 face="sans-serif">Allan </font>
<br>
<br><img src=cid:_1_0CAA59A00CD7043800388DA38025832E>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:
</font><font size=1 face="sans-serif">Nikos Vaggalis <nikos.vaggalis@gmail.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">Allan Biggs <Allan.Biggs@GBR.dupont.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">16/10/2018 18:33</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">Re: [EXTERNAL]
[Info-ingres] Is Ingres supposed to rollback in case of the connection
dropping?</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=3>I connect from my PC to the local Linux server through
a terminal application and from there I ssh to another Linux machine where
I run the abf application</font>
<br>
<br><font size=3>On Tue, 16 Oct 2018, 11:56 Allan Biggs, <</font><a href=mailto:Allan.Biggs@gbr.dupont.com><font size=3 color=blue><u>Allan.Biggs@gbr.dupont.com</u></font></a><font size=3>>
wrote:</font>
<br><font size=2 face="sans-serif">As a matter of interest are you connected
over VPN when these 'drops' occur?</font><font size=3> </font><font size=2 face="sans-serif"><br>
Allan</font><font size=3> <br>
<br>
<br>
</font><font size=1 color=#5f5f5f face="sans-serif"><br>
From: </font><font size=1 face="sans-serif">nikosv
<</font><a href=mailto:nikos.vaggalis@gmail.com target=_blank><font size=1 color=blue face="sans-serif"><u>nikos.vaggalis@gmail.com</u></font></a><font size=1 face="sans-serif">></font><font size=3>
</font><font size=1 color=#5f5f5f face="sans-serif"><br>
To: </font><a href="mailto:info-ingres@lists.planetingres.org" target=_blank><font size=1 color=blue face="sans-serif"><u>info-ingres@lists.planetingres.org</u></font></a><font size=3>
</font><font size=1 color=#5f5f5f face="sans-serif"><br>
Date: </font><font size=1 face="sans-serif">04/10/2018
11:05</font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
Subject: </font><font size=1 face="sans-serif">[EXTERNAL]
[Info-ingres] Is Ingres supposed to rollback in case of the
connection dropping?</font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
Sent by: </font><a href="mailto:info-ingres-bounces@lists.planetingres.org" target=_blank><font size=1 color=blue face="sans-serif"><u>info-ingres-bounces@lists.planetingres.org</u></font></a><font size=3>
<br>
</font>
<hr noshade><font size=3><br>
<br>
</font><tt><font size=2><br>
In an ABF application I sometimes see transactions being half-done.For
an insert to one table and then an insert to another table within the same
ABF session, having the connection dropped (I guess in between), or some
other Ingres internal exception happening, I find that the first insert
completed successfully but the second not (as it should,since this point
was never reached).Should Ingres had rolled back so that both the statements
fail?<br>
<br>
The session is run with autocommit off, the commit submitted only after
both of the inserts.Also there's checking iierror with <br>
inquire_ingres (h_rowcount = rowcount, h_errorno = errorno), after each
sql statement but I guess that only has an effect as long as there's no
out of the ordinary exceptions ?<br>
_______________________________________________<br>
Info-ingres mailing list</font></tt><tt><font size=2 color=blue><u><br>
</u></font></tt><a href="mailto:Info-ingres@lists.planetingres.org" target=_blank><tt><font size=2 color=blue><u>Info-ingres@lists.planetingres.org</u></font></tt></a><font size=3 color=blue><u><br>
</u></font><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.planetingres.org_mailman_listinfo_info-2Dingres&d=DwICAg&c=zRqMG_fghhK--2M6Q5UUdA&r=NR3Ih16COg3iVzf1V6AnysHgZxJHe-pkPnBl5lbRPSY&m=pqrvPh4_rNY40V3eR29m8OKsNjzdSmirEwQB-WRGtdU&s=jIlBaDw4ARMgUsfUo76B6ctSCr4sNjxmEjU9auPsQ4w&e=" target=_blank><tt><font size=2 color=blue><u>https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.planetingres.org_mailman_listinfo_info-2Dingres&d=DwICAg&c=zRqMG_fghhK--2M6Q5UUdA&r=NR3Ih16COg3iVzf1V6AnysHgZxJHe-pkPnBl5lbRPSY&m=pqrvPh4_rNY40V3eR29m8OKsNjzdSmirEwQB-WRGtdU&s=jIlBaDw4ARMgUsfUo76B6ctSCr4sNjxmEjU9auPsQ4w&e=</u></font></tt></a><font size=3><br>
<br>
</font>
<br><font size=3><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail
does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties.</font>
<p><font size=3>Francais Deutsch Italiano Espanol Portugues
Japanese Chinese Korean</font>
<p><font size=3> </font><a href=http://www.dupont.com/corp/email_disclaimer.html target=_blank><font size=3 color=blue><u>http://www.DuPont.com/corp/email_disclaimer.html</u></font></a>
<p><BR/><p><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties.</p>
<p>Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean</p>
<p> http://www.DuPont.com/corp/email_disclaimer.html</p>