Bug #28678 DBConcurrency error on Updating/Deleting
Submitted: 25 May 2007 13:14 Modified: 11 Aug 2007 11:41
Reporter: David Bernal Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:5.0.41 OS:Windows (XP)
Assigned to: CPU Architecture:Any
Tags: 5.0.41, DBConcurrency, error

[25 May 2007 13:14] David Bernal 
Description:
Hi
I've done a c# application that inserts/updates/deletes some rows, if ran well with 5.0.22 comunity but it returns a dbconcurrecy error on 5.0.41.

I'm using that code for customize the dataadapters

connexio() is my string connection;        

internal static MySqlConnection conn()
        {
            MySqlConnection myConnection = new MySqlConnection(connexio());
            return myConnection;
        }

internal static MySqlDataAdapter mysqlDataAdapter(string taulabd)
        {
            MySqlDataAdapter da = new MySqlDataAdapter();
            da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
            MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
            da.SelectCommand = new MySqlCommand("SELECT * FROM " + taulabd, conn());
            return da;
        }

I'm using connector/Net 5.0.7

Thank's a lot.

How to repeat:
connexio() is my string connection;        

internal static MySqlConnection conn()
        {
            MySqlConnection myConnection = new MySqlConnection(connexio());
            return myConnection;
        }

internal static MySqlDataAdapter mysqlDataAdapter(string taulabd)
        {
            MySqlDataAdapter da = new MySqlDataAdapter();
            da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
            MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
            da.SelectCommand = new MySqlCommand("SELECT * FROM " + taulabd, conn());
            return da;
        }

on mysql server 5.0.41

Suggested fix:
don't know
[11 Jul 2007 11:41] Tonci Grgin 
David, thanks for your report.

I am a bit puzzled about what is your test case for? I see no deletes / updates you refer to in title. Can you please post complete test case showing the error every time you run it.

Is it possible that you changed something in your configuration (my.ini/cnf, NET fw, c/NET version etc.)?
[11 Aug 2007 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".