Devart Forums

peledkfir

It works, 10x

peledkfir

Hi,
I have problem with the fix when sending empty arrays
Now, I get ORA-06531: Reference to uninitialized collection

I iterate over the array in the stored procedure as follows

FORALL i IN p_array.FIRST. . p_array.LAST
INSERT INTO TMP VALUES(p_array(i));

This problem never occured to me before with dotconnect
Plz help
I'm using version 6.70
Thanks, kfir

peledkfir

When I execute storedprocedure, NRE is thrown from the provider after upgrading from version 6.50.228
The following code reproduces the exception:

DDL:

PROCEDURE WITH_ARRAY_PARAM ( p_array guid_array_t)
IS
BEGIN
null;
END;

TYPE guid_array_t is table of raw(16)

configuration connection string:

code:

Code: Select all

 var conn = DbProviderFactories.GetFactory(ConfigurationManager.ConnectionStrings["conn"].ProviderName).CreateConnection();
            conn.ConnectionString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
            using (conn)
            {
                conn.Open();
                using (IDbCommand command = conn.CreateCommand())
                {
                    command.CommandText = "WITH_ARRAY_PARAM";
                    command.CommandType = CommandType.StoredProcedure;
                    var param = DbProviderFactories.GetFactory(ConfigurationManager.ConnectionStrings["conn"].ProviderName).CreateParameter();
                    param.ParameterName = "p_array";
                    IList paramVal = new OracleArray(OracleType.GetObjectType("guid_array_t", (OracleConnection)conn));
                    param.Value = paramVal;
                    command.Parameters.Add(param);
                    command.ExecuteNonQuery(); // NRE
                }
            }

Regards,
Kfir

peledkfir

2. Because I need distributed transactions

peledkfir

1. In multi-threaded application it seems that your solution for enabling batch will effect all thread in the application - which is not good enough for my case..
2. I already read that post. My question was if there an other way to work with transacation that is not TransactionScope with batches like beginTransaction

10x for your response

peledkfir

In my model I have some entities mapped by table per subclass.
The sql generates when selecting the Set is some kind of

select * from tbl1
union all
(select * from tbl2
union all
(select * from tbl 3....

And so on.. it is a performance killer
My question is if you can consider to improve it to
select * from tbl1
union all
select * from tbl2
union all
select * from tbl3 .. and so on..

My current workaround is to select from the set using OfType but it brakes the code generic

I'm using dot connect 6.10.141 with oracle 11.2g

peledkfir

Hi,
I'm using dotConnect 6.10.141
I call in ambient transaction to a SP that deffer constrained until commit.
Using: EXECUTE IMMEDIATE 'SET CONSTRAINT ALL deferred';
If trying to commit when the SP brakes one of the FK's you will get a NullReferenceException instead of any other indicative exception of the error.

peledkfir

Hi,
I wish to know if there is a possibility to config only a specific context to use batch updates instead of configure it globally?
Another question, is there any way to use transactions with batch updates?

Thanks, Kfir

peledkfir

I'm using dbMonitor version 3.0.3. dotConnect 6.10.96 and Visual Studio 2010 SP1.

I'm using EF.

Maybe it's because the queries are done through EF and not directly ADO.NET?

peledkfir

Hey,
In some tables I work with Raw16 for representing Guid.
When working with db monitor, looking at executed sql statement parameters, instead of showing the value of the Guid or the values in the byte array it just shows "System.Byte[]".

It will be helpful if it will be fixed.
Thanks,
Kfir.

peledkfir

10x,
Kfir

peledkfir

When using OracleQueue Listen method with single consumer.
(QueueAgent.Name is null; QueueAgent.Address is queue name).
I get InvalidCastException DBNull to System.String.
dotConnect version: 6.10.111

kfir.

peledkfir

SWEET!

peledkfir

After applying the workaround I mentioned in other post:
http://www.devart.com/forums/viewtopic.php?t=20005
It seems the problem does not reproduces any more.

peledkfir

I found an other problem when working with transactions.
When trying to open a new connection with transaction suppress option I get an exception.
When trying the same with sql server. It works fine.

Code: Select all

        public void Hoo() 
        { 
            using (TransactionScope scope = new TransactionScope()) 
            {
               using (var model = new OHEntities2()) 
               using (TransactionScope scope1 = new TransactionScope()) 
               { 
                   model.Connection.Open(); 
                   model.OH_TABLE3.FirstOrDefault();
                   model.Connection.Close(); 
               } 

               using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.Suppress)) 
               { 
                   model.Connection.Open(); 
                   model.OH_TABLE3.FirstOrDefault();
                   model.Connection.Close(); 
               }

	       scope.Complete();
            }
        }

Devart Forums

Search found 22 matches

NRE when executing stored procedure with array type param

SELECT with inheritance in model

NullReferenceException in Dispose of transaction scope

Batch updates in EF

DB monitor and Raw

InvalidCastException when working with OracleQueue