Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AS400 DB Adapter polling

HGFeb 20 2013 — edited Feb 21 2013
Hi,
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
This post has been answered by Durga Charan on Feb 20 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2013
Added on Feb 20 2013
2 comments
179 views