Skip to Content
avatar image
Former Member

MSSQL Cursor issue

Hi Guys,

we are using JDBC driver to send data from SAP PI 7.1 to MS SQL 2012.
The data is passed as an XML file, as below

<ns0:MTORDER xmlns:ns0="http://order">

  <LOADING_UPDATE>

  <sp_order action="EXECUTE">

  <table>SP_ORDER</table>

  <i_status_load type="VARCHAR">1</i_status_load>

<ordercursor isOutput="TRUE" type="CURSOR"></ordercursor>

  <item isOutput="TRUE" type="CURSOR"></item>

  </sp_biz_order_loading_update>

  </LOADING_UPDATE>

</ns0:MTORDER>

We got following message;

java.sql.SQLException: Unsupported parameter type 'CURSOR' for parameter 'ordercursor' found

I believe that MS JDBC driver should support this.


Is this possible?


PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 13, 2015 at 01:10 PM

    CURSOR (output; only in conjunction with the Oracle JDBC driver)


    .

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2015 at 01:26 PM

    Hi Peterm

    According with MSSQL documentation: http://docs.oracle.com/cd/E13157_01/wlevs/docs30/jdbc_drivers/mssqlserver.html the point about  SelectMethod and the note 831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 / PI 7.3 JDBC Adapter point 15 your can try to add the SelectMethod clausule in the connection URL like:

    jdbc:microsoft:sqlserver://dbhost:1433;databaseName=example;SelectMethod=Cursor

    Regards.

    Add comment
    10|10000 characters needed characters exceeded