Skip to Content
avatar image
Former Member

time out for JDBC

Hi experts,

How can we set the timeout parameters of the JDBC adapter for an Oracle database?

Thanks in advance,

Regards,

Muraii

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 04, 2008 at 09:51 AM

    Hi,

    In the JDBC Adapter we have the option of

    Run Operating System Command

    · Command Line

    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 if the adapter is to terminate the executing program in the event of a timeout.

    Reffere this

    http://help.sap.com/saphelp_nw70/helpdata/EN/ae/d03341771b4c0de10000000a1550b0/frameset.htm

    Regards

    Seshagiri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 04, 2008 at 11:39 AM

    I have to use visual administrator no? If yes, how can I login in that?

    Thanks,

    Muraii

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi for timeout error

      in JDBC RECEIVER ADAPTER

      Run Operating System Command

      · Command Line

      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 if the adapter is to terminate the executing program in the event of a timeout.

      The adapter writes the output (STDOUT and STDERR) for the operating system command in the system trace.

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

      In your Receiver JDBC adapter there is an option Disconnect From Database After Processing Each Message.

      Select this option and you will not face the issue further.

      regards

      kummari

      Edited by: kummari on Jul 4, 2008 1:48 PM

  • avatar image
    Former Member
    Jul 09, 2008 at 09:33 AM

    Hi all,

    the problem is solved I had to go in TC: smicm and then services and change the http timeout parameters!

    Thanks again,

    Regards,

    Muraii

    Add comment
    10|10000 characters needed characters exceeded