Hi,
The test case is the simplest one: starting from a blank WinForm, I just
dropped a FbDataAdapter component, which launched the wizard. After
instructed it to create a new connection, I specified "select * from
My_Test", where My_Test is the only table in the database, with two fields.
Once the creation of insert, update and delete command is finished OK, I
just press F5 to get the StackOverflowException. When the VS exception
window comes up, I selected 'copy details to the clipboard', but this only
shows:
System.StackOverflowException was unhandled
There is not a line number to refer to, and when intending to reload the
winform in VS, it simply disappears.
Form designer code is as follows
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager
resources = new
System.ComponentModel.ComponentResourceManager(typeof(MainForm));
this.fbDataAdapter1 = new
FirebirdSql.Data.FirebirdClient.FbDataAdapter();
this.fbCommand1 = new
FirebirdSql.Data.FirebirdClient.FbCommand();
this.fbCommand2 = new
FirebirdSql.Data.FirebirdClient.FbCommand();
this.fbCommand3 = new
FirebirdSql.Data.FirebirdClient.FbCommand();
this.fbCommand4 = new
FirebirdSql.Data.FirebirdClient.FbCommand();
this.fbConnection1 = new
FirebirdSql.Data.FirebirdClient.FbConnection();
this.SuspendLayout();
//
// fbDataAdapter1
//
this.fbDataAdapter1.DeleteCommand = this.fbCommand4;
this.fbDataAdapter1.InsertCommand = this.fbCommand2;
this.fbDataAdapter1.SelectCommand = this.fbCommand1;
this.fbDataAdapter1.UpdateCommand = this.fbCommand3;
//
// fbCommand1
//
this.fbCommand1.CommandText = "select * from
MY_TEST";
this.fbCommand1.CommandTimeout = 30;
this.fbCommand1.Connection = this.fbConnection1;
//
// fbCommand2
//
this.fbCommand2.CommandText = "INSERT INTO MY_TEST
(code, PROD) VALUES (@p1, @p2)";
this.fbCommand2.CommandTimeout = 30;
this.fbCommand2.Connection = this.fbConnection1;
this.fbCommand2.Parameters.AddRange(new
FirebirdSql.Data.FirebirdClient.FbParameter[] {
new
FirebirdSql.Data.FirebirdClient.FbParameter("@p1",
FirebirdSql.Data.FirebirdClient.FbDbType.Integer, 4,
System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)),
"code", System.Data.DataRowVersion.Current,
((object)(resources.GetObject("fbCommand2.Parameters")))),
new
FirebirdSql.Data.FirebirdClient.FbParameter("@p2",
FirebirdSql.Data.FirebirdClient.FbDbType.VarChar, 100,
System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)),
"PROD", System.Data.DataRowVersion.Current,
((object)(resources.GetObject("fbCommand2.Parameters1"))))});
//
// fbCommand3
//
this.fbCommand3.CommandText = "UPDATE MY_TEST SET
code = @p1, PROD = @p2 WHERE ((code = @p3))";
this.fbCommand3.CommandTimeout = 30;
this.fbCommand3.Connection = this.fbConnection1;
this.fbCommand3.Parameters.AddRange(new
FirebirdSql.Data.FirebirdClient.FbParameter[] {
new
FirebirdSql.Data.FirebirdClient.FbParameter("@p1",
FirebirdSql.Data.FirebirdClient.FbDbType.Integer, 4,
System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)),
"code", System.Data.DataRowVersion.Current,
((object)(resources.GetObject("fbCommand3.Parameters")))),
new
FirebirdSql.Data.FirebirdClient.FbParameter("@p2",
FirebirdSql.Data.FirebirdClient.FbDbType.VarChar, 100,
System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)),
"PROD", System.Data.DataRowVersion.Current,
((object)(resources.GetObject("fbCommand3.Parameters1")))),
new
FirebirdSql.Data.FirebirdClient.FbParameter("@p3",
FirebirdSql.Data.FirebirdClient.FbDbType.Integer, 4,
System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)),
"code", System.Data.DataRowVersion.Original,
((object)(resources.GetObject("fbCommand3.Parameters2"))))});
//
// fbCommand4
//
this.fbCommand4.CommandText = "DELETE FROM MY_TEST
WHERE ((code = @p1))";
this.fbCommand4.CommandTimeout = 30;
this.fbCommand4.Connection = this.fbConnection1;
this.fbCommand4.Parameters.AddRange(new
FirebirdSql.Data.FirebirdClient.FbParameter[] {
new
FirebirdSql.Data.FirebirdClient.FbParameter("@p1",
FirebirdSql.Data.FirebirdClient.FbDbType.Integer, 4,
System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)),
"code", System.Data.DataRowVersion.Original,
((object)(resources.GetObject("fbCommand4.Parameters"))))});
//
// fbConnection1
//
this.fbConnection1.ConnectionString =
"User=SYSDBA;Password=masterkey;Database=C:\\Test\\TEST.FDB;DataSource=;Port
=3050;Di" +
"alect=3;Charset=NONE;Role=;Connection
lifetime=0;Connection timeout=15;Pooling=T" +
"rue;Packet Size=8192;Server Type=0";
//
// MainForm
//
this.AutoScaleDimensions = new
System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode =
System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(389, 316);
this.Name = "MainForm";
this.Text = "Test";
this.ResumeLayout(false);
}
I did not tried with 2.1 RC, but as I just wanted to make some quick tests,
I used version 2.0.1 because of the wizards to automate commands creation.
Another detail possibly worth to mention is that I installed and then
removed DDEX Provider for Visual Studio. Maybe something has left broken in
the process.
Thanks again,
Victor
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Jiri Cincura
Sent: Domingo, 07 de Octubre de 2007 03:47 p.m.
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] StackOverflowException in (possibly)
FbDataAdapter
On 10/7/07, Victor Zajac <[EMAIL PROTECTED]> wrote:
>
>
>
>
> I'm using Firebird 2.0.3, Firebird .NET Provider 2.0.1. After configuring
> FbConnection, FbDataAdapter and DataSet, trying to run the application
leads
> to a System.StackOverflowException. Even trying to open the WinForm in
> design mode (SharpDevelop and VS 2005), crashes the IDEs.
>
> Although I found a post describing identical problem, couldn't find the
> solution.
>
> Thanks in advance
Any test case? On which line? In what file? Did you try to run 2.1 RC? ...
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
