Devart Forums

Hello, I have following two questions:

1) Which is the default command timeout of the Devart Oracle EF driver?

2) Is this accessed through ObjectContext.CommandTimeout of DbContext?

Thanks in advance!

Edit: The reason I ask is because a Devart Oracle query seems to freeze for ever when the database issues a ORA-12571: TNS:packet writer failure error. I am not sure if it is a matter of commandtimeout waiting infinitely, or an OracleDb issue, or a Devart driver issue...

Details: Oracle 11g, Devart for Oracle 8.3.146.6

GrMikeD wrote:1) Which is the default command timeout of the Devart Oracle EF driver?

2) Is this accessed through ObjectContext.CommandTimeout of DbContext?

Command timeout is determined by the value of the OracleCommand.CommandTimeout property. Default value is 0 (no limit). You can control the value of OracleCommand.CommandTimeout via the Default Command Timeout connection string parameter.
If you set ObjectContext.CommandTimeout, its value will be assigned to OracleCommand.CommandTimeout before command execution.

GrMikeD wrote:Edit: The reason I ask is because a Devart Oracle query seems to freeze for ever when the database issues a ORA-12571: TNS:packet writer failure error.

Please send us a small test project with the corresponding DDL/DML script so that we can reproduce the issue in our environment.