strange JDBC

[Former Member]

Hi,

I am using XI 7.0.

source system is oracle 9.2.0.6.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.

thanks

venjamin.

[Former Member · Accepted solution]

Hi,

Do you see any errors in the adapter monitoring without Database Auto-Commit-Enabled(No Transaction Handling.

Check the status of the your adapter,,

http://<host>:<J2EE-Port>/mdt/amtServlet

Regards

Anand

[Former Member · Accepted solution]

Hi,

if i do not use advanced mode, i got error on adapter monitoring as below; if i use advance mode, no error message on adapter monitoring, and updated Flag as Y instead of N, but i could not see any message on SXMB_MONI.

Sender Adapter v1402 for Party '', Service 'BS_001_D':

Configured at 21:00:08 2006-07-07

Last message processing started 21:06:27 2006-07-07

Error: Sending message '5d3add50-0d82-11db-9e07-000d604dde82' - failed with unexpected exception - proceed anyway: java.lang.ClassCastException: $Proxy240

last retry interval started 21:06:27 2006-07-07

length 10,000 secs

thanks

venjamin

[bhavesh_kantilal · Accepted solution]

Hi Venjamin,

This is a strange problem indeed.

Am not sure if this will work , but can you try this way ,

ISLOATION LEVEL FOR TRANSACTION -- Can you try it with each of the 5 options available?

Try with serializable, and then the other options,

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

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi,

thanks for the note, but still having problem.

i do not understand, jdbc adaper is working fine with some table, but some table in same db, does not update flag without auto-commit option. and also, by auto-commit, it was updated flag Y, i could not see any message on sxmb_moni.

thanks

venjamin

[bhavesh_kantilal]

Hi Venajamin,

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,

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

Regards,

Bhavesh