Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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
1
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..
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!