Skip to Content
avatar image
Former Member

How to get data from SQL server.?

Dear All

here is my problems.

please help me or give a suggestion.

.I used BPM try to get data from SQL server.

created:

1.DB request interface--for setting the "select * from table" SQL command

2.DB response interface--for receive the return dataSet.

the question is i can't receive the dataSet.

the DB response interface can't receive data.

but I sure that there are data in table.

and the BPM process was finished successfully.

i'm not sure what structure of DB response should be.

or there is any restriction ?

i was call a Z_RFC function from R3,and get return data successfully.found out that Z_RFC function.response has the same structure as the return XML value..i mean even the tag name are the same...is this problem?

Regards

Jack Lee

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jul 21, 2008 at 10:02 AM

    These links should give you all you need

    [JDBC Receiver Adapter -- Synchronous Select u2013 Step by Step|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3928] [original link is broken] [original link is broken] [original link is broken];

    [XI: How-to on JDBC receiver response|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2377] [original link is broken] [original link is broken] [original link is broken];

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2008 at 10:06 AM

    hi,

    check the below thread

    Unable to fetch the data from SQL server using JDBC adapter problem

    https://www.sdn.sap.com/irj/sdn/mss

    regards

    kummari

    Edited by: kummari on Jul 21, 2008 12:07 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2008 at 10:12 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 24, 2008 at 09:37 AM

    thanks for help...my problem is solved.

    my data type and message type were wrong.

    Add comment
    10|10000 characters needed characters exceeded