How to Configure Socket Read Timeout for Oracle in Database Connector

The Oracle Connection type in Database Connector exposes only a limited set of Oracle options (host, port, user, password, instance, etc.), but not arbitrary JDBC URL properties.

Please use the Generic Connection or Data Source Reference Connection to pass the connection propery oracle.jdbc.ReadTimeout (for Oracle driver version 10.1.0.5 or higher) to enable read timeout on socket. The timeout value is in milliseconds.

Example:

<db:generic-connection name="Oracle_Generic_Connection">

    <db:generic-config

        url="jdbc:oracle:thin:@//YOUR_HOST:1521/YOUR_SERVICE?oracle.jdbc.ReadTimeout=15000"

        user="myuser"

        password="mypassword"/>

</db:generic-connection>

If you are using an older version, you may need to do the same with another property "oracle.net.READ_TIMEOUT".