firebird-net-provider

[Firebird-net-provider] ExecuteReader and "Attempt to reopen an open cursor"

[Maarten K. <mk...@xs...>]

Hi,

I have a problem with ExecuteReader. I have the following code:

-------

public override NodeData getNodeData(int id) {
   NodeData data = new NodeData(0);
   FNodeGetNodeDataCommand.Parameters["@ID"].Value = id;
   FNodeGetNodeDataCommand.Transaction = FTransaction;
   try {
    FbDataReader reader =
FNodeGetNodeDataCommand.ExecuteReader(CommandBehavior.SingleRow);
    try {
     if (!reader.Read()) {
      throw new Exception("Node not found (" + id + ")");
     }
     assignNodeData(reader, ref data);
    }
    finally {
     reader.Close();
    }
   } catch {
    // .....
    throw;
   }
   return data;
  }

---------

If I begin a transaction outside this method and then call this method
multiple times without committing the transaction inbetween, the second time
I call this method I get a FbException on the call to ExecuteReader with the
message:

"Dynamic SQL Error SQL Error Code = -502 Attempt to reopen an open cursor".

If I start and commit a transaction for every call I don't get the
exception.

Does anyone see what I am doing wrong here?

Thanks,

Maarten

Re: [Firebird-net-provider] ExecuteReader and "Attempt to reopen an open cursor"

[<car...@te...>]

Hello:

> Does anyone see what I am doing wrong here?

I'm going to try to see it today, wich version of the NET provider are 
you using ?? RC2 ??


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] ExecuteReader and "Attempt to reopen an open cursor"

[Carlos G. A. <car...@te...>]

Hello:


I'm making test without problems, can you tell me if this is correct 
test case, please:


public static void Main(string[] args)
{			
	string connectionString =
		@"Database=D:\TESTDB.GDB;" +			
		"User=SYSDBA;"		+
		"Password=masterkey;";

	FbConnection connection = new FbConnection(connectionString);
	
	connection.Open();

	FbTransaction transaction = connection.BeginTransaction();		

	string commandText = "select * from TEST_TABLE_01 where int_field 
= @ID";				

	FbCommand command = new FbCommand(commandText, connection,transaction);

	command.Parameters.Add("@ID", FbType.Integer);

	getNodeData(command, 1);
	getNodeData(command, 2);
	getNodeData(command, 3);
			
	connection.Close();
}				

public static void getNodeData(FbCommand command, int id) 		{
	command.Parameters["@ID"].Value = id;			
	try
	{
		FbDataReader reader = 
command.ExecuteReader(System.Data.CommandBehavior.SingleRow);

		try 				
		{
			if (!reader.Read())
			{
			throw new Exception("Node not found")");
			}
		}
	    	finally 			
		{
			reader.Close();
	    	}
	}
	catch
	{
		throw;
	}						
}






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] ExecuteReader and "Attempt to reopen an open cursor"

[Carlos G. A. <car...@te...>]

Hello:

> Does anyone see what I am doing wrong here?

I'm trying to reproduce it ( without luck at this moment ), can you send 
the message and stack trace of the exception ??, please.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.