sender jdbc update sql error

[Former Member]

hello friend ,

my xi-content scenario is oracle -> xi ->sapr/3

i am getting erro message in adapter monitor as following

Sender Adapter v0915 for Party '', Service 'oracle':

Configured at 04:26:46 2006-04-03

Last message processing started 05:17:12 2006-04-03

Error: SQLException during update 'TEST': java.sql.SQLException: ORA-00900: invalid SQL statement

last retry interval started 05:17:12 2006-04-03

length 60,000 secs

but update sql query is running fine on DB. still i am getting invalid SQL statement .

no message in sxmb_moni.

how should i check my jdbc adapter is running fine if it fine then what is error .

thanks friends.

amit ranjan

[Former Member]

thanks everybody i solved my problem becos of ur nice suggestion .

amit

[bhavesh_kantilal]

Amit,

Can you please update us as to how you solved the problem?

Regards,

Bhavesh

[deviprasad_pothireddy]

Hi Amit,

Check this weblog, It may help you

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

[bhavesh_kantilal]

Amit,

Just use a Database CLient to execute the SELECT and UPDATE queries in your Sender JDBC adapter and see if they work fine?

As the error states, the error is purely because the UPDATE statement is wrong.

In case you do not want Update, use <b><TEST></b> instead of the <b>TEST</b> that I think you have used.

Regards,

Bhavesh

[Former Member]

Amit,

You are using a sender JDBC adapter. There are 2 SQL querries you write in a sender adapter(JDBC).

1. Select querry which selects the fields and fetch it to your XI server.

2. Update SQL. This is a crucial one coz you can not process same set of rows again and again. So you may want to maintain a flag. This happens here.

In your case update SQL querry does not seem to work.

Check it.

For more help post us the 2 querries(select & update).

Look into this link for info on config of sender JDBC adapter

http://help.sap.com/saphelp_nw2004s/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm

<i>(P.S: Reward replies that are helpful)</i>

Regards,

Jai Shankar.

[Former Member]

Hi ,

I think problem with your SQL statement..What statement you are using??

Check this link..

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

sekhar