Calling SQL Server Stored procedure returning resultset using Java
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.
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().