Re: [firebird-support] Trouble with ADO.Net Provider and connection pool

[Helen Borrie hele...@iinet.net.au [firebird-support]]

Hello Jardar,

Saturday, August 20, 2016, 7:23:13 AM, you wrote:

(a good problem description)

But this is the wrong list for driver questions.  You need to
subscribe to the firebird-net-provider list and repeat your question
there.

https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

^heLen^ (Moderator)

[firebird-support] Trouble with ADO.Net Provider and connection pool

[Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]]

We are using NHibernate and firebird with C# code.

We have a server application that run 24/7. Our problem is that sometimes
we get an exception from when starting new transaction:
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Error reading
data from the connection.

We always dispose the nhibernate session. The problem is that it is not
able to recover from this failure unless we set pooling to
false(Pooling=false;). This is of course not desirable.

I see that there is a bug filed for the ADO.net Provider:
http://tracker.firebirdsql.org/browse/DNET-678

Is this the cause, and if so when will this be fixed?

Also is there any good ways to work around this problem?

-- 
Jardar Maatje
Nortek Data Services AS
Brugata 1
0168 Oslo
tlf: +47 95184034

[firebird-support] Re: Index and statistics

[michael.vilhelm...@microcom.dk [firebird-support]]

Thank you. 

Got it work :)

Re: [firebird-support] Index and statistics

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

 
 
W dniu 2016-08-19 10:35:58 użytkownik michael.vilhelm...@microcom.dk 
[firebird-support]  napisał:
 
Hi
 
Every once in a while we need to recalculate statistics for the index.
This we do manually.
 
I would like to do this automatically.
Can I do this from a batch file?
Or from the command line

Yes,
run from batch ISQL with script
 
regards,
Karol Bieniaszewski

[firebird-support] Index and statistics

[michael.vilhelm...@microcom.dk [firebird-support]]

Hi
 

 Every once in a while we need to recalculate statistics for the index.
 This we do manually.
 

 I would like to do this automatically.
 Can I do this from a batch file?
 Or from the command line