SQL Procedures and ResultSets

[FernandoSilva]

Hello!

I have a store procedure that works fine in MS SQL Query Analyser (returning results)... but when I try to run it on my java aplication I get:

"[Merant][SQLServer JDBC Driver]No Resultset set was produced"

I have tried CallableStatments and normal Statements, both with the same result.

I would like any help.

Thanks in advance.

Regards,
Fernando Silva

 

[meadandale]

Some code would help as would the prepared statement. Also, it's possible that your JDBC driver doesn't support CallableStatements correctly. I'd check with the vendor.

FWIW, you need to use a CallableStatement to invoke stored procedures.