I have read every thread I can find related to as400 and jdbc. Many have reported this same issue but no resolution was ever posted. We are trying to enable an insert notification but keep getting errors. We have the basic notification working fine.
We are running as400 v5r2. The connection profile has full access to eliminate authority issues. For wM we have IS_6-5_SP2, JDBC adapator 6.5 with fixes 4 and 10 installed. Here are the adaptor settings:
Transaction Type = LOCAL_TRANSACTION
DataSource Class = com.ibm.as400.access.AS400JDBCDataSource
dataBase =
portNumber = 8471
networkProtocol = TCP
Other Properties = translatebinary=true;extendeddynamic=true;naming=sql;prompt=false;clischema=QSYS2
Enable Connection Pooling = true
Minimum Pool Size = 0
Maximum Pool Size = 10
Pool Increment Size = 1
Block Timeout (msec) = 1000
Expire Timeout (msec) = 1000
Startup Retry Count = 0
Startup Backoff Timeout (sec) = 10