All geek questions in one place

Oracle.net.READ_TIMEOUT vs. oracle.jdbc.ReadTimeout

I tried setting oracle.net.READ_TIMEOUT as connection properties, but it does not seem to work, however setting oracle.jdbc.ReadTimeout works. Any idea why? I am using 11g JDBC Drivers. And the database server version is 11 g.

+6
source share
3 answers

According to http://www.javamonamour.org/2012/09/oraclenetconnecttimeout.html

oracle.net.READ_TIMEOUT for jdbc versions < 10.1.0.5 oracle.jdbc.ReadTimeout for jdbc versions >=10.1.0.5

So, if you are using the JDBC driver version 10.1.0.5 or higher, then oracle.jdbc.ReadTimeout is the correct property.

+5
source

try reading the Oracle document "How to ensure that JDBC queries are always in sync (Doc ID 559564.1)" They suggest using one of these properties:

 for the Thin driver: oracle.net.ns.SQLnetDef.TCP_CONNTIMEOUT_STR for the OCI driver: sqlnet.outbound_connection_timeout

I have not tested myself, so I can not guarantee that it really solves the problem.

0
source

Unfortunately, this document requires access to an Oracle support account.

-1
source

Source: https://habr.com/ru/post/952738/

More articles:


All Articles