Announcement Announcement Module
No announcement yet.
JdbcCursorItemReader with stored procedure call Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • JdbcCursorItemReader with stored procedure call

    Hi all,

    There are any implementation of a JdbcCursorItemReader class that accept ResultSets from stored procedures?

    If not, Which is the best approach to implement one? I'm thinking in copy the JdbcCursorItemReader class, change the PreparedStatement to a CallableStatement, and implement a new PreparedStatementSetter like functionality to map the input and output parameters. This CallableStatementSetter will be lot of different than the original one, because i will need to call it two times. First time to set and register the parameters, and second time to recover the output values (possibly i only support one cursor-resultSet as output).

    There is a better approach for this functionality?

    Thank you very much,