Skip to Content
avatar image
Former Member

FILE->WEBSERVICE->JDBC Sceanrio

Hi All,

have file to webserivce sceanario

i am using this Webserice to insert the records into the oracle databse.(not using the JDBC recievr adapter because of some size limitations)..so i can only use websrivce for this to insert

Now the table has five columns field1 field2 field 3 input_xml and output xml

and webservice will insert the records into field 1 field 2 field 3 and input xml and output xml will be blank

Now i need invoke the javastored procedure by passing the value from field 1 from the record inserted along with some other parametes

this perticular java stored procedure will create output_xml in the output xml column and will be placed against the same record that was inserted from the webservice.

finally need to send this output xml back to the file systems.(sender)

currently i ahve configured the indivisual sceanrios one for webserivce and other for the invoking the stored procedure

i need to make club into a single sceanrio(FILE->WEBSERICE->INVOKE JAVA STORED PROCEDURE-SEND OUTPUT XML TO SENDER FIEL SYSTEM) where in after the webserivce has inserte the record successfully,need to invoke the java stored procedure and send the output XML back to the sender(file system)

is this possible w/o using BPM.?

if i have to use BPM..what will be steps in the integration processa nd the the ID.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 16, 2010 at 07:14 AM

    > is this possible w/o using BPM.?

    No, this is not possible without BPM.

    > if i have to use BPM..what will be steps in the integration processa nd the the ID.

    search for related weblogs

    Add comment
    10|10000 characters needed characters exceeded