Saturday, December 4, 2010

Using Database Adapter in BPEL Process in Oracle SOA Suite 11g

Hi,

DB Adapter allows you to read database into SOA composite application from any relational database. before using the service with DB Adapter make sure you have created a JDBC data-source and Connection Factory under  DBAdapter application.

Download the sample code





Have a nice day,
Zeeshan Baig
Posted by Zee at 12:14:00 PM
Labels: , , , , , , , ,

5 comments:

  1. ccApril 3, 2012 at 2:04 AM

    how to use dehydration in db abapter?

    ReplyDelete
  2. Muhammad NasirJanuary 1, 2013 at 6:33 AM

    Really nice tutorial,,,,,,

    I am getting the following error while testing my application from Em console
    "
    The selected operation process could not be invoked.
    An exception occured while invoking the webservice operation. Please see logs for more details.



    java.lang.Exception: oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: Client received SOAP Fault from server : Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'EMPRecordSelect' failed due to: Could not create/access the TopLink Session. This session is used to connect to the datastore. Caused by javax.resource.spi.InvalidPropertyException: Missing Property Exception. Missing Property: [ConnectionFactory> xADataSourceName or dataSourceName]. You may have set a ..........
    "

    ReplyDelete
    Replies
    1. ZeeJanuary 4, 2013 at 10:53 AM

      Hi,

      Sorry for late response ... Make sure you have provided proper JNDI name in connection factory...send me detail log message.


      Zee

      Delete
  3. TestAugust 5, 2014 at 8:56 AM

    Hi Zeeshan,

    Thanks for sharing. It helped me to create a BPEL process with DB adapter.

    I am getting the following error message after I enter the input and clicked on the test web services

    Error Message:
    java.lang.Exception: oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: Client received SOAP Fault from server : Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'DBServiceSelect' failed due to: DBReadInteractionSpec Execute Failed Exception. Query name: [DBServiceSelect], Descriptor name: [DBService.Employee]. Caused by java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges . See root exception for the specific exception. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-1031" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.

    Thanks,
    Harisudhan Selvaraj

    ReplyDelete
    Replies
    1. ZeeAugust 5, 2014 at 9:36 AM

      Hi,

      It looks like you don't have privilges on the table you are accessing. Try to run the SQL query with same user you defined in your connections on SQL developer.

      The Key error is ORA-01031: insufficient privileges

      Zeeshan

      Delete

Subscribe to: Post Comments (Atom)