about JDBC Adpter

[Former Member]

Hi Expert:

i do a scenario of sqlserver->XI->oracle, beacase the message is too big to pull the data once,so at the sender adapter , i use the sql statement:SELECT TOP 1 percent id,one,two,three,five,six,seven,eight,nine,ten From test where processed=0 ,

at the sqlserver side(sender),the table has a clumn "processed" ,it's marked the row data had been pulled.

my problem is that how can i update the processed clumn which had been send the row data to the oracle

additional: the "sql server" data items is huge ( 5000000 items), so i can't pull the data to the oracle once.Otherwise pi server will be crashed.

best regard

[Former Member]

i had solved

[Former Member]

Hi,

Refer these links:

https://www.sdn.sap.com/irj/scn/wiki?path=/display/xi/jdbc%252bto%252bjdbc

Sender Jdbc adapter

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

Receiver JDBC adapter:

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

Regards,

Nithiyanandam

[Shabarish_Nair]

you have the option of a Query SQL Statement and Update SQL Statement in the sender JDBC.

So for your case after the select query give your next statement in the Update SQL Statement.

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

[former_member732072]

Hi Kevin,

Please have a look at the following links and see if it helps you resolve the problem

and

https://www.sdn.sap.com/irj/scn/wiki

Best Regards.