1 Reply Latest reply: Feb 16, 2010 4:49 PM by 428263 RSS

    how to invoke DB2/400 database using oracle jac adapters(database)

    750891
      hi,

      There is a event which occurs in the DB2/400 database and needs to be captured in oracle bpel through adapters.Firstly I would like to know if Oracle jca adapter support this database and if yes then what library files are required both at the app server level(OAS 10g) and Jdev level to connect the DB.

      If there any documents that had captured this configuration please let me know.

      Thanks

      Prabal
        • 1. Re: how to invoke DB2/400 database using oracle jac adapters(database)
          428263
          The JCA database adapter (TopLink) supports AS/400 so you can perform operations on tables and views. Stored procedure support was added to the database adapter in AS11g R1.

          JDBC driver and connection information can be found here: http://download.oracle.com/docs/cd/E15523_01/integration.1111/e10231/adptr_db.htm#CHDBEJDC
          Stored procedure information can be found here: http://download.oracle.com/docs/cd/E15523_01/integration.1111/e10231/adptr_db.htm#BDCEAFHF