Complete knowledge on jdbc adaptor in PI7.1

[Former Member]

Hi all,

I would like to have the complete knowledge on JDBC adaptor.

Please provide me with links (of previous forumns if any) or blogs...

what are the capabilities of using JDBC adaptor and also limitations....

Cheers,

karthick

[Former Member · Accepted solution]

Karthick ,

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1725 [original link is broken] [original link is broken] [original link is broken]

Regards ,

[Former Member]

I would say to get better understanding on this, go through help.sap.com, there you will come to know may other featers which you may not find in any particular blog..

http://help.sap.com/saphelp_nwpi711/helpdata/en/44/747eda12dd3676e10000000a114a6b/frameset.htm

[rajasekhar_reddy14]

Hi,

The only way to become expert in JDBC adapter is first reading help documentation clearly,try to understand the usage and how to deploy the drivers and how execute the queries.do some diferent scenarios and execute some stored procedure scenarios too.

refer below link for sap pi7.1 jdbc adapter doc

http://help.sap.com/saphelp_nwpi71/helpdata/EN/22/b4d13b633f7748b4d34f3191529946/frameset.htm

there is no specific limitations as per my experiece,some times when we updating huge amount of data in to data base,i faces some problems,we resolved following some best development standards like using good sql queries.

Regards,

raj

[sunilchandra007]

Hi karthick,

Go through these links -

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Regards,

Sunil Chandra