Wednesday, June 28, 2017

Executing sqls for AS400 objects with WSO2 ESB

1. Download and add jt400.jar to ESB_HOME/repository/components/lib.
2. Then you could create the connection pool as below and execute your query with dblookup mediator.


         <dblookup>
            <connection>
               <pool>
                  <password>123456</password>
                  <driver>com.ibm.as400.access.AS400JDBCDriver</driver>
                  <url>jdbc:as400://{IP}/{DB_NAME}</url>
                  <user>userA</user>
               </pool>
            </connection>
            <statement>
               <sql>select id from exp1000 where clId ='A1000000'</sql>
               <result name="custID" column="id"/>
            </statement>
         </dblookup>

No comments:

Post a Comment