Hello Carlos,
It has been quite some time since I did not update my code with respect
to Firebird and the FirebirdClient library.
I have downloaded and compiled FirebirdClient ADO.NET 2.0 provider for
.NET 2.0. It is the final 2.0 version. And I am running a RC5 Firebird
server on my 2003 server.
I ran all my tests and have come across a crash caused by an Update of
a very simple table. The crash description is :
Dynamic SQL Error
SQL error code = -501
Attempt to reclose a closed cursor
The stack trace is like this :
FbDataAdapter.Update
FbDataAdapter.OnRowUpdating
FbCommandBuilder.RowUpdatingHandler
...
DbCommandBuilder.GetSchemaTable
DbCommand.ExecuteReader
FbCommand.ExecuteDbDataReader
FbCommand.ExecuteReader
FbCommand.ExecuteCommand
FbCommand.Prepare(true)
StatementBase.Close
GdsStatement.Free
GdsDatabase.ReadResponse
GdsConnection.ReadResponse
GdsConnection.ReadStatusVector
And the command found in ExecuteCommand is the following :
SELECT * FROM XYZ XYZ WHERE (0 = 1);
I suspect that somehow the always false condition (0 = 1) causes
some trouble at some level in the ADO.NET/provider/db stack. This
strange condition is built automatically by some application code
which wants to get a Table object with the schema but no data in
it. Then it proceeds by adding 3 rows and does the Update.
Do you have enough information to get an idea as to how the bug
could be fixed ?
Thanks a lot.
Pierre
PS: I tried to access to firebird.cvs.sourceforge.net in order to
update my sources based on CVS, but I don't get any response
from the CVS server. Something must have changed, any clues?
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
