Jun 4th, 2007, 03:49 PM
Stored PRocedures / how to access resultsets
i am trying to call stored procedures using Spring,
I am following docs so i created a class that extends SToredProcedures
my stored procedure returns a resultSet, so i thought that i fi call my SP, the Map returned by execute() method will give me the returned resultset, but in fact the map returned is empty.
i don't have code with me now, but i was wondering why it was not working, as i have called successfully a SP via spring (this time though the SP didnt return anything so it was successful)
my questions are:
1) the Map returned by execute method of SP class will re present the different rows of a resultSet?
2) in order to return a resultSet, do ihave to declare a SqlOutParameter?
anyone could give me some suggestions?
thanks in advance and regards
Jun 5th, 2007, 07:09 AM