Jun 9th, 2009, 03:31 AM
JdbcCursorItemReader with stored procedure call
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,