cancel
Showing results for 
Search instead for 
Did you mean: 

time out for JDBC

Former Member
0 Kudos

Hi experts,

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

Thanks in advance,

Regards,

Muraii

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Thanks,

Muraii

Former Member
0 Kudos

Hi,

this option is there in the JDBC Adaper itself

Regards

Seshagiri

Former Member
0 Kudos

use J2ee_Admin or Administrator to log on into your visual administrator.(depends on what comes on your screen during installation).

user will have to have the SAP_J2EE_ADMIN user role)

In your installtion drive(C:\ or d:\ etc..) search the folder \usr\sapclustername\JC00\j2ee\admin find a go.bat there and start it.

regards

kummari

Former Member
0 Kudos

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