Trouble with ADO.Net Provider and connection pool

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Trouble with ADO.Net Provider and connection pool

Jardar Maatje
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:

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-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Trouble with ADO.Net Provider and connection pool

Jiří Činčura-2
> Is this the cause, and if so when will this be fixed?

Check the http://tracker.firebirdsql.org/browse/DNET-668 . That's like
superset of the solution.

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

Cleaning the pool is probably the best workaround you can get right now.

--
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Trouble with ADO.Net Provider and connection pool

Jardar Maatje

Hi

Any plans on when this issue will be fixed?


21. aug. 2016 20.55 skrev "Jiří Činčura" <[hidden email]>:
> Is this the cause, and if so when will this be fixed?

Check the http://tracker.firebirdsql.org/browse/DNET-668 . That's like
superset of the solution.

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

Cleaning the pool is probably the best workaround you can get right now.

--
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

------------------------------------------------------------------------------

_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Trouble with ADO.Net Provider and connection pool

Jiří Činčura-2
> Any plans on when this issue will be fixed?

No exact ETA.

--
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Trouble with ADO.Net Provider and connection pool

Jardar Maatje
As the other guy pointed out the connection pool is more or less useless as long as this i not fixed. Thus I would urge you to prioritize this if possible.

Best regards

Jardar

On Mon, Aug 22, 2016 at 8:49 AM, Jiří Činčura <[hidden email]> wrote:
> Any plans on when this issue will be fixed?

No exact ETA.

--
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



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


------------------------------------------------------------------------------

_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Trouble with ADO.Net Provider and connection pool

Jiří Činčura-2
> long as this i not fixed. Thus I would urge you to prioritize this if
> possible.

Yeah. It pretty much depends on my time. :\

--
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider