IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

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

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

    Posted Fri February 16, 2024 12:55 AM

    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.


    #webMethods
    #Service-Designer
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


Related Content