Unable to get CURSOR data type in JDBC adapter for SQLServerDataSource SP

, , ,
1

Hi All,
I am trying to create a JDBC adapter with StoredProcedureWithSignature, which has the below connection properties:

|Transaction Type|NO_TRANSACTION|
|DataSource Class|com.microsoft.sqlserver.jdbc.SQLServerDataSource|

The cursor parameters are getting loaded as INT as sql data type and JDBC data type instead of CURSOR:

image
image1517×518 23.8 KB

Also, it is expecting the cursor as an input too. In Stored procedure, the data type of the cursors is given as CURSOR VARYING OUTPUTS.

How can i get cursor data type in my adapter and also as only output param. Can anyone please help on this?

wM version: 10.11
JDBC version: 10.3
JDBC fix: Fix 10

Thanks in advance.

2

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.