Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Former Member
Not what you were looking for? View more on this topic or Ask a question