JDBC adapter connection to the oracle

[Former Member]

Hey all,

How to check the JDBC adapter connection to the oracle

database??

I have been told there's some UDF for the JDBC adapter that can be used to check the same,is that correct?

Need solutions and suggestions on the same.

Regards,

Indu Khurana

[Former Member · Accepted solution]

HI,

Go through this block

File to JDBC /people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Http-JDBC /people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

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

validating FCC /people/swaroopa.vishwanath/blog/2005/06/24/generic-approach-for-validating-incoming-flat-file-in-sap-xi--part-1

DATE/TIME datatypes and Oracle Database /people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database

JDBC Receiver Adapter -- Synchronous Select /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

jdbc-lookup /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

Tips and Tutorial for Sender JDBC Adapter /people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

RDBMS system integration using XI 3.0 JDBC Sender/Receiver adapter /people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

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

XI: How-to on JDBC receiver response /people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

[Former Member]

Hi,

To check the connection its better to use the Lookups concept,create the JDBC adapter and give all parameters and in mapping create a UDF which have to go to oracle data base and its have to retrive tha data.

do this check this link for lookups in JDBC.

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

/people/prasad.illapani/blog/2006/10/25/how-to-check-jdbc-sql-query-syntax-and-verify-the-query-results-inside-a-user-defined-function-of-the-lookup-api

Regards

phani

Reward points if helpful

[Former Member]

Hi Indu Khurana !

You could create a simple scenario in XI, and set a JDBC sender or receiver adapter in communication channel with the proper settings to connect to your Oracle database.

An UDF (user defined function) is a function you can write in java inside the graphical mapping screen to add custom functionality. I think this has nothing to do with connection to oracle via jdbc.

Regards,

Matias.