need an real time scenario on JDBC adapter

[Former Member]

Can any one explain me where u usr the jdbc adapter?

[prabhu_s2]

u use a jdbc adatper when u want to do a select query into a table. one real time interface would be connecting some as400 apllication with proxy/file/or any target systems. here u would query into the as400 application DB and map the data to target strucutre.

[Former Member]

Hi Venu,

If you want to SELECT something from your Database, then you will have to go for a JDBC sender adapter.

And if you want to insert/update your Database, then you can go in for a JDBC receiver adapter.

Multiple insertions are possible for a JDBC receiver, but multiple Selection queries (different select queries) are not possible for a single JDBC sender adapter.

Just go through my reply in the below thread from which you will get a better idea of the same....

Regards,

Abhy

[Former Member]

iam bit confused......... sync rfc 2 jdbc ,this scenario is used to update the database .But we can update the database directly from SAP .......then y we were using XI here?

[bhavesh_kantilal]

Are you planning to update a Standalone Database from your SAP system using your RFC?

You might update the R3 tables from the RFC but it is not recommended that you directly update another Database table from your R3 system.

Maybe you can do this, but this would mean a point to point connection, but look at the bigger picture of XI replacing a point to point connectivity with a Hub and Spoke Model.

Regards

Bhavesh