7 Replies Latest reply on Feb 24, 2017 6:49 PM by Cheng Fang

    Call stored procedure

    Sławomir Wojciechowski Newbie

      Hello,

       

      Is it possible to call stored procedure inside jdbcItemReader/jdbcItemWriter xml block using Jberet?

      I mean that examaple xml can look like bellow:

       

      <reader ref="jdbcItemReader">

           <properties>

                <property name="dataSourceLookup" value="java:/myDb" />

                     <property name="sql" value="{call myProc()}"/>                                                                                                                                                                                                                                       

                      <property name="beanType" value="java.util.List" />                                                                                                                                                                                                

                </properties>

      </reader>

       

      Best Regards

      sw