hi
I am using JDK1.4,SQL Server 2000 and Microsoft's
JDBC driver.
I am stuck in accessing cursors.
The SP i wrote is
************************************************** ***
USE pubs
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'spSelectEmployees' and type = 'P')
DROP PROCEDURE spSelectEmployees
GO
CREATE PROCEDURE spSelectEmployees @emp_cursor CURSOR VARYING OUTPUT
AS
SET @emp_cursor = CURSOR
FORWARD_ONLY STATIC FOR
SELECT *
FROM employee
OPEN @emp_cursor
GO
************************************************** ******
The problem I face is that when i register the output param in
java code,what datatype do I specify..code is written below.
calStmt = conn.prepareCall("{CALL pubs.dbo.spSelectEmployees(?)}", ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
calStmt.registerOutParameter(1,Types.???);-->What goes here???
java.sql.Types does not give any datatype for cursor or object.Any one knows if there is an extended type given by Microsoft Driver??
thanks in advance.
Prashant
prashantjainn@yahoo.com