AS400 DB Adapter polling
HGFeb 20 2013 — edited Feb 21 2013Hi,
We are using SOA suite 11.1.1.6
I have a requirement to poll an AS400 DB2 database. I have imported the jt400.jar in the domain/lib folder. Created the datasource and connection factory.
I configured an dB adapter to poll the AS400 database. When I deployed the soa composite on soa server. I found that it reads the flagged rows
but the instance gets stuck at the db adapter partner link which is the start point of the composite execution and does not process further.
Later I used reserved value along with read and unread value. When I queried the database I noticed that the logical flag gets updated to reserved value
but the post update query is not able to update the flag to read value. So in the process my composite ends up polling the same row repeatatively
with instances stuck at the start point i.e. DB Adapter partner link. :(
Any pointers/suggestion in this regard are highly appreciated.
With Regards,
Harsh