Results 1 to 2 of 2

Thread: Stored PRocedures / how to access resultsets

  1. #1
    Join Date
    Sep 2004
    Location
    London
    Posts
    311

    Default Stored PRocedures / how to access resultsets

    hi all,
    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
    Marco

  2. #2
    Join Date
    Sep 2006
    Location
    UK
    Posts
    8,424

    Default

    The reference manual has an example of this.
    http://www.springframework.org/docs/...toredProcedure

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •