How to Set - driver:oracle.jdbc.ReadTimeout 1000

[Former Member]

Hi All,

Need your help in Setting in our Oracle Db.

driver:oracle.jdbc.ReadTimeout 1000

driver:oracle.net.CONNECT_TIMEOUT 1000

We are not sure where to set the above parameters.

Best Regards,

Rableen

[Former Member]

Solved

[Former Member]

Hello Rableen,

It would be great if you brief the steps taken to resolve the issue. So that it might helps others in the future.

Thanks,

Siva Kumar

[former_member128291]

Dear Rableen,

Regarding your query you can refer the following SAP Notes which would also provide you more insights regarding these two parameters as well:

1398891 - XI/PI Adapter for Oracle: Overcoming DB Connection Issues

1078420 - XI/PI JDBC Adapter: Setting JDBC driver properties for DB

Regards,

Abhishek

[Former Member]

Hi,

Check 2.3.5 section of this document:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/c059d583-a551-2c10-e095-eb5d95e03747

Also check the notes

Note 1078420 - XI/PI JDBC Adapter: Setting JDBC driver properties for DB

[former_member188883]

Hi Rableen,

You can Refer SAP note 1078420 - XI/PI JDBC Adapter: Setting JDBC driver properties for DB which is for Oracle

Details are shared below

===================

In the advanced mode table section of sender channel and receiver channel configurations, we can set driver properties for each DB connection. Any such property would have to contain prefix 'driver:'(with out quotes) For example, for Oracle Database JDBC thin driver 10.2.0.3 version, the property oracle.jdbc.ReadTimeout helps to set read timeout while reading from the socket. Also for setting login time out in Oracle, we use oracle.net.CONNECT_TIMEOUT.

To set these two properties use as follows:

driver:oracle.jdbc.ReadTimeout 1000

driver:oracle.net.CONNECT_TIMEOUT 1000

You can use it as a system property -Doracle.jdbc.ReadTimeout=yyyy.

Regards,

Deepak Kori

[Former Member]

HI Deepak,

I have seen this note also, but this doesnt specify on how to set the system parameter in Oracle DB.

Can you please guide me on how to set this parameter.

Thanks,

Rableen

[Former Member]

Hello Rableen,

I guess these can be set from both config tool and NWA from release PI 7.10. I am not sure about the correct navigation.

Can you please explore both tools?

Please check Integration Repository--> Communication Channel as well.

Thanks,

Siva Kumar

Edited by: Siva Kumar Arivinti on Dec 28, 2011 9:46 AM

[former_member128291]

Dear Rableen,

You can set both the parameters as follows:

-> Integration Builder

-> Objects

-> Communication Channel

-> After choosing change mode select Parameters tab

-> Thereafter selected Advanced tab in parameters

-> In the tabular list under Additional parameters you can find these two parameters.

I hope this helps.

Regards,

Abhishek