Skip to Content
avatar image
Former Member

Why JDBC adapter issues dummy select statement before issuing the reall one

we have a scenario with JDBC receiver adapter to retrieve data based on criteria. Things are working properly, but we noticed the bad performance. After analyzing we found there are two SQL select statements sent to the database for every interface call, the first one is like select * from myTbale where 1<0; and the second one is the one we really want and we configured in PI (7.1 SP8). The first one is basically scanning hte table which causes performance issue, the second real one is actually very fast. So I jsut wondering how the first dummy statement with where clause of 1<0 gets sent to the database? Is it the JDBC adapter sends the dummy one to DB before sending the real one? This sounds silly to me, if now, how come everytime we run the interface, the dummy statement is sent before the real one?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 09, 2009 at 06:43 PM

    Hey

    Please look at SAP Note 870334

    Thanks

    Aamir

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Actually I just found the note which applies to XI3.0, while we are on PI7.1 SP8. I guess SAP forgot to put the fix in PI7.1.