We are running ES 5.0.1 and JDBC adapter 4.2.1 (I think). We have an integration component that selects data from DB2 and updates one row via a stored procedure and publishes a document. The next component writes a file and publishes another document. The JDBC adapter receives that document and updates the row again via the same stored procedure.
Monday and Tuesday are heavy days for volume and we get numerous timeouts on the second (and smaller) call to the stored procedure.
Our DBA’s are telling use that the two processes timing-out are webMethods but I’m puzzled because the adapter should be single threaded according to the settings on the Performance tab.
Therefore, one document should finish processing before another one starts.
Anybody else experience anything like this?