Oracle 19.3.0.0 and Direct mode
Posted: Fri 09 Aug 2019 12:14
Question.
Does the latest dotConnect for Oracle support Oracle 19.3.0.0 and to what extent?
I'm getting strange errors when using it to insert large amounts of data (via a 3rd party library, Z.EntityFramework.Extensions, but nonetheless) and I'm only getting them when running Devart in Direct mode...
The exception occurs when executing the following statement:
Library details:
EF version: 6.1.3
Database Provider: Devart dotConnect for Oracle 9.7.770.0 (using Direct mode)
Oracle database 19.3.0.0
I'm posting this on your forum because the library works when I disable direct mode - running via Oracle client works as expected.
Does the latest dotConnect for Oracle support Oracle 19.3.0.0 and to what extent?
I'm getting strange errors when using it to insert large amounts of data (via a 3rd party library, Z.EntityFramework.Extensions, but nonetheless) and I'm only getting them when running Devart in Direct mode...
Code: Select all
Stack trace:
System.Exception: An error occurred while updating the entries. See the inner exception for details. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Devart.Data.Oracle.OracleException: ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-4] [10] [10] [] [] [] [] [] ---> Devart.Data.Oracle.OracleException: ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-4] [10] [10] [] [] [] [] []
at at Devart.Data.Oracle.ed.a(dk A_0, Int32 A_1)
at at Devart.Data.Oracle.ed.a(Int32 A_0, ei A_1)
at at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
at at Devart.Data.Oracle.OracleCommand.a(Int32 A_0, Boolean A_1, Int64[]& A_2)
--- End of inner exception stack trace ---
at at Devart.Data.Oracle.OracleCommand.a(Int32 A_0, Boolean A_1, Int64[]& A_2)
at at Devart.Data.Oracle.OracleCommand.ExecuteArray(Int32 iters)
--- End of inner exception stack trace ---
at at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
at at .(DbCommand , BulkOperation , Int32 )
at at .( , DbCommand )
at at .Execute(List`1 actions)
at at .(List`1 )
at at Z.BulkOperations.BulkOperation.Execute()
at at Z.BulkOperations.BulkOperation.BulkUpdate()
at at .(List`1 , Object , Dictionary`2 )
at at .Execute()
--- End of inner exception stack trace ---
at at .Execute()
at at DbContextExtensions.(DbContext this, Boolean , Action`1 , Boolean )
at at DbContextExtensions.BulkSaveChanges(DbContext this, Boolean useEntityFrameworkPropagation, Action`1 bulkOperationFactory)
at at DbContextExtensions.BulkSaveChanges(DbContext this)
Code: Select all
Statement:
- UPDATE T_MEASUREMENT SET "STATUS" = :P_0 WHERE "ID" = :P_1
Parameter info:
- P_0, Input param, Type=Number, Value = System.Object[]
- P_1, Input param, Type=Number, Value = System.Object[]
EF version: 6.1.3
Database Provider: Devart dotConnect for Oracle 9.7.770.0 (using Direct mode)
Oracle database 19.3.0.0
I'm posting this on your forum because the library works when I disable direct mode - running via Oracle client works as expected.