firebird-net-provider Mailing List for Firebird (Page 6)

It's not working again.
Here's a full test code of my sample
FbConnection con = new FbConnection(ConnectionString);
con.Open();
FbTransaction tran = con.BeginTransaction();
FbDataAdapter ad = new FbDataAdapter(@"SELECT  * FROM TBL", con);
ad.SelectCommand.Transaction = tran;
DataSet ds = new DataSet();
ad.Fill(ds, "TBL1001625");
con.Close();
con.Open();
tran = con.BeginTransaction();
ad.SelectCommand.Connection = con;
ad.SelectCommand.Transaction = tran;
DataSet ds1 = new DataSet();
ad.Fill(ds1, "TBL1001625"); // <--Exception here
/*
"Object reference not set to an instance of an object"
source: FbCommand.cs - Prepare()
statement = new FbStatement(Connection,
              Transaction,
              Parameters,
              commands[actualCommand], //commands is null, actualCommand == -1

              CommandType);

*/
con.Close();

I've took a closer look at source code for provider, and found, that you're disposing all commands in FbConnection.Close method.
So, we need to recreate every command (FbCommand) after FbConnection.Close() calling. It seems to be a bug in provide, cause MSSQL provider works good in this situation.

> 
> Hello:
> 
> Add this new line too and test please ( i can't test now ):
> 
> tran = con.BeginTransaction();
> -----> ad.SelectCommand.Connection = con
> ad.SelectCommand.Transaction = tran;
> 
> 
> 
> 
> -- 
> Best regards
> 
> Carlos Guzma'n A'lvarez
> Vigo-Spain
> 
> "No tengo dones especiales.So'lo soy apasionadamente curioso"
> Albert Einstein, cienti'fico.
> 
> 

HEllo:

> I'm using Release of FB.NET 1.0 provider. Database - firebird 1.5 (RC3), Dialect 1.


I'm using this code as test case and all is working as expected:

	FbConnection con = new FbConnection(connectionString);
	con.Open();
	FbTransaction tran = con.BeginTransaction();

	FbCommand command = new FbCommand(@"SELECT * FROM TEST_TABLE_01", con, 
tran);

	FbDataAdapter ad = new FbDataAdapter(command);
	DataSet ds = new DataSet();
	ad.Fill(ds, "TBL");

	FbCommandBuilder b = new FbCommandBuilder(ad);
	b.QuotePrefix = String.Empty;
	b.QuoteSuffix = String.Empty;
	
	ad.Update(ds, "TBL"); // <--- Exception goes here

	con.Close();


-- 
Best regards

Carlos Guzma'n A'lvarez
Vigo-Spain

"No tengo dones especiales.So'lo soy apasionadamente curioso"
Albert Einstein, cienti'fico.

I've forgot to write one line.
After 
con.Close();
There should be 
con.Open();
And the problem is still there.

Is this behavior by-design or a bug ?

FbConnection con = new FbConnection(cs);
con.Open();
FbTransaction tran = con.BeginTransaction();
FbDataAdapter ad = new FbDataAdapter(@"SELECT * FROM TBL", con);
DataSet ds = new DataSet();
ad.Fill(ds, "TBL");
con.Close();
tran = con.BeginTransaction();
ad.SelectCommand.Transaction = tran;
FbCommandBuilder b = new FbCommandBuilder(ad);
b.QuotePrefix = String.Empty;
b.QuoteSuffix = String.Empty;

ad.Update(ds, "TBL1001625"); // <--- Exception goes here
/*
"Object reference not set to an instance of an object"
source: FbCommand.cs - Prepare()
statement = new FbStatement(Connection, 
              Transaction, 
              Parameters,
              commands[actualCommand], //commands is null, actualCommand == -1

              CommandType);	

*/
actually, it's not a bug in FbCommandBuilder, because we can change last line to
DataSet ds1 = new DataSet();
ad.Fill(ds1, "TBL");
and there will be an exception too.

I'm using Release of FB.NET 1.0 provider. Database - firebird 1.5 (RC3), Dialect 1.