Skip to Content
author's profile photo Former Member
Former Member

about receiver jdbc adapter

you can define receiver message type for jdbc adapter.

like:

<root>

<statement1>

<statement1/>

<statement2>

<statement2/>

<statement3>

<statement3/>

i wanna know

sequence at runtime of sql statement is executed according to the sequence defined by me in jdbc adapter?

such as:

at first : to execute statement1

and to execute statement2

at last, to execute statement3.

is that so?

thanks a lot.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 03:02 PM

    Hi,

    yes, that's exactly how it works ;o)

    You can also built in a "commit" to ensure 1 statement is carried out and finished before the next.

    Regards,

    Kai

    Edited by: Kai Lerch-Baier on Aug 13, 2009 5:03 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 03:05 PM

    Hello,

    Definitely, yes. I have verified this fact on one of my production project.

    BR,

    Dzmitry

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 03:07 PM

    You may also check SAP help for detail.

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

    E.g.:

    => Database Transaction 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.

    => Database u2018Auto-Commitu2019 Enabled (No Transaction Handling)

    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.

    This option is required for JDBC drivers that do not support transactions. To avoid data inconsistencies in the database when the isolation level is lowered, ensure that multiple database transactions cannot access the database simultaneously.

    Do not set this indicator if the JDBC driver supports transactions.

    => Disconnect from Database After Each Message Processing

    Set this indicator if the database connection is to be released and reestablished before every poll interval.

    => Batch Mode

    Set the indicator if you want to collect SQL statements in a batch. This can improve performance considerably.

    Some available JDBC drivers may not be able to use this feature to improve performance.

    Batch processing is not supported for the following statements:

    ● SELECT

    ● INSERT_UPDATE

    ● EXECUTE

    ● SQL_QUERY

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.