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!

How to throw runtime exception for XAConnection java.sql.SQLException error in bpel

994181Jul 29 2015 — edited Feb 26 2020

Hi ,

In my BPEL flow i am calling an OSB web service to insert data into database . i am not receiving any response from this invoke.

i have used RunTime Exception, Binding Fault Exception and Catch all in my bpel flow.

Just for testing exception handling in my bpel flow, i have suspended osb servers from console. now when i test my actual bpel flow at the time of invoking OSB service, i am getting below response.


<corecom:FaultMessage>

  <corecom:Code>BEA-380002</corecom:Code>

  <corecom:Text>Invoke JCA outbound service failed with connection error, exception: com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/WSDL/CreatePayableInvoiceListAtlasDBAdapter/Resources/WSDL/AtlasDBAdapterService [ AtlasDBAdapterService_ptt::insert(ApInvoicesInterfaceCollection) ] - WSIF JCA Execute of operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception. insert failed. Descriptor name: [AtlasDBAdapterService.ApInvoicesInterface]. Caused by java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceDisabledException: Pool atl03_istf is Suspended, cannot allocate resources to applications.. at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:387) at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:352) at we</corecom:Text>

  <corecom:Severity/>

  <corecom:Stack/>

  </corecom:FaultMessage>

and my flow is calling CommonErrorHandling web service from catch all and continuing the flow for other activities.

but i want my flow should stop at this osb invoke activity and it should call RunTimeFault Exception and it should go in recovery state. which is not happening.

Please let me know , where i am doing wrong and help me to throw run time exception for the test case.

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2015
Added on Jul 29 2015
0 comments
833 views