Correct Way to Run Stored Procedure In MSSQL Via JDBC

Question

I am trying to run a Stored Procedure in MSSQL via jdbc. The way I see it I have two options:

Connection conn = //Code that I know gets the correct connection
Statement stmt = conn.prepareStatement(request.query);
ResultSet resultSet = stmt.executeQuery(request.query);

Using this the query runs fine but the code throws an exception: "Error: The statement did not return a result set."

Or

PreparedStatement stmt = conn.prepareStatement(request.query);
ResultSet resultSet = stmt.executeQuery();

Which does the same thing. Are these essentially doing the same thing under the hood? I know I could use stmt.executeUpdate() but I want to get a ResultSet back so I can do post processing.

Which way is correct? And what can I do to guarantee a ResultSet is returned?

I looked at this and this question and the answers were not effective/applicable.

Gord Thompson · Accepted Answer · 2015-10-12 15:35:10Z

1

To run a stored procedure you should use a CallableStatement. Note that you need to use the {call ...} syntax, something like this:

CallableStatement cs = conn.prepareCall("{call procedure_name}");
ResultSet rs = cs.executeQuery();

answered Oct 12, 2015 at 15:35

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

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

Collectives™ on Stack Overflow

Correct Way to Run Stored Procedure In MSSQL Via JDBC

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related