NullReferenceException in
FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()
---------------------------------------------------------------------------------------------------
Key: DNET-605
URL: http://tracker.firebirdsql.org/browse/DNET-605
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: Maxim
Assignee: Jiri Cincura
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
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
