Multiple SQL statements from JDBC

[Former Member]

Dear All,

We are working on R/3- >XI->JDBC scenario. We have sender as Proxy which sends some data to XI which needs to be Updated in multiple database tables in oracle. We have few Insert,Update and Delete Query to be

[dharamveer_gaur2]

While creating reciever data type u have to make multiple statement.

in each statement you can perform a operation.

Use this link :http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

[Former Member]

Hi

yes this can be done by using the concept IDOC to JDBC

ALe settings for thi s are :

Steps for XI

Step 1)

Goto SM59.

Create new RFC destination of type 3(Abap connection).

Give a suitable name and description.

Give the Ip address of the R3 system.

Give the system number.

Give the gateway host name and gateway service (3300 + system number).

Go to the logon security tab.

Give the lang, client, username and password.

Test connection and remote logon.

Step 2)

Goto IDX1.

Create a new port.

Give the port name.

Give the client number for the R3 system.

Select the created Rfc Destination.

Step 3)

Goto IDX2

Create a new Meta data.

Give the Idoc type.

Select the created port.

Steps for R3.

Step 1)

Goto SM59.

Create new RFC destination of type 3(Abap connection).

Give a suitable name and description.

Give the Ip address of the XI system.

Give the system number.

Give the gateway host name and gateway service (3300 + system number).

Go to the logon security tab.

Give the lang, client, username and password.

Test connection and remote logon.

Step 2)

Goto WE21.

Create a port under transactional RFC.(R3->XI)

Designate the RFC destination created in prev step.

Step 3)

Goto SALE.

Basic settings->Logical Systems->Define logical system.

Create two logical systems(one for XI and the other for R3)

Basic settings->Logical Systems->Assign logical system.

Assign the R3 logical system to respective client.

Step 4)

Goto WE20.

Partner type LS.

Create two partner profile(one for XI the other for R3).

Give the outbound or inbound message type based on the direction.

Step 5)

Not mandatory.

Goto BD64.

Click on Create model view.

Add message type.

Step 6)

Goto WE19

Give the basic type and execute.

fill in the required fields.

Goto IDOC->edit control records.

Give the following values.(Receiver port,partner no.,part type and sender Partner no. and type)

Click outbound processing.

Step 7)

Go to SM58

if there are any messages then there is some error in execution.

Goto WE02.

Check the status of the IDOC.

Goto WE47.

TO decode the status code.

BD87 to check the status of IDOC.

In case if not authorized then go to the target system and check in SU53, see for the missing object

and assign it to the user.

for scenario reffer link

http://searchsap.techtarget.com/tip/0,289483,sid21_gci1246926,00.html

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm

hope this helps you

Regard's

Chetan Ahuja

[Former Member]

Dear All,

We are working on R/3- >XI->JDBC scenario. We have sender as Proxy which sends some data to XI which needs to be Updated in multiple database tables in oracle. We have few Insert,Update and Delete Query to be executed. How can it be done, Please help.

Regards,

Raghvendra

[Former Member]

hi,

u can use Javaproxy in the Inbound side and write u r code in Nwds and create .EAR file and deploy in u r Xi server.

to implement javaproxy to call Oracle database, plz follow the following Blogs... it will help u alot.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a068cf2f-0401-0010-2aa9-f5ae4b20...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f272165e-0401-0010-b4a1-e7eb8903...

Thanks,

Madhav

Note:Points If useful

[Former Member]

hi

check below link (for receiver jdbc adapter)

http://help.sap.com/saphelp_nw04/helpdata/en/e1/091640a991c742e10000000a1550b0/frameset.htm

this would help in all of your scenarios

rgds

srini