Solved SQLB-2451: There is already an open DataReader associated with this Com

Report SqlBase bugs and possible workarounds.
Mide

SQLB-2451: There is already an open DataReader associated with this Com

Post by Mide » 23 Dec 2015, 20:04

SqlBase 12, .NET data provider.

Open SqlBaseConnection

Start SqlBaseTransaction, commit, dispose.

Start another SqlBaseTransaction using same connection.

You will get error from subject.

Mike Vandine

Re: SQLB-2451: There is already an open DataReader associated with this Com

Post by Mike Vandine » 07 Jan 2016, 08:03

Hi Mide,

I saw that you posted this in the SB12 forum as well. Did you get a resolution to this?

Best regards,

Mide

Re: SQLB-2451: There is already an open DataReader associated with this Com

Post by Mide » 08 Jan 2016, 10:43

Nope

I first posted this in SqlBase 12 forum, but after testing I think it's u bug so I posted it here.

Maybe it's me but I think that one should be able to execute two or more transactions over same connection. I'm not talking about concurence transactions but one after another.

Right now I'm in process of porting our SqlBase 8.5 database to 12 version and I'm stuck becouse of this "bug".

Mike Vandine

Re: SQLB-2451: There is already an open DataReader associated with this Com

Post by Mike Vandine » 11 Jan 2016, 04:15

Hi,

OK, I understand. Please submit a small project that shows this issue that I can give to Dev. I think that maybe the dispose might not be clearing the connection quickly enough.

Mike

Mide

Re: SQLB-2451: There is already an open DataReader associated with this Com

Post by Mide » 11 Jan 2016, 11:32

Thank you Mike

Here is example project (Visual Studio 2013, .NET Framework 4.0).

I also noticed one more thing preparing the test case.

When you add reference to Gupta.SqlBase.Data and if you choose from properties window for referenced assembly option "specific version" true than you get compiler warning
Warning 1 The predefined type 'System.Runtime.CompilerServices.ExtensionAttribute' is defined in multiple assemblies in the global alias; using definition from 'h:\SQLBase 12\Gupta.SQLBase.Data.dll' C:\Users\mide\Documents\Visual Studio 2013\Projects\SQLBase12Test\SQLBase12Test\CSC SQLBase12Test
In this case opening connection and working with Gupta.SqlBase.Data is significantly slower. Do I need to open new thread for this ?
You do not have the required permissions to view the files attached to this post.

Mike Vandine

Re: SQLB-2451: There is already an open DataReader associated with this Com

Post by Mike Vandine » 12 Jan 2016, 00:26

Hi,

This has been reproduced and SQLB-2451 was created for this issue. It's scheduled for a SB12.0.1 fix.

Regarding the warning message:

Regarding the warning message: "The warning is a workaround for a feature I use. It will be removed when we no longer target .NET 2.0. "

Regarding the slowness of the .NET driver, can you please open a new thread with a sample and steps to show the problem.

Best regards,

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests