I am using XI 7.0.
source system is oracle 126.96.36.199.0
very strange table issue.
i have one table which Flag field was not updated by XI Sender JDBC Adapter, when i use sender JDBC with advanced mode(Database Auto-Commit-Enabled(No Transaction Handling), <b>this table was updated as Y from N and even though Flag field was updated Y by sender JDBC Adapter, i could not see message on SXMB_MONI.</b>
flag field of another table was updated by sender JDBC Adapter without advanced mode(Database Auto-Commit-Enabled(No Transaction Handling). and i could see message on sxmb_moni.
so what is the problem?, how can i solve this? i never use advanced mode(database auto-commit-enabled)with sender JDBC adapter. and now i can not create this table as new table. so i have to solve this issue.
please help me.
i would highly appreciated if you help me so quickly.
Do you see any errors in the adapter monitoring without Database Auto-Commit-Enabled(No Transaction Handling.
Check the status of the your adapter,,
If you have selected the option NO TRANSACTION HADLING, it implies that the Transaction Handliong of your Database has been truned off.
<i>Set the indicator if you want to deactivate the logical unit of work, which the JDBC adapter requires to guarantee that data in the database is consistent.
<b>This option is required for JDBC drivers that do not support transactions.</b> To avoid data inconsistencies in the database when the isolation level is lowered, ensure that multiple database transactions cannot access the database simultaneously.</i>
From the link,