Results 1 to 2 of 2
  1. #1
    santtarius is offline Member
    Join Date
    Jun 2012
    Posts
    1
    Rep Power
    0

    Default Calling SQL Server Stored procedure returning resultset using Java

    Hi All,

    We have a stored procedure which has IN parameters and the output is Resultset ( from select query inside procedure ) .There is no OUT parameter defined. Can you please post java code snippet how to call this and map the resultset to Java object.

    Regards
    Shaan

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: Calling SQL Server Stored procedure returning resultset using Java

    The execute() call returns a ResultSet.
    That ResultSet is the one returned by your SQL Server procedure.

    ETA: Sorry, that should be executeQuery().
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. java call stored procedure
    By namalsera in forum JDBC
    Replies: 1
    Last Post: 01-04-2011, 04:53 PM
  2. Replies: 3
    Last Post: 10-14-2009, 10:32 AM
  3. How to call Oracle stored procedure from Java?
    By parag_narkhede in forum New To Java
    Replies: 4
    Last Post: 10-07-2009, 08:50 AM
  4. Replies: 2
    Last Post: 01-30-2009, 01:53 PM
  5. Calling SQL Server stored procedures
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 01-07-2008, 09:40 AM

Posting Permissions

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