Call Procedure sql server via JDBC which returns cursor

Asked

Viewed 378 times

0

  • You can put your code snippet and the error returned?

  • Actually I haven’t found any examples in sql server, know of any ?

  • 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 ?

  • 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.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.