[Firebird-devel] [ firebird-Bugs-746347 ] Transactions don't seem to be closed properly

[SourceForge.net <no...@so...>]

Bugs item #746347, was opened at 2003-05-30 17:23
Message generated for change (Comment added) made by seanleyne
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=746347&group_id=9028

Category: .Net Provider
Group: None
>Status: Deleted
>Resolution: Rejected
Priority: 5
Submitted By: Delphi Wiz (delphi_wiz)
Assigned to: Carlos Guzmán Álvarez (carlosga_fb)
Summary: Transactions don't seem to be closed properly

Initial Comment:
Carlos,

Please tell me if I'm doing something wrong, it could be 
just me, maybe I'm not doing everything to close and 
dispose a transaction but I get this error message quite 
often:

Additional information: attempt to store duplicate value 
(visible to active transactions) in unique 
index "XPKACCESS_RIGHTS"

I have the following code:
private void UpdateDataSet( DataSet dsData )
			{
string myConnection = sConnectionString;
string mySelectQuery = "SELECT * FROM 
ACCESS_RIGHTS";

FbConnection  myConn = new FbConnection 
myConnection);    
				
myConn.Open();
FbTransaction myTxn	= myConn.BeginTransaction();
FbCommand command = new FbCommand( 
mySelectQuery, myConn, myTxn );

FbDataAdapter myDataAdapter = new FbDataAdapter( 
command );			

FbCommandBuilder custCB		= new 
FbCommandBuilder(myDataAdapter);    
myDataAdapter.Update( dsData, "ACCESS_RIGHTS" );

myTxn.Commit();
myConn.Close();
myDataAdapter.Dispose();
myConn.Dispose();
custCB.Dispose();
command.Dispose();
			}
Am I missing something, why is the old transaction still 
hanging around, because it only happens on the second 
pass.

Here is what I'm doing:

I Insert 1 thru 100 in the primary key.
I Update the key to something else, to change the keys.
I Insert 1 thru 100 again again, and I get the exception.

If I add a brand new rows in Primary key, it does not 
throw an exception, only after update and re-insertion.



----------------------------------------------------------------------

>Comment By: Sean Leyne (seanleyne)
Date: 2003-05-30 23:05

Message:
Logged In: YES 
user_id=71163

**Please do not use the bug tracker as a support forum.**

Please post any issues to the appropriate support mailing 
lists/news mirror, first, and have the issue confirmed as a bug 
before posting an entry to the tracker.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=746347&group_id=9028