{"id":2062,"date":"2011-05-12T23:18:03","date_gmt":"2011-05-13T04:18:03","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=2062"},"modified":"2015-04-17T13:57:43","modified_gmt":"2015-04-17T18:57:43","slug":"soa-11g-tutorial-credit-verification-app","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=2062","title":{"rendered":"SOA 11g Tutorial: Credit Verification App"},"content":{"rendered":"
\n

Contents<\/h2>\n
    \n\t
  1. \n\t\tCreate a New SOA Application<\/a>\n\t<\/li>\n\t
  2. \n\t\tAdd DBAdapter<\/a>\n\t<\/li>\n\t
  3. \n\t\tAdd Mediator Component<\/a>\n\t<\/li>\n\t
  4. \n\t\tAdd Outbound Web Service<\/a>\n\t\t
      \n\t\t\t
    1. \n\t\t\t\tCreate WSDL<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
    2. \n\t\tWire Web Service, Mediator and DBAdapter<\/a>\n\t<\/li>\n\t
    3. \n\t\tAdd Transformation Steps<\/a>\n\t\t
        \n\t\t\t
      1. \n\t\t\t\tInput Mapper<\/a>\n\t\t\t<\/li>\n\t\t\t
      2. \n\t\t\t\tReply Mapper<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
      3. \n\t\tCreate a Server Connection<\/a>\n\t<\/li>\n\t
      4. \n\t\tDeploy<\/a>\n\t<\/li>\n\t
      5. \n\t\tTesting<\/a>\n\t<\/li>\n<\/ol>\n<\/ol>\n<\/ol>\n<\/div>\n
         <\/div>\n

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

        Create a New SOA Application<\/h3><\/span>\n

        * File -> New -> General -> Applications -> SOA Application
        \n* On Create SOA Application wizard Step 1, enter
        \nApplication Name: CreditCardValidation
        \nDirectory: C:\\po\\CreditCardValidation
        \nApplicatoin Package Prefix: blank
        \n* On Step 2, enter
        \nProject Name: validationForCC
        \nDirectory: C:\\po\\CreditCardValidation\\validationForCC
        \n* On Step 3, select
        \nEmpty Composite
        \n* Click Finish<\/p>\n

        Add DBAdapter<\/h3><\/span>\n

        * Drag and drop Database Adapter from Component Palette to External References lane
        \n* On Adapter Configuration Wizard, Step 2 of 4, enter:
        \nService Name: getCreditValidation
        \n* On Step 3,
        \n– Click green plus icon, enter
        \nConnection Name: soademoDatabase
        \nConnection Type: Oracle(JDBC)
        \nUsername: soademo
        \nPassword: soademo
        \nSave Password: checked
        \nDriver: thin
        \nHost Name: localhost
        \nService Name: orcl.world
        \nJDBC Port: 1521
        \n– Click Test Connection, should see success! under the button
        \n– Click OK
        \n* Still on Step 3, verify
        \nJNDI Name: eis\/DB\/soademoDatabase
        \nand click Next
        \n* On Step 4, select
        \nPerform an Operation on a Table -> Select
        \n* On Step 5, click Import Tables… and then
        \n– Click Query
        \n– Move CREDITCARDINFO from left to right
        \n– Click OK
        \n* On Step 6, select CCNUMBER as primary key
        \n* On Step 7, click Next
        \n* On Step 8,
        \nun-check all columns except status
        \n* On Step 9,
        \n– click Add button and enter a new parameter named ccnb, click OK
        \n– click Edit button, click Add… button, and select
        \nFirst Argument\/Query Key: ccnumber
        \nOperator: EQUAL
        \nSecond Argument: Parameter -> ccnb
        \n– click OK
        \n* Click Finish<\/p>\n

        Add Mediator Component<\/h3><\/span>\n

        * Drag and drop a Mediator from Palette to Components lane, enter
        \nName: RouteRequest
        \nTemplate: Define Interface Later
        \n* Click OK<\/p>\n

        Add Outbound Web Service<\/h3><\/span>\n

        * Drag and drop Web Service from Component Palette to Exposed Services lane
        \n* On Create Web Service screen, enter
        \nName: getStatusByCC
        \nType: Service
        \n* Click Create WSDL from schema icon (second one to the right of WSDL URL field)<\/p>\n

        Create WSDL<\/h4><\/span>\n

        * On Create WSDL screen, accept
        \nFile Name: getStatusByCC.wsdl
        \nDirectory: C:\\po\\CreditCardValidation\\validationForCC
        \nNamespace: http:\/\/oracle.com\/sca\/soapservice\/CreditCardValidation\/validationForCC\/getStatusByCC
        \nPort Type: execute_ptt
        \nOperation: execute
        \nInterface Type: Synchronous Interface<\/strong><\/p>\n

        Define Input<\/strong>
        \n* click the green plus icon above the Input panel
        \n* On Add Message Part screen, click the browse for schema icon (magnifying glass)
        \n* On Type Choose screen, click the Import Schema File icon (first icon on upper right)
        \n* On Import Schema File screen, enter
        \nCheck: Copy to Project
        \nURL: file:\/C:\/po\/schemas\/creditcheck.xsd (or click the magnifying glass and browse to creditcheck.xsd file)
        \n– click OK
        \n* On Localize Files screen,
        \n– uncheck <\/strong>maintain original directory structure…
        \n– click OK
        \n* Back on Type Choose screen,
        \n– select creditcardStatusRequest
        \n– click OK
        \n* Back on Add Message Part screen, enter
        \nPart Name: creditcardStatusRequestPart<\/strong>
        \nURL: xsd\/creditcheck.xsd
        \nSchema Element: creditcardStatusRequest
        \n– click OK<\/p>\n

        Define Output<\/strong>
        \n* click the green plus icon above the Output panel
        \n* On Add Message Part screen, click the browse for schema icon (magnifying glass)
        \n* On Type Choose screen,
        \n– expand creditcheck.xsd
        \n– select creditcardStatus
        \n– click OK
        \n* Back on Add Message Part screen, enter
        \nPart Name: creditcardStatusPart<\/strong>
        \nURL: xsd\/creditcheck.xsd
        \nSchema Element: creditcardStatus
        \n– click OK<\/p>\n

        Define Fault<\/strong>
        \n* click the green plus icon above the Fault panel
        \n* On Add Message Part screen, click the browse for schema icon (magnifying glass)
        \n* On Type Choose screen,
        \n– expand creditcheck.xsd
        \n– select error
        \n– click OK
        \n* Back on Add Message Part screen, enter
        \nPart Name: errorPart<\/strong>
        \nURL: xsd\/creditcheck.xsd
        \nSchema Element: error
        \n– click OK<\/p>\n

        Finish Create WSDL<\/strong>
        \n* Click OK on Create WSDL screen
        \n* On Create Web Service screen, verify
        \n– copy wsdl and its dependent artifacts into the project: unchecked<\/strong>
        \n– Transaction Participation: NEVER
        \n* Click OK<\/p>\n

        Wire Web Service, Mediator and DBAdapter<\/h3><\/span>\n

        * Drag right arrow on upper right of getStatusByCC web service and drop on lower left of RouteRequest.
        \n* Drag right arrow on lower right of RouteRequest and drop on right arrow on upper left of getCreditValidation.<\/p>\n

        Add Transformation Steps<\/h3><\/span>\n

        * Double click RouteRequest<\/p>\n

        Input Mapper<\/h4><\/span>\n

        * Click on the first transformation icon (to the right of the first “Transform Using” field)
        \n* Select Create New Mapper File and click OK
        \n* On the new mapper file,
        \n– drag from left side inp1:CCNumber to right side top:ccnb
        \n* Save and close mapper file<\/p>\n

        Reply Mapper<\/h4><\/span>\n

        * Click on the transformation icon to the right of the second Transform Using field
        \n* Select Create New Mapper File and click OK
        \n* On the new mapper file,
        \n– drag from left side top:status to right side inp1:creditcardStatus
        \n* Save and close mapper file<\/p>\n

        * Save and close RouteRequest.mplan file<\/p>\n

        Create a Server Connection<\/h3><\/span>\n

        * Click File -> New… -> General -> Connections -> Application Server Connection
        \n* Click OK on New Gallery screen
        \n* On Create Application Server Connection Step 1 screen, enter
        \nConnection Name: MyAppServerConnection
        \nConnection Type: WebLogic 10.3
        \n* Step 2, enter
        \nUsername: weblogic
        \nPassword: welcome1
        \n* Step 3, enter
        \nWeblogic Hostname: localhost
        \nPort: 7001
        \nWeblogic Domain: soa_domain
        \n* Step 4, click Test Connection<\/p>\n

        \r\nTesting JSR-160 Runtime                ... success.\r\nTesting JSR-160 DomainRuntime          ... success.\r\nTesting JSR-88                         ... success.\r\nTesting JSR-88-LOCAL                   ... success.\r\nTesting JNDI                           ... success.\r\nTesting JSR-160 Edit                   ... success.\r\nTesting HTTP                           ... success.\r\nTesting Server MBeans Model            ... success.\r\nTesting HTTP Authentication            ... success.\r\n\r\n9 of 9 tests successful.\r\n<\/pre>\n
        * Step 5, click Finish<\/p>\n
        Deploy<\/h3><\/span>\n
        * Right click validationForCC project
        \n* Select Deploy -> validationForCC
        \n* On Deploy validationForCC screen,
        \n– select Deploy to Application Server
        \n* On Deploy Configuration screen,
        \n– check Overwrite any existing composites with the same revision ID<\/strong> if reploying
        \n– click Next
        \n* One Select Server screen,
        \n– select MyAppServerConnection
        \n– click Next
        \n* Click Finish on Summary screen<\/p>\n
        Testing<\/h3><\/span>\n
        * Login Enterprise Console http:\/\/localhost:7001\/em
        \n* Click Farm_soa_domain -> SOA -> soa-infra (soa_server1) -> default -> validationForCC
        \n* Click Test tab
        \n* Under Input Arguments, enter
        \nCCNumber: 1234-1234-1234-1234
        \n* Click Test Web Service button
        \n* Should return VALID
        \n* Enter
        \nCCNumber: 4321-4321-4321-4321
        \nshould return INVALID<\/p>\n","protected":false},"excerpt":{"rendered":"
        This is part of the Oracle SOA11g hands on tutorials. Create a New SOA Application * File -> New -> General -> Applications -> SOA Application * On Create SOA Application wizard Step 1, enter Application Name: CreditCardValidation Directory: C:\\po\\CreditCardValidation … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","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-2062","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-xg","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2062","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=2062"}],"version-history":[{"count":10,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2062\/revisions"}],"predecessor-version":[{"id":10661,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2062\/revisions\/10661"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}