JDBC Table

[Former Member]

Hi,

I am uploading some values into Oracle DB using JDBC adapter. Basically, how do u check whether the values have been uploaded or not.

Necessarily do you need to have access to the DB or any intermediate thing is there to validate.

Or is it enough if the JDBC comm., channel is ok.

[Former Member · Accepted solution]

Hi;

You need to check the target structure created in the sxmb_moni and look for the data inserted as expected(means the insert nodes getting created)

you also need to check in communication channel.

But other than this it will be good if you access the data base for verification .

Mudit

[bhavesh_kantilal]

Hi,

Saravana Has put across a few interesting ideas in this blog of his when dealing with JDBC adapters, a very good read,

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

Regards

Bhavesh

[prateek]

<i>I am uploading some values into Oracle DB using JDBC adapter. Basically, how do u check whether the values have been uploaded or not.</i>

U have to do this check at the receiver end

<i>Necessarily do you need to have access to the DB or any intermediate thing is there to validate.</i>

Actual update details could only be known if u have access to DB

<i>Or is it enough if the JDBC comm., channel is ok. </i>

Not possible

When u use XI, u can only receive some system and application ack. This could not tell u the whether database is updated or not.

Workaround:

When data is successfully received, update some specific database column. This update could act as the trigger to another interface when XI polls this database. This is how u could do it.. But it would be at the expense of 1 more interface

Regards,

Prateek

[justin_santhanam]

Anandha,

<i> Uploading......</i>

I think u r updating the database , yah its possible. Only if you make it as synchronous communication then you will get the response as how many records has been affected(updated).

In getting response you will get the count in<Update_Count> .. </Update_Count> tag. If its 0 then no records has been updated.

Best Regards,

raj.