{"id":1494,"date":"2011-04-17T12:26:46","date_gmt":"2011-04-17T12:26:46","guid":{"rendered":"http:\/\/sendyoursmiles.com\/articles\/bpel-database-adapter-part-1"},"modified":"2014-12-09T06:24:29","modified_gmt":"2014-12-09T06:24:29","slug":"bpel-database-adapter-part-1","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1","title":{"rendered":"BPEL Database Adapter Part 1"},"content":{"rendered":"<div><\/div>\n<div><span style=\"text-decoration: underline;\">Overview:<\/span><\/div>\n<p>Database Adapter is a partnerlink in BPEL which is used to interact with Database for read, write operations. Using Database Adapter we can perform the following functions.<\/p>\n<p>1.Call a Stored Procedure of Function<\/p>\n<p>2.Perform DML operations like insert, update, delete on a table<\/p>\n<p>3.Perform SELECT operation<\/p>\n<p>4.Execute custom SQL Statements<\/p>\n<p>In this Article I will explain how to create simple synchronous BPEL process containing Database Adapter which will read the data from a table and pass the value to output parameter.<\/p>\n<p><span style=\"text-decoration: underline;\">Prerequisites:<\/span><\/p>\n<p>1.You need to establish a Database Connection in Connection Navigator before you proceed further. Refer to my previous article on how to create a Database Connection by clicking the following link http:\/\/erpschools.com\/articles\/bpel-olite-database-connection<\/p>\n<p>2.If this is your first BPEL Process I suggest you to go through my hello world article first.<\/p>\n<p><a href=\"http:\/\/erpschools.com\/articles\/bpel-tutorial-for-beginners-with-helloworld-example\">http:\/\/erpschools.com\/articles\/bpel-tutorial-for-beginners-with-helloworld-example<\/a><\/p>\n<p><span style=\"text-decoration: underline;\">Create Application:<\/span><\/p>\n<p>Open JDeveloper and select Applications in the JDeveloper<\/p>\n<p>Right Click on &#8216;Application&#8217; and select &#8216;New Application&#8217;<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas1.jpg\" \/><\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas2.jpg\" \/><\/p>\n<p>Create Application Window opens as show below<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas3.jpg\" \/><\/p>\n<p>Change the Application Name to &#8216;DatabaseAdapterTutorial&#8217;<\/p>\n<p>Leave remaining fields with default values and click OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas4.jpg\" \/><\/p>\n<p>Click Cancel not the OK button<\/p>\n<p>Create Process<\/p>\n<p>Right click on the DatabaseAdapterTutorial and click New Project as show below<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas5.jpg\" \/><\/p>\n<p>Select &#8216;BPEL Process Project&#8217;\u00a0 from the projects list<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas6.jpg\" \/><\/p>\n<p>Click Ok<\/p>\n<p>Chang the Name which is optional and change the Template to Synchronous BPEL Process as shown below.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas7.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas8.jpg\" \/><\/p>\n<p>Leave the default values and click Finish<\/p>\n<p>DatabaseAdapterTutorial Shows up in the Applications Navigator<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas9.jpg\" \/><\/p>\n<p>On the right side of the jdeveloper window select &#8216;Services&#8217; in the component Palette dropdown box.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas10.jpg\" \/><\/p>\n<p>Select the Database Adapter and Drag it to right side Services portion of jdeveloper main window<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas11.jpg\" \/><\/p>\n<p>Adapter Configuration Wizard screen will pop up as below<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas12.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas13.jpg\" \/><\/p>\n<p>Enter the Service Name as &#8216;FetchEmail&#8217;<\/p>\n<p>Description field is optional<\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas14.jpg\" \/><\/p>\n<p>Select the Database Connection &#8216;BPELOlite&#8217; from the Connection list. This connection varies as you create Database connections in Connection Navigator<\/p>\n<p>Leave the JNDI Name with default value and click next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas15.jpg\" \/><\/p>\n<p>Select &#8216;Perform an Operation on a Table&#8217; option from the list<\/p>\n<p>check Only &#8216;SELECT&#8217; checkbox<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas16.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas17.jpg\" \/><\/p>\n<p>Click on Import Tables button<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas18.jpg\" \/><\/p>\n<p>Click on the Query button to see the list of tables available in your database<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas19.jpg\" \/><\/p>\n<p>Select the Table name from the list on which you want to operate the select command<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas20.jpg\" \/><\/p>\n<p>I have selected the table ERPSCHOOLS. I am listing the commands below to create the table ERPSCHOOLS if you want to use<\/p>\n<p>Now Click Ok<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas21.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas22.jpg\" \/><\/p>\n<p>Select all columns and click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas23.jpg\" \/><\/p>\n<p>I am not creating any relationship with this table so just click Next button<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas24.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas25.jpg\" \/><\/p>\n<p>SELECT command is shown in SQL box.\u00a0 If you want to add any parameters to the query you can add it here. You can also directly edit your SQL statement. I am changing my SQL statement to fetch only one record.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas26.jpg\" \/><\/p>\n<p>Click Next<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas27.jpg\" \/><\/p>\n<p>Click Finish<\/p>\n<p>Create Partner link will pop up as shown below<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas28.jpg\" \/><\/p>\n<p>Leave all fields with default values and click OK<\/p>\n<p>Now your BPEL main window screen should look like the below screen<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas29.jpg\" \/><\/p>\n<p>Fetch email partner link\/Database Adapter will show in Service area as shown in the red circle.<\/p>\n<p>Now select &#8216;Process Activities&#8217; in the Component Palette<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas30.jpg\" \/><\/p>\n<p>Select and Drag the Invoke activity below the receiveInput activity<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas31.jpg\" \/><\/p>\n<p>Double click the Invoke_1 activity<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas32.jpg\" \/><\/p>\n<p>Change the Name to Invoke_FetchEmail<\/p>\n<p>Click on the Flashlight right to Partner Link Field<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas33.jpg\" \/><\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas34.jpg\" \/><\/p>\n<p>Select FetchEmail and click OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas35.jpg\" \/><\/p>\n<p>Partner Link and Operation fields are populated automatically<\/p>\n<p>Click on the Create Variable fields right to both input and output Variables<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas36.jpg\" \/><\/p>\n<p>Click the small red circle icon, create variable window will pop up as shown below<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas37.jpg\" \/><\/p>\n<p>Click Ok<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas38.jpg\" \/><\/p>\n<p>Now click on red circle icon right to output variable<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas39.jpg\" \/><\/p>\n<p>Click Ok<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas40.jpg\" \/><\/p>\n<p>Click Apply<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas41.jpg\" \/><\/p>\n<p>If you have everything correctly you should not see the errors in the red circle show in the above figure.<\/p>\n<p>If you don&#8217;t have any errors click OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas42.jpg\" \/><\/p>\n<p>Main screen should look like the above picture.<\/p>\n<p>We have created the Invoke activity which will call Database Adapter(FetchEmail) and Database Adapter will query the table ERPSCHOOLS and fetches email field value. Now to catch the value fetched by Database Adapter use Assign Activity, which will transfer the value of email field fetched by Database Adapter to replyOutput field.<\/p>\n<p>Drag the Assign activity from the component palette to mainwindow below the Invoke_FetchEmail activity.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas43.jpg\" \/><\/p>\n<p>Double click on Assign_1 activity to open the Assign properties window<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas44.jpg\" \/><\/p>\n<p>Chang the name to Assign_Email and click on the second tab &#8216;Copy Operation&#8217;<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas45.jpg\" \/><\/p>\n<p>Click Create button circled above and select &#8216;Copy Operation&#8217; to open the Create Copy Operation window as show below<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas46.jpg\" \/><\/p>\n<p>Select ns2:email on the left and client:result on the right side as show below<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas47.jpg\" \/><\/p>\n<p>Click OK<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas48.jpg\" \/><\/p>\n<p>Click Apply to remove the errors<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas49.jpg\" \/><\/p>\n<p>Click Ok<\/p>\n<p>Save your project by clicking CTRL+S<\/p>\n<p>DEPLOY BPEL Process<\/p>\n<p>Now we are ready to deploy the process, Start your SOA Suite and deploy the process<\/p>\n<p>If you are not familiar with deploy process follow the link to see how to deploy the process<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas50.jpg\" \/><\/p>\n<p>After you deploy your process successfully your Apache Ant log will show like this<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas51.jpg\" \/><\/p>\n<p>Run the BPEL Process<\/p>\n<p>Go to your BPEL Console<\/p>\n<p><a href=\"http:\/\/localhost:8888\/BPELConsole\">http:\/\/localhost:8888\/BPELConsole<\/a><br \/>\nlogin in with oc4jadmin\/welcome1 (default values)<\/p>\n<p>Once you login to console you can see &#8216;DatabaseAdapterTutorial&#8217; project in the Deployed BPEL Processes list.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas52.jpg\" \/><\/p>\n<p>Click on DatabaseAdapterTutorial<\/p>\n<p>The initiate screen will show up<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas53.jpg\" \/><\/p>\n<p>Click on Post XML Message<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas54.jpg\" \/><\/p>\n<p>Click on Visual Flow<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas55.jpg\" \/><\/p>\n<p>Click on Assign_Email activity to see the output<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas56.jpg\" \/><\/p>\n<p>The result field contains prudhvi@erpschools.com which is my output.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview: Database Adapter is a partnerlink in BPEL which is used to interact with Database for read, write operations. Using Database Adapter we can perform the following functions. 1.Call a Stored Procedure of Function 2.Perform DML operations like insert, update, delete on a table 3.Perform SELECT operation 4.Execute custom SQL Statements In this Article I [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[72],"class_list":["post-1494","post","type-post","status-publish","format-standard","hentry","category-fusion-middleware","tag-bpel-database-adapter"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>oracle bpel database adapter example<\/title>\n<meta name=\"description\" content=\"oracle bpel database adapter example\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"BPEL Database Adapter Part 1\",\"datePublished\":\"2011-04-17T12:26:46+00:00\",\"dateModified\":\"2014-12-09T06:24:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1\"},\"wordCount\":928,\"commentCount\":11,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas1.jpg\",\"keywords\":[\"BPEL database adapter\"],\"articleSection\":[\"Fusion Middleware\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1\",\"url\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1\",\"name\":\"oracle bpel database adapter example\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas1.jpg\",\"datePublished\":\"2011-04-17T12:26:46+00:00\",\"dateModified\":\"2014-12-09T06:24:29+00:00\",\"description\":\"oracle bpel database adapter example\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#primaryimage\",\"url\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas1.jpg\",\"contentUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BPEL Database Adapter Part 1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"oracle bpel database adapter example","description":"oracle bpel database adapter example","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"BPEL Database Adapter Part 1","datePublished":"2011-04-17T12:26:46+00:00","dateModified":"2014-12-09T06:24:29+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1"},"wordCount":928,"commentCount":11,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas1.jpg","keywords":["BPEL database adapter"],"articleSection":["Fusion Middleware"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1","url":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1","name":"oracle bpel database adapter example","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas1.jpg","datePublished":"2011-04-17T12:26:46+00:00","dateModified":"2014-12-09T06:24:29+00:00","description":"oracle bpel database adapter example","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#primaryimage","url":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas1.jpg","contentUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1224_BPELDatabas1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/fusion-middleware\/bpel-database-adapter-part-1#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"BPEL Database Adapter Part 1"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=1494"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1494\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=1494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=1494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=1494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}