This article would cover setups required to enable BPEL to poll Oracle apps adapter as well as we will also see an example of how all of this fits together
1) Setup Data Source and Connection Pooling in Application Server
Click on Application Server Control
Click on JDBC resources in the service section
Select “New Connection Pool” and click continue.
Fill in the required details and give the connection details of database and click on “Test Connection “ . If connection parameters are proper you would get a message “Connection established successfully.” .
Click Finish .
You would see your new connection pool created ( BpelTesting)
Keep all the default values . ( Verify “Managed Data Source” is selected ).
Click continue
Note Down the JNDI location : ebiz/BpelTesting
And DataSourceName :BPELTestingConnectionPool
8 ) Setup Oracle Apps adapter
Go back to cluster topology , change view by from “Application server” to “Application” .
Click on AppsAdapter
Click on connection Factories and create a new connection factory
9 )
Now open jdeveloper
Create a new project ( Select BPEL Process Project and select Asynchronous BPEL Process ) and finish
Select oracle applications adapter and drop them onto services lane
Give the JNDI Name created in step 7
Select oracle public API ,in this case I am selecting order delete API .It takes order_header_id as parameter .
Partner role will be defaulted.
Drag and drop invoke activity between receiveInput and callbackClient.
This is to invoke Oracle Application Adapter service from the client .
This will default the Operation which you can perform on API.
Create Global input and output variable .
Drag and drop assign activity between invoke and receive input activity. This assign activity is to copy value from input to input parameter for API.
Similarly drag and drop one more assign activity between invoke and Callback client activity .This is to copy API output to BPEL output variable.
Once the design is validated deploy to the application server.
Note down the header id : 273876 and order Number : 143211
Test the BPEL process from BEPL Console
Click on the link “OracleDeleteBpelAS”
Give the order header ID as Input and
Post xml message
In the Audit XML you would see retur_status as ‘S’ . It signified order has been successfully deleted .
Subscribe to this comment's feedwritten by ronald , August 21, 2009
written by Kelvin , November 16, 2009
-
-
-
-
-
12401
-
-
-
null
-
file:/D:/product/10.1.3.1/OracleAS_1/bpel/domains/default/tmp/.bpel_OrderDeletedBPEL_1.0_d41264bb3ada8bac208cd33d844c74af.tmp/DeleteOrder.wsdl [ DeleteOrder_ptt:
eleteOrder(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'DeleteOrder' failed due to: Could not create/access the TopLink Session. This session is used to connect to the datastore. [Caused by: BPELTestingConnectionPool not found] ; nested exception is: ORABPEL-11622 Could not create/access the TopLink Session. This session is used to connect to the datastore. [Caused by: BPELTestingConnectionPool not found] See root exception for the specific exception. You may need to configure the connection settings in the deployment descriptor (i.e. $J2EE_HOME/application-deployments/default/DbAdapter/oc4j-ra.xml) and restart the server. Caused by Exception [TOPLINK-7060] (Oracle TopLink - 10g Release 3 (10.1.3.1.0) (Build 061004)): oracle.toplink.exceptions.ValidationException Exception Description: Cannot acquire data source [BPELTestingConnectionPool]. Internal Exception: javax.naming.NameNotFoundException: BPELTestingConnectionPool not found. -
Exception Description: Cannot acquire data source [BPELTestingConnectionPool]. Internal Exception: javax.naming.NameNotFoundException: BPELTestingConnectionPool not found
written by Oracletube , February 15, 2010
Looking at the error trace looks like a firewall issue or Database issue. Did you try checking the database. The error says This session is used to connect to the datastore. Check the connection to your datastore.
Cheers,
Oracletube.com
www.oracletube.com - Social networking and Interactive Learning of Oracle Products...Check it out.
how to raise an invoice in acount payables