[FB-Tracker] Created: (DNET-677) CLONE -NullReferenceException in FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[FB-Tracker] Created: (DNET-677) CLONE -NullReferenceException in FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()

JIRA tracker@firebirdsql.org
CLONE -NullReferenceException in FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()
----------------------------------------------------------------------------------------------------------

                 Key: DNET-677
                 URL: http://tracker.firebirdsql.org/browse/DNET-677
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.6.2.0
         Environment: IDE: Visual studio communiti 2013. Framework: C# .Net 4.0. Platform: Windows Server 2012 x64. Server: Firebird Embedded 2.5.4 x64.
            Reporter: Pedro Filipe de Morais Lima
            Assignee: Jiri Cincura
             Fix For: 4.7.0.0


Hi all.
First, sorry by my english, not native laguage.
Have the problem with x64 ADO.NET Provider.
In operations of adding, changing and deleting data in tables the program throwing exception NullReferenceException.

Exception stack:
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()
   at FirebirdSql.Data.FirebirdClient.FbTransaction.UpdateTransaction()
   at FirebirdSql.Data.FirebirdClient.FbTransaction.Commit()
   at FirebirdSql.Data.FirebirdClient.FbCommand.CommitImplicitTransaction()
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
   at *myMethod*

For example adding method:
                if (dbConnect.State != ConnectionState.Open)
                    dbConnect.Open();
                FbCommand findClientCom = new FbCommand("Select ID FROM CLIENTS WHERE ID='" + ID.ToString() + "'", dbConnect);
                FbDataAdapter FDA = new FbDataAdapter(findClientCom);
                DataSet ds = new DataSet();
                int count = FDA.Fill(ds);
                if (count > 0)
                {
                    errStr = "This Client is present";
                    return false;
                }
                String insertText = @"INSERT INTO CLIENTS (ID, NET_ID, NAME, LOGIN, PASSWORD, RES_PU, RES_KP, CLUSTER)";
                insertText += @" VALUES(@ID, @NET_ID, @NAME, @LOGIN, @PASSWORD, @RES_PU, @RES_KP, @CLUSTER)";
                FbCommand insertCom = new FbCommand(insertText, dbConnect);
                insertCom.Parameters.AddWithValue("@ID", ID.ToString());
                insertCom.Parameters.AddWithValue("@NET_ID", net_id.ToString());
                insertCom.Parameters.AddWithValue("@NAME", name);
                insertCom.Parameters.AddWithValue("@LOGIN", login);
                insertCom.Parameters.AddWithValue("@PASSWORD", password);
                insertCom.Parameters.AddWithValue("@RES_PU", res_pu);
                insertCom.Parameters.AddWithValue("@RES_KP", res_kp);
                insertCom.Parameters.AddWithValue("@CLUSTER", cluster.ToString());
                insertCom.ExecuteNonQuery();
                errStr = "Client " + VikingServer.ushortToStr(ID) + " was added";
                return true;
            }
            catch (Exception ex)
            {
                errStr = ex.ToString();
                return false;
            }

My methods are working stable on 32 platform. On x64 tables are changing, but after change i have this exception.

Please help me with this problem.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider