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
Default Command Timeout of Oracle EF Driver
Re: Default Command Timeout of Oracle EF Driver
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.GrMikeD wrote:1) Which is the default command timeout of the Devart Oracle EF driver?
2) Is this accessed through ObjectContext.CommandTimeout of DbContext?
If you set ObjectContext.CommandTimeout, its value will be assigned to OracleCommand.CommandTimeout before command execution.
Please send us a small test project with the corresponding DDL/DML script so that we can reproduce the issue in our environment.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.