[Squirrel-sql-users] Constantly losing connection to AS/400(iSeries) Host

[Lennon , S. <sl...@pi...>]

I'm running against a DB2 database on an AS/400 (iSeries) machine.  I'm
using the latest JTOPEN driver (6.5.1) and have tried both 3.0.1 and
3.0.2 of SQuirreL.  

I can connect, download the tables, and run statements.  But if I leave
the session idle for few seconds, say 30, the connection is lost.  I
have tried against two different hosts with the same results.

Using the JDBC-ODBC bridge work fine, except that it seems to reports
phantom errors after some statement complete correctly, and I think the
JDBC driver would solve some of this.

If anyone has any suggestions on how to fix this problem I sure would
like to hear from you.  SQuirreL is a great product at a marvelous
price.