{"id":2838,"date":"2011-07-28T13:50:31","date_gmt":"2011-07-28T18:50:31","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=2838"},"modified":"2015-04-17T13:52:03","modified_gmt":"2015-04-17T18:52:03","slug":"soa-11g-tutorial-service-data-objects-sdo","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=2838","title":{"rendered":"SOA 11g Tutorial: Service Data Objects (SDO)"},"content":{"rendered":"
\n

Contents<\/h2>\n
    \n\t
  1. \n\t\tOverview<\/a>\n\t<\/li>\n\t
  2. \n\t\tPrepare Database Table<\/a>\n\t<\/li>\n\t
  3. \n\t\tCreate ADF-BC Service<\/a>\n\t\t
      \n\t\t\t
    1. \n\t\t\t\tCreate an ADF-BC Application<\/a>\n\t\t\t<\/li>\n\t\t\t
    2. \n\t\t\t\tCreate Business Components<\/a>\n\t\t\t<\/li>\n\t\t\t
    3. \n\t\t\t\tTesting Application Module<\/a>\n\t\t\t<\/li>\n\t\t\t
    4. \n\t\t\t\tCreate Service Interface<\/a>\n\t\t\t<\/li>\n\t\t\t
    5. \n\t\t\t\tDeploy Application Module<\/a>\n\t\t\t\t
        \n\t\t\t\t\t
      1. \n\t\t\t\t\t\tConfigure Module<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
      2. \n\t\t\t\t\t\tSet Web App Name and Context Root<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
      3. \n\t\t\t\t\t\tCreate Deployment Profile<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
      4. \n\t\t\t\t\t\tSet Application Name<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
      5. \n\t\t\t\t\t\tSetup WebLogic Life Cycle Listener<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
      6. \n\t\t\t\t\t\tDeploy<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t<\/ol>\n\t\t\t
      7. \n\t\t\t\tTest Customer SDO Service<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
      8. \n\t\tUsing ADF-BC Service in POProcessing Composite Application<\/a>\n\t\t
          \n\t\t\t
        1. \n\t\t\t\tAdd CustomerSDOService Reference<\/a>\n\t\t\t<\/li>\n\t\t\t
        2. \n\t\t\t\tWire approveLargeOrder BPEL Process to CustomerSDO Service<\/a>\n\t\t\t<\/li>\n\t\t\t
        3. \n\t\t\t\tUse SDO in BPEL<\/a>\n\t\t\t\t
            \n\t\t\t\t\t
          1. \n\t\t\t\t\t\tBind Primary Key<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
          2. \n\t\t\t\t\t\tGet Customer Name from Entity Variable<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
          3. \n\t\t\t\t\t\tAssign Last Order<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t<\/ol>\n\t\t\t
          4. \n\t\t\t\tTest<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
          5. \n\t\tIssues<\/a>\n\t\t
              \n\t\t\t
            1. \n\t\t\t\tCould not find registry for CustomerApp_JBOServiceRegistry<\/a>\n\t\t\t\t
                \n\t\t\t\t\t
              1. \n\t\t\t\t\t\tCause<\/a>\n\t\t\t\t\t<\/li>\n\t\t\t\t\t
              2. \n\t\t\t\t\t\tFix<\/a>\n\t\t\t\t\t<\/li>\n<\/ol>\n<\/ol>\n<\/ol>\n<\/ol>\n<\/div>\n
                 <\/div>\n

                This is part of the Oracle SOA11g hands on tutorials<\/a>.<\/p>\n

                Overview<\/h2><\/span>\n

                * SDO<\/a> is a standard defined by Open SOA<\/a> consortium.
                \n* SDO is an abstraction layer for accessing heterogeneous data sources.
                \n* SDO supports both static (e.g. entity bean) and dynamic (e.g. JDBC) data APIs.
                \n* SDO supports disconnected programming models, i.e. disconnected data graphs. Data Access Service handles data access functions such as CRUD.
                \n* SDO is language neutral.
                \n* SOA 11g supports SDO via a new BPEL component called Entity Variables<\/strong>. Entity Variables relies on ADF-BC for data access service.<\/p>\n

                Prepare Database Table<\/h2><\/span>\n

                * Login soademo schema from SQL*Plus and execute the following SQL statements to create a new CUSTOMERS table.<\/p>\n

                \r\n \r\nCREATE TABLE  CUSTOMERS \r\n(\t\r\n\tCUSTOMER_ID VARCHAR2(10) NOT NULL PRIMARY KEY, \r\n\tCUSTOMER_NAME VARCHAR2(255) NOT NULL, \r\n\tLAST_ORDER_NUMBER VARCHAR2(4000), \r\n\tLAST_ORDER_AMOUNT NUMBER(10,2)\r\n);\r\n\r\nINSERT INTO CUSTOMERS VALUES ('1111', 'Test Customer', NULL, NULL);\r\n\r\nCOMMIT;\r\n<\/pre>\n
                Create ADF-BC Service<\/h2><\/span>\n
                Create an ADF-BC Application<\/h3><\/span>\n
                * Open JDev<\/strong>.
                \n* Click File -> New<\/strong> to open the New Gallery dialog.
                \n* Select General -> Applications -> Generic Application<\/strong>.
                \n* Click OK <\/strong>to open Create Generic Application dialog.
                \n– Name: CustomerSDOApp<\/strong>
                \n– Directory: C:\\po\\CustomerSDOApp<\/strong>
                \n– Package Prefix: customerapp<\/strong>
                \n* Click Next to go to the Name Your Project dialog.
                \n– Project Name: CustomerSDO<\/strong>
                \n– Directory: C:\\po\\CustomerSDOApp\\CustomerSDO<\/strong>
                \n– Project Technologies: ADF Business Components<\/strong>
                \n* Click Finish<\/strong>.
                \n* Save all.<\/p>\n
                Create Business Components<\/h3><\/span>\n
                * Right click CustomerSDO <\/strong>project and select New…<\/strong> to open the New Gallery dialog.
                \n* Select Business Tier -> ADF Business Components -> Business Components from Tables<\/strong> and click OK<\/strong>.
                \n* On Initialize Business Components Project<\/strong> dialog, click the green plus icon to open the Create Database Connection<\/strong> dialog.
                \n– Connection Name: soademo-jdev<\/strong>
                \n– Connection Type: Oracle(JDBC)<\/strong>
                \n– Username: soademo<\/strong>
                \n– Password: soademo<\/strong>
                \n– Host Name: localhost<\/strong>
                \n– SID: orcl<\/strong>
                \n* Click Test Connection<\/strong> button and make sure “Success!” message is returned.
                \n* Click OK<\/strong>.
                \n* Accept default SQL Flavor and Type Map (both Oracle) and click OK<\/strong>.<\/p>\n
                * On Entity Objects dialog,
                \n– Click Query <\/strong>button.
                \n– Move CUSTOMERS <\/strong>table from Available to Selected. Click Next<\/strong>.
                \n* On Updatable View Objects dialog,
                \n– Move CUSTOMERS <\/strong>table from Available to Selected. Click Next.
                \n* Click Next <\/strong>on Read-Only View Objects dialog.
                \n* On Application Module dialog, enter
                \n– Name: CustomerSDOAppModule<\/strong>
                \n– Click Next<\/strong>.
                \n* Click Finish<\/strong>.
                \n* Save all.<\/p>\n
                Testing Application Module<\/h3><\/span>\n
                * Right click CustomerSDOAppModule <\/strong>(CustomerSDO project -> Application Sources -> customerapp -> CustomerSDOAppModule) and select Run<\/strong>.
                \n* On Java application, double click CustomersView1<\/strong>.
                \n* Close Java application by clicking File -> Exit<\/strong>.<\/p>\n
                Create Service Interface<\/h3><\/span>\n
                * Double click CustomerSDOAppModule <\/strong>to open CustomerSDOAppModule.xml file.
                \n* Click Service Interface<\/strong> on the left pane.
                \n* Click green plus sign<\/strong> to open Create Service Interface<\/strong> dialog.
                \n* On Service Interface dialog:
                \n– Web Service Name: CustomerSDOService<\/strong>
                \n– Target Namespace: \/customerapp\/common\/<\/strong>
                \n* Click Next <\/strong>twice to go to Service View Instances.
                \n– Move CustomersView1 from Available to Selected.
                \n– Select CustomersView1 <\/strong>in the Selected list and then select all operations listed under Basic Operations tab (don’t forget to scroll down).
                \n* Click Finish<\/strong>.
                \n* Save all.<\/p>\n
                Deploy Application Module<\/h3><\/span>\n
                Configure Module<\/h4><\/span>\n
                * Double click CustomerSDOAppModule <\/strong>to open CustomerSDOAppModule.xml file.
                \n* Click Configurations<\/strong> on the left pane.
                \n* Select CustomerSDOService <\/strong>as the Default Configuration.
                \n* Double click CustomerSDOService<\/strong> to open Edit Business Components Configuration<\/strong> dialog and set:
                \n– Datasource Name: jdbc\/soademoDatabase<\/strong>
                \n* Click OK<\/strong>.
                \n* Save all.<\/p>\n
                Set Web App Name and Context Root<\/h4><\/span>\n
                * Right click CustomerSDO <\/strong>project and select Project Properties<\/strong>.
                \n* Select Java EE Application<\/strong> in the left side panel and set:
                \n– Java EE Web Application Name: CustomerSDO-webapp<\/strong>
                \n– Java EE Web Context Root: customer-app<\/strong>
                \n* Click OK<\/strong>.<\/p>\n
                Create Deployment Profile<\/h4><\/span>\n
                * Right click CustomerSDO project and select Project Properties<\/strong>.
                \n* Select Deployment<\/strong> in the left side panel.
                \n* Click New…<\/strong> to open Create Deployment Profile dialog.
                \n– Archive Type: Business Components Service Interface<\/strong>
                \n– Name: customerSDOProfile<\/strong>
                \n* Click OK <\/strong>to close Create Deployment Profile dialog.
                \n* Back on Project Properties dialog.
                \n* Expand customerSDOProfile<\/strong> and select MiddleTier<\/strong>.
                \n* Click Edit…<\/strong> to open Edit EJB JAR Deployment Profile Properties dialog and set:
                \n– EJB JAR File: C:\\po\\CustomerSDOApp\\CustomerSDO\\deploy\\customerSDO-app.jar<\/strong>
                \n– EAR File: C:\\po\\CustomerSDOApp\\CustomerSDO\\deploy\\customerSDO-app.ear<\/strong>
                \n– Enterprise Application Name: customerSDO<\/strong>
                \n* Click OK <\/strong>twice to close Project Properties dialog.
                \n* Save all.<\/p>\n
                Set Application Name<\/h4><\/span>\n
                * Select CustomerSDO<\/strong> project.
                \n* Select Application -> Application Properties…<\/strong> from JDev menu bar to open Application Properties dialog. Note: don’t select Project Properties…
                \n* Click Deployment<\/strong> on left side panel.
                \n* Select CustomerSDO_customerSDOProfile (EAR File)<\/strong> and click Edit…<\/strong> button.
                \n* Set:
                \n– Application Name: CustomerSDOApp<\/strong>
                \n* Click OK on both dialogs.
                \n* Save all.<\/p>\n
                Setup WebLogic Life Cycle Listener<\/h4><\/span>\n
                * In Application Resources<\/strong> pane, double click Descriptors -> META-INF -> weblogic-application.xml<\/strong> to open it.
                \n* Click Listeners<\/strong> on the left side pane.
                \n* Click green plus sign<\/strong> to add a new listener row.
                \n* Enter class name:<\/p>\n
                \r\noracle.jbo.client.svc.ADFApplicationLifecycleListener\r\n<\/pre>\n
                * Hit Enter <\/strong>key.
                \n* Save all.<\/p>\n
                Deploy<\/h4><\/span>\n
                * Select CustomerSDO<\/strong> project.
                \n* From JDev menu bar, select Application -> Deploy -> CustomerSDO_customerSDOProfle<\/strong> to open Deploy  CustomerSDO_customerSDOProfle dialog.
                \n* Select Deploy to Application Server<\/strong> and click Next.
                \n* Select MyAppServerConnection<\/strong> and click Next.
                \n* Select Deploy to selected instances in the domain and then select soa_server1<\/strong> and click Next<\/strong>.
                \n* Click Finish<\/strong>.<\/p>\n
                Test Customer SDO Service<\/h3><\/span>\n
                * Point browser to http:\/\/localhost:8001\/customer-app\/CustomerSDOService<\/a>
                \n* Or from EM, navigate to FARM_soa_domain -> Application Deployments -> CustomerSDOApp (soa_server1) and click Test icon in the Web Service pane.
                \n* Select Operation: getCustomersView1<\/strong>
                \n* Enter:
                \n– customerId: 1111<\/strong>
                \n* Click Invoke <\/strong>button on the bottom of the page.
                \n* Check that response contains:
                \n– CustomerName: Test Customer<\/strong><\/p>\n
                \r\n\r\n\r\n\r\n\r\n\t1111<\/ns0:CustomerId>\r\n\tTest Customer<\/ns0:CustomerName>\r\n\t\r\n\t\r\n\t<\/ns1:result>\r\n<\/ns0:getCustomersView1Response>\r\n<\/env:Body>\r\n<\/env:Envelope>\r\n<\/pre>\n
                Using ADF-BC Service in POProcessing Composite Application<\/h2><\/span>\n
                Add CustomerSDOService Reference<\/h3><\/span>\n
                * Drag and drop ADF-BC Service<\/strong> component onto External References lane. This opens Create ADF-BC Service<\/strong> dialog.
                \n* Enter:
                \n– Name: CustomerSDOService
                \n– Type: Reference
                \n– WSDL: http:\/\/localhost:8001\/customer-app\/CustomerSDOService?WSDL
                \n– PortType: CustomerSDOService
                \n– Registry: CustomerSDOApp_JBOServiceRegistry
                \nNote: the registry value should be AppName_JBOServiceRegistry<\/strong>. In this case, our application name is CustomerSDOApp<\/strong>. Therefore, the registry value is CustomerSDOApp_JBOServiceRegistry<\/strong>.
                \n* Click OK.<\/p>\n
                Wire approveLargeOrder BPEL Process to CustomerSDO Service<\/h3><\/span>\n
                * Drag a wire from lower right corner of approveLargeOrder BPEL Process to upper left corner of CustomerSDO reference.
                \n* Save all.<\/p>\n
                Use SDO in BPEL<\/h3><\/span>\n
                * Double click approveLargeOrder<\/strong> BPEL process.
                \n* Click Variable icon (x) on the main approveLargeOrder scope.
                \n* Click green plus sign<\/strong> to open Create Variable dialog. Enter:
                \n– Name: CustomerInfoEV<\/strong>
                \n– Type -> Element: {\/customerapp\/common\/}customersViewSDO<\/strong>.
                \nClick magnifying glass to open Type Chooser<\/strong> dialog. Select Type Explorer -> Project WSDL Files -> CustomerSDOServiceWrapper.wsdl -> Imported WSDL -> CustomerSDOService -> Inline Schemas -> Schema -> customersViewSDO<\/strong>.
                \n– Checked<\/strong>: Entity Variable
                \n– Partner Link: CustomerSDOService<\/strong>
                \n– SDO Capable: unchecked<\/strong>
                \n* Click OK <\/strong>twice to exit Create Variable dialog.<\/p>\n
                Bind Primary Key<\/h4><\/span>\n
                * Drag and drop a Bind Entity<\/strong> activity just after the receiveInput<\/strong> activity.
                \n* Double click to open Bind Entity<\/strong> dialog.
                \n– Name: BindCustomerId<\/strong>
                \n– Entity Variable: CustomerInfoEV<\/strong>
                \n* Click green plus sign to the right of Unique Keys to open Specify Key dialog.
                \n* Click (x)<\/strong> icon to the right of Key Local Part to open Browse Entity Variable<\/strong> dialog.
                \n* Select Variables -> Process -> Variables -> CustomerInfoEV -> customersViewSDO -> CustomerId
                \n* Click function icon to the right of Key Value to open Expression Builder.
                \n* Select inputVariable -> payload -> Order -> customerId and click OK.
                \n– Key Value: bpws:getVariableData(‘inputVariable’,’payload’,’\/ns2:Order\/ns2:customerId’)
                \n* Click OK again on Specify Key dialog.
                \n* Click OK on Bind Entity dialog.<\/p>\n
                Get Customer Name from Entity Variable<\/h4><\/span>\n
                * Drag and drop an Assign activity right below BindCustomerId activity. Rename it to AssignCustomerName<\/strong>.
                \n* Double click new Assign activity icon to open Edit Assign dialog.
                \n* Copy CustomerInfoEv -> customersViewSDO -> CustomerName<\/strong> to inputVariable -> payload -> OrderType -> customerId<\/strong>.
                \n* Click OK<\/p>\n
                Assign Last Order<\/h4><\/span>\n
                * Drag and drop an Assign activity under taskSwitch icon of ManualApproval1. Rename it AssignLastOrder<\/strong>.
                \n* Double click to open Edit Assign dialog.
                \n* Copy outputVariable -> payload -> Order -> OrderId<\/strong> to CustomerInfoEV -> CustomersViewSDO -> LastOrderNumber<\/strong>
                \n* Copy bpws:getVariableData(‘outputVariable’,’payload’,’\/ns2:Order\/ns2:price’) * bpws:getVariableData(‘outputVariable’,’payload’,’\/ns2:Order\/ns2:qty’) to CustomerInfoEV -> CustomersViewSDO -> LastOrderAmount<\/strong>.
                \n* Save all.<\/p>\n
                Test<\/h3><\/span>\n
                * Redeploy POProcessing.
                \n* Test input message with an order between 1000 and 5000:<\/p>\n
                \r\n\r\n    \r\n        \r\n            1111<\/ns1:CustID>\r\n            1212<\/ns1:ID>\r\n            HD TV<\/ns1:productName>\r\n            Electronics<\/ns1:itemType>\r\n            900<\/ns1:price>\r\n            10<\/ns1:quantity>\r\n            Initial<\/ns1:status>\r\n            Mastercard<\/ns1:ccType>\r\n            1234-1234-1234-1234<\/ns1:ccNumber>\r\n        <\/ns1:PurchaseOrder>\r\n    <\/soap:Body>\r\n<\/soap:Envelope>\r\n<\/pre>\n
                * Check that customerId<\/strong> field from the callbackClient <\/strong>component has been changed to Test Customer<\/strong> (not 111).
                \n* Login database as soademo <\/strong>and check that LAST_ORDER_NUMBER<\/strong> and LAST_ORDER_AMOUNT<\/strong> fields have been updated to reflect the new order input message.<\/p>\n
                \r\nCUSTOMER_I CUSTOMER_NAME        LAST_ORDER_NUMBER    LAST_ORDER_AMOUNT\r\n---------- -------------------- -------------------- -----------------\r\n1111       Test Customer        1212                              9000\r\n<\/pre>\n
                Issues<\/h2><\/span>\n
                Could not find registry for CustomerApp_JBOServiceRegistry<\/h3><\/span>\n
                Cause<\/h4><\/span>\n
                * Wrong registry value (CustomerApp_JBOServiceRegistry) was used for CustomerSDOService in the composite.
                \n* SDO application name is CustomerSDOApp, so the registry value should be CustomerSDOApp_JBOServiceRegistry<\/strong>.<\/p>\n
                Fix<\/h4><\/span>\n
                * Change CustomerSDOService component’s registry value:
                \nRegistry: CustomerSDOApp_JBOServiceRegistry<\/p>\n","protected":false},"excerpt":{"rendered":"
                This is part of the Oracle SOA11g hands on tutorials. Overview * SDO is a standard defined by Open SOA consortium. * SDO is an abstraction layer for accessing heterogeneous data sources. * SDO supports both static (e.g. entity bean) … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[100],"tags":[],"class_list":["post-2838","post","type-post","status-publish","format-standard","hentry","category-soa11g"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-JM","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2838","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2838"}],"version-history":[{"count":20,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2838\/revisions"}],"predecessor-version":[{"id":10637,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2838\/revisions\/10637"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2838"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}