0
I am unable to call a Procedure SQL Server in java that returns a cursor.
That’s possible, someone has some example ?
Through Oracle, through the example: http://www.mkyong.com/jdbc/jdbc-callablestatement-stored-procedure-cursor-example/. But I need it in Sql Server.
You can put your code snippet and the error returned?
– Math
Actually I haven’t found any examples in sql server, know of any ?
– Pedro A.
I think it’s basically changing the DB_DRIVER from the example to
com.microsoft.jdbc.sqlserver.SQLServerDriver. Have you seen this example here iMasters - Connecting Java to SQL Server ?– Math
I managed to call Procedure by passing the parameters the problem is when I use a cursor in the Procedure Store output, by in oracle declaring: callableStatement.registerOutParameter(2, Oracletypes.CURSOR); and in sql server I do not know how to do.
– Pedro A.