Hi Trafodioneers, I am playing with a spj that uses T4 connection to perform long running upsert operation from one table to another.
It worked fine on small tables, but testing it on very large table, where each upsert takes a lot more time, I am getting these: "Thread 62, partition 2451039, Exception:org.trafodion.jdbc.t4.TrafT4Exception: Server aborted abnormally or Connection timed out". I suspected something along socket timeouts not expecting work to be so long on the DB side, and thought I'll just have to configure some jdbc default time out and be OK with it. But when I look at the documentation, the following properties have default that looks OK, (not sure about the connectionTimeout?): connectionTimeout -> -1 (Use the ConnTimeout value set on the server data source.) maxIdleTime 0 -> means specify no limit networkTimeout 0 -> means no network timeout specified So what could this be? Are these documented defaults not accurate? Thanks in advance for the help, Eric
