Requirements forJDBC

[Former Member]

Hi friends,

Could you please tell me the details required for doing a JDBC scenario.

I want the details seperately when JDBC is a sender and also when JDBC is a receiver.

Note: High reward points for the reply

[Former Member]

Hi Murugavel,

For any JDBC scenario be it sender or receiver ,first get to knw the Db thereby the driver...

also get to knw te connection parameters as it differs for different DB...

In Sender JDBC comm channel u will have two fields where u will put the SQL queries..as in select * from table name ....

and and update statement..if ur just testing the scenario put <Test> in the update field that way the content will be unaltered and u will get the result as well....

For a receiver JDBC where u need to be cautious is the structure...

u should have ROW in caps and also proper attributes defining the actions for the DB..

here is an extremely good blog by Bhavesh

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

..do check it follow the same and u will get the result...

Jut remember to put the name of the message type in the comm channel...

Hope it help u

[Former Member]

Hi,

Check out these forums

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

Thanks

Vikranth

[Former Member]

HI

Database (JDBC) Adapter

The JDBC Adapter allows access to any DB that allows a JDBC driver to access the DB. This driver is not supplied with the adapter but must come from the DB provider or a 3rd party. The adapter converts database content to XML and vice versa.

Database content can be read with any SQL statement using a special XML format. This format enables SQL INSERT, UPDATE, SELECT, DELETE or even stored procedures. A message is always processed in one database transaction

For mode details on jdbc adapter refer the following link .

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

for more ref: http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

U can Start your hands on with:

FILE to JDBC Adapter using SAP XI 3.0-

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

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

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

http://help.sap.com/saphelp_nw04/helpdata/en/80/4f34c587f05048adee640f4c346417/frameset.htm

U will find all the details including how to configure sender JDBC adapter + receiver JDBC adapter:

http://help.sap.com/saphelp_nw04/helpdata/en/e2/cb610b230c9c4cb4b800989196b63a/frameset.htm

cheers

[aashish_sinha]

Hi,

The JDBC adapter enables you to connect database systems to the Integration Server or the PCK. The adapter converts database content to XML messages and the other way around.

Database content can be read with any SQL statement. A special XML format is defined for content coming from the Integration Server or the PCK. This format enables SQL INSERT, UPDATE, SELECT, DELETE, or stored procedure statements to be processed. A message is always processed in exactly one database transaction

Configuring the Sender JDBC Adapter

You need to configure the sender JDBC adapter to be able to send content from databases to the Integration Server or to the PCK.

Please refer

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Configuring the Receiver JDBC Adapter

You need to configure the receiver JDBC adapter to convert XML messages from the Integration Server or the PCK into database table content.

PLease refer

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Regards

Aashish Sinha

[GabrielSagaya]

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

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]

in case you want to connect to any database system, the JDBC adapter is used.When you want to read or insert/update data into database you should use the jdbc adapter . Also when you want to do the lookup into data base table from UDF( user defined function) you should use jdbc adapter .

For mode details on jdbc adapter refer the following link .

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

for more ref: http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

When you want to read or insert/update data into database you should use the jdbc adapter . Also when you want to do the lookup into data base table from UDF( user defined function) you should use jdbc adapter .

For mode details on jdbc adapter refer the following link .

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

.

We use this adapter to connect database systems using the JDBC driver. We need to deploy JDBC driver Deploy JDBC Driver using the link

http://help.sap.com/saphelp_nw04/helpdata/en/80/4f34c587f05048adee640f4c346417/frameset.htm

U will find all the details including how to configure sender JDBC adapter + receiver JDBC adapter:

http://help.sap.com/saphelp_nw04/helpdata/en/e2/cb610b230c9c4cb4b800989196b63a/frameset.htm

U can Start your hands on with:

FILE to JDBC Adapter using SAP XI 3.0-

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

thanks,

Vijaya