Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to return a table from MS SQL servers Stored Procd. to Java

Sagar Rohankar
Ranch Hand
Posts: 2907
Java Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all,
Im new to JDBC and stored procedure
here is my problem : I want to return a table OR a select statement result ( which is table, as per my knowledge ) from MS SQL server`s Stored Procedure to my java app.

The select statement takes the result from other parameter which i passed to it at run time.. I used prepareStatement(? = call myProc( ? , ?)) , but what shud i take in first ? , so that i can iterate over it ( like a ResultSet ) and gets the values. It ll be very helpful if clear this with example ..

thankx in advance..
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic