I have a batch insert JDBC adapter service, when I am calling the sevice from a flow its getting hanged. Volume of record is substantially low (1 to 40 records). I tried to disable the adapter connection but again it hanged too. Even am not able to relaod the package. I don’t see anything wrong in the server log apart from connected to database with Local_Transaction. Now if I call another adapter service (select) using same connection its getting hanged too.
I am using explicit transactions but couldn’t able to identify the real cause of this problem.
Server details are : IS 6.1 ,JDBC adapter ver 6.0.3 and database Oracle 9
Please let me know your thoughts.