JDBC Sender

[Former Member]

Hi,

Can any one clarrify my below doubts..

what is the exact use of the following options which are available in the JDBC sender communication channel..

1)Runnin operating system command

Command line

TimeOut

Terminate program after Time Out

2)Advacnced Parameters

Transaction isolation level and under each option.

Please explain me clearly what is the exact use of the above things.

Thanks

Chandu

[Former Member · Accepted solution]

Hi ,

Have you checked this link??

http://help.sap.com/saphelp_nw2004s/helpdata/en/0f/80243b4a66ae0ce10000000a11402f/frameset.htm

[Former Member]

Hi,

Just go through the following link.

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

Regards

Madhu

[Former Member]

Hi,

1) Command line

To specify an operating system command that is to be executed following successful database operations.

Timeout (secs.)

This specifies the maximum runtime of the executing program in seconds. When this time interval is exceeded, the adapter continues processing. The executing program continues to run in the background.

Terminate Program After Timeout

Set this indicator when the adapter is to terminate the executing program in the event of a timeout.

2)

Transaction Isolation Level

There are different levels of database transactions known as isolation levels. The isolation level determines how transactions running in parallel can influence each other. The options correspond to the JDBC constants:

● 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.

From the following link.

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

Regards,

Sudheer.

[Former Member]

Hi,

The following blog explains the Database Transaction Level in sender JDBC adapter

<a href="/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter:///people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Regards,

Sudharshan