Get results from mssql stored procedure with jdbc

Question

I have quite complex stored procedure in MSSQL database that returns no value (just default integer code) and has select statement that produces single string ('OK' or error message).

I can see this result in Management Studio's Results tab executing procedure with exec my_procedure 'param1', 'param2'. However, when I try to execute this query with jdbc boolean resultExist = preparedStatement.execute(sqlString), I get my resultExist variable set to false and no result set is available.

Is there any way to obtain result produced by stored procedure without changing it?

have you tried debugging your code to see what result is returned after execution of stored procedure? — Abubakkar
– Abubakkar, Commented May 28, 2015 at 10:05
@AbubakkarRangara Yes, I have, and initial ResultSet is always null. — ngund
– ngund, Commented May 28, 2015 at 11:14

lance-java · Accepted Answer · 2015-05-28 10:07:09Z

1

Stored procedures can return multiple ResultSets. See here for sample code to access all ResultSets.

answered May 28, 2015 at 10:07

lance-java

29.4k6 gold badges73 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

lance-java Over a year ago

What's your sproc look like? Does it have output parameters? If so you might need to use CallableStatement.registerOutParameter(...)

ngund Over a year ago

no, it doesn't have any output parameters, just the statement select @MSG as [result], which is considered as a result tuple by MS Server, but not by JDBC.

lance-java Over a year ago

Can squlrrel sql see the resultset? If so, it can be accessed via jdbc.

Collectives™ on Stack Overflow

Get results from mssql stored procedure with jdbc

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related