From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos
Sent: Friday, December 14, 2007 9:00 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Faulty GdsConnection::NextOperation
Hello:
The "spinner" in GdsConnection::NextOperation() doesn't seem to be any
good idea, it causes the application to lock up in random situations.
What version of the Firebird server are you using ??
WI-V2.0.1.12855 Firebird 2.0
What version of the .NNET provider are you using ??
2.1.0.0
What version of .NET are you using ??
3.5
Can you send a test case showing the problem ??
Nah, not a complete one. The fault is a bit random, and you need a lengthy
dataset to stumble across it (I can’t post you our customer database :).
Here is a codesnippet showing the type of code where this occurs:
FirebirdSql.Data.FirebirdClient.FbCommand cmd = new
FirebirdSql.Data.FirebirdClient.FbCommand(sql, conn);
FirebirdSql.Data.FirebirdClient.FbDataReader leser =
cmd.ExecuteReader();
while (leser.Read()) // <--- fault randomly occurs here
{
}
Nothing spesial about it.
The SQL is like this
SELECT M.Id + 500000,
Navn, COALESCE( Postadresse, '', COALESCE( Postnummer, '' ), COALESCE(
Poststed, '' ),
COALESCE( Telefon, '' ), COALESCE( Faks, '' ), COALESCE( Mobil, '' ),
COALESCE( Epostadresse, '' ),
COALESCE( Organisasjonsnummer, '' ), COALESCE( Bankkontonummer, '' ),
COALESCE( Betalingsbetingelse, '' ), Tilleggstekst
FROM Motpart M
JOIN MotpartElektronisk ME ON ME.Motpartkategori = 'L' AND ME.Id = M.Id
WHERE M.Motpartkategori = 'L' AND Datoslettet IS NULL
AND EXISTS( SELECT *
FROM Reskontro R
WHERE R.Motpartkategori = 'L' AND R.Motpartid = M.Id )
it returns a set of aprox. 12000 records, the fault can occure on reading the
first record or after several thousand records
hth
-frode
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
