2 Replies Latest reply: Mar 9, 2013 2:21 PM by 991448 RSS

    File and DB Adapter

    978940
      Hi,

      Please answer to the following questions

      What is the another way to interact with DB without using the db adapter in bpel 11g?

      and also with out using file adapter how to read files from file system?

      Thanks in adv,
      kpr
        • 1. Re: File and DB Adapter
          Arik
          Hi,

          What is the another way to interact with DB without using the db adapter in bpel 11g?
          You can use Xpath functions(assign activity, xsl ...): http://docs.oracle.com/cd/E23943_01/dev.1111/e10224/bp_appx_functs.htm#BEIGJJHD
          You can use AQ adapter: http://docs.oracle.com/cd/E21764_01/integration.1111/e10231/adptr_aq.htm#BGBICGIE
          and also with out using file adapter how to read files from file system?
          You can also use Xpath functions like ora:readFile: http://docs.oracle.com/cd/E23943_01/dev.1111/e10224/bp_appx_functs.htm#SOASE2159


          Arik
          • 2. Re: File and DB Adapter
            991448
            For interacting with Database you can use oraext:lookup-table, oraext:query-database,oraext:sequence-next-val.
            For reading from file readBinaryFromFile(fileName),oraext:get-content-from-file-function(fileName, nxsdTemplate?, nxsdRoot?) functions .