SELECT,UPDATE, DELETE With JDBC Adaptor

[Former Member]

Dear All,

I need to execute few Select, update and Delete statement by using JDBC Adaptor.

Suppose While select statement no records selected.

During Update no records exsist with specified key so no update possible.

During delete if no record found with specified key so no deletion possible.

In above cases do I get any error, any where in XI . Either in SXMB_MONI or in RWB.

Regards,

Raghvendra

[Former Member]

Hi

You will be getting SQL error in RWB and not processed flag in SXMB_MONI

Along with this you can use OS level command STDOUT and STDERR to write out the trace.

using JDBC you can even use following Isolated setting.

· Default (default setting of the respective database)

· None

· read_uncommitted (weakest setting)

· read_committed

· repeatable_read

· serializable (strongest setting)

You must only lower the isolation level where necessary and as far as necessary. To avoid data inconsistencies in the database when the isolation level is lowered, ensure that multiple database transactions cannot access the database simultaneously.

With this Do not set Auto Commit enabled indicator if the JDBC driver supports transactions.

Thanks

Gaurav Bhargava