firebird-net-provider — All about development of the MS .Net provider

[Firebird-net-provider] [FB-Tracker] Created: (DNET-590) Use constants for defaults for FbConnectionString and FbConnectionStringBuilder

[Jiri C. (JIRA) <tr...@fi...>]

Use constants for defaults for FbConnectionString and FbConnectionStringBuilder
-------------------------------------------------------------------------------

                 Key: DNET-590
                 URL: http://tracker.firebirdsql.org/browse/DNET-590
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Trivial




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] Decorators for FbConnectionString properties

[Jiří Č. <ji...@ci...>]

Thanks. Merged.

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

Re: [Firebird-net-provider] Decorators for FbConnectionString properties

[Hernan M. <her...@ob...>]

Fine, thanks.
I think the Unix LFs came from my git client in Windows. I haven’t used it in this OS before and it’s probably misconfigured.


> El 4/2/2015, a las 17:34, Jiří Činčura <ji...@ci...> escribió:
> 
>> In FbConnectionStringBuilder.cs there’s a mix of tabs and spaces. Are there any policy on that? The code I’ve added uses tabs for indentation and I didn’t touch any existing tabs and/or spaces.
> 
> Should be tabs everywhere. But the codebase remembers something. But as long as the code is correct, it doesn't matter that much. 
> 
>> Regarding line-endings, I assume you use Unix LF, right?
> 
> CR LF. But again. Not much important. Decent editor will handle it. :)
> 
> -- 
> Mgr. Jiří Činčura
> Independent IT Specialist
> 
> 
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Decorators for FbConnectionString properties

[Jiří Č. <ji...@ci...>]

> In FbConnectionStringBuilder.cs there’s a mix of tabs and spaces. Are there any policy on that? The code I’ve added uses tabs for indentation and I didn’t touch any existing tabs and/or spaces.

Should be tabs everywhere. But the codebase remembers something. But as long as the code is correct, it doesn't matter that much. 

> Regarding line-endings, I assume you use Unix LF, right?

CR LF. But again. Not much important. Decent editor will handle it. :)

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

Re: [Firebird-net-provider] Decorators for FbConnectionString properties

[Hernan M. <her...@ob...>]

Hi,

In FbConnectionStringBuilder.cs there’s a mix of tabs and spaces. Are there any policy on that? The code I’ve added uses tabs for indentation and I didn’t touch any existing tabs and/or spaces.
Regarding line-endings, I assume you use Unix LF, right?


Hernán Martínez-Foffani
_________________________ 
OBI - on board intelligence
Director de Tecnología
her...@ob... <mailto:her...@ob...>
> El 27/1/2015, a las 18:56, Jiří Činčura <ji...@ci...> escribió:
> 
> Sure. Go ahead. Once done create PR on GitHub and that’s it.
>  
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>  
> From: Hernan Martinez [mailto:her...@ob...] 
> Sent: Tuesday, January 27, 2015 5:06 PM
> To: Fir...@li...
> Subject: [Firebird-net-provider] Decorators for FbConnectionString properties
>  
> Hi dev(s)!
>  
> One nice addition would be to decorate FbConnectionString public properties with Attribute decorators like Category, Description, Editor, DefaultValue, etc.
> It’s a fairly easy mod (if only with English texts) and I can do it by myself. Would you accept patches? Do you expect any problem with regards to Mono?
>  
> Regards,
>  
> Hernán Martínez-Foffani
> _________________________ 
> OBI - on board intelligence
> Director de Tecnología
> her...@ob... <mailto:her...@ob...>
>  
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/_______________________________________________ <http://goparallel.sourceforge.net/_______________________________________________>
> Firebird-net-provider mailing list
> Fir...@li... <mailto:Fir...@li...>
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider <https://lists.sourceforge.net/lists/listinfo/firebird-net-provider>

Re: [Firebird-net-provider] Firebird EF6 DDEX adding Views

[Christoph G. <chr...@st...>]

But this is exactly the point: it doesn't. I made a screenshot to explain. Below Entities there should be an object "V_PERSONENROLLE".

The views name is "V_PERSONENROLLE". It exists commented or uncommented in the EDMX. It's part of the "modViews". As you can see, there are other entities like "T_PARAMETER". These are tables.

Thank's for your support
C

Here's a link to the image: http://download.stranto.com/fbef6.jpg





The wizard in VS should generate you the CSDL as well.

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



*         In designer I make "Update from database"

*         View is not added, but the error message is shown.

*         No entity is added under the myViewModel.tt file (in the VS solution). But there is an entity of the previous added table.
Also under myViewModel.Context.tt\Entities there is no view entity added. There is no myview.cs class. There is one for the table.

*         I now save the EDMX file and open it as XML. I'm uncommenting the block for the view (and deleting the error message which is part of the commented block.

*         Adding part for "<Key>" referencing one of the columns of the view.

*         Saving the EDMX again.

*         Now I can't open it anymore in the designer.

*         In XML mode for EDMX file I get the message: "Entity type [myview] has no entity set".

That's what I meant: I know would have to create (and update) the entities manually.

BR
C



No. It's already there.
--
Mgr. Jiří Činčura
Independent IT Specialist



Thank you for your reply. I found that information already. I also tried that already. But I then would have to add Entities manually, right? Or did I miss a step? This makes it very "not handsome" to use because during development process the views are changing a lot. Is there any other solution? Like marking columns in the database with #PK_GEN# or something similar?

BR
C


http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/



--

Mgr. Jiří Činčura

Independent IT Specialist



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

Dive into the World of Parallel Programming. The Go Parallel Website,

sponsored by Intel and developed in partnership with Slashdot Media, is your

hub for all things parallel software development, from weekly thought

leadership blogs to news, videos, case studies, tutorials and more. Take a

look and join the conversation now. http://goparallel.sourceforge.net/

_______________________________________________

Firebird-net-provider mailing list

Fir...@li...

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


845...@S0...

Von: Christoph Gasser
Gesendet: Samstag, 31. Jänner 2015 12:47
An: 'fir...@li...'
Betreff: Firebird EF6 DDEX adding Views

I'm using VS 2012, Firebird 2.5, EF6. When trying to add a View to my model in the designer I get the message:

"The table/view 'Firebird.Firebird.V_MYVIEW' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it."

That's because EF need a PK for every table / view. When using MSSQL there is an approach using ISNULL in the view to be able to add the view to the model. But ISNULL is not supported in Firebird.
The underlying table of the view has PK which is also marked as #PK_GEN# . And I'm able to add this table to my model.

So my question is: Does anyone know how to add a view to a EF6 model in designer?

BR
C

Re: [Firebird-net-provider] Firebird EF6 DDEX adding Views

[Jiří Č. <ji...@ci...>]

The wizard in VS should generate you the CSDL as well.

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




On Mon, Feb 2, 2015 at 11:13 AM -0800, "Christoph Gasser" <chr...@st...<mailto:chr...@st...>> wrote:


*         In designer I make "Update from database"

*         View is not added, but the error message is shown.

*         No entity is added under the myViewModel.tt file (in the VS solution). But there is an entity of the previous added table.
Also under myViewModel.Context.tt\Entities there is no view entity added. There is no myview.cs class. There is one for the table.

*         I now save the EDMX file and open it as XML. I'm uncommenting the block for the view (and deleting the error message which is part of the commented block.

*         Adding part for "<Key>" referencing one of the columns of the view.

*         Saving the EDMX again.

*         Now I can't open it anymore in the designer.

*         In XML mode for EDMX file I get the message: "Entity type [myview] has no entity set".

That's what I meant: I know would have to create (and update) the entities manually.

BR
C



No. It's already there.
--
Mgr. Jiří Činčura
Independent IT Specialist



Thank you for your reply. I found that information already. I also tried that already. But I then would have to add Entities manually, right? Or did I miss a step? This makes it very "not handsome" to use because during development process the views are changing a lot. Is there any other solution? Like marking columns in the database with #PK_GEN# or something similar?

BR
C


http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/



--

Mgr. Jiří Činčura

Independent IT Specialist



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

Dive into the World of Parallel Programming. The Go Parallel Website,

sponsored by Intel and developed in partnership with Slashdot Media, is your

hub for all things parallel software development, from weekly thought

leadership blogs to news, videos, case studies, tutorials and more. Take a

look and join the conversation now. http://goparallel.sourceforge.net/

_______________________________________________

Firebird-net-provider mailing list

Fir...@li...

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


845...@S0...

Von: Christoph Gasser
Gesendet: Samstag, 31. Jänner 2015 12:47
An: 'fir...@li...'
Betreff: Firebird EF6 DDEX adding Views

I'm using VS 2012, Firebird 2.5, EF6. When trying to add a View to my model in the designer I get the message:

"The table/view 'Firebird.Firebird.V_MYVIEW' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it."

That's because EF need a PK for every table / view. When using MSSQL there is an approach using ISNULL in the view to be able to add the view to the model. But ISNULL is not supported in Firebird.
The underlying table of the view has PK which is also marked as #PK_GEN# . And I'm able to add this table to my model.

So my question is: Does anyone know how to add a view to a EF6 model in designer?

BR
C

Re: [Firebird-net-provider] Firebird EF6 DDEX adding Views

[Christoph G. <chr...@st...>]

*         In designer I make "Update from database"

*         View is not added, but the error message is shown.

*         No entity is added under the myViewModel.tt file (in the VS solution). But there is an entity of the previous added table.
Also under myViewModel.Context.tt\Entities there is no view entity added. There is no myview.cs class. There is one for the table.

*         I now save the EDMX file and open it as XML. I'm uncommenting the block for the view (and deleting the error message which is part of the commented block.

*         Adding part for "<Key>" referencing one of the columns of the view.

*         Saving the EDMX again.

*         Now I can't open it anymore in the designer.

*         In XML mode for EDMX file I get the message: "Entity type [myview] has no entity set".

That's what I meant: I know would have to create (and update) the entities manually.

BR
C



No. It's already there.
--
Mgr. Jiří Činčura
Independent IT Specialist



Thank you for your reply. I found that information already. I also tried that already. But I then would have to add Entities manually, right? Or did I miss a step? This makes it very "not handsome" to use because during development process the views are changing a lot. Is there any other solution? Like marking columns in the database with #PK_GEN# or something similar?

BR
C


http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/



--

Mgr. Jiří Činčura

Independent IT Specialist



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

Dive into the World of Parallel Programming. The Go Parallel Website,

sponsored by Intel and developed in partnership with Slashdot Media, is your

hub for all things parallel software development, from weekly thought

leadership blogs to news, videos, case studies, tutorials and more. Take a

look and join the conversation now. http://goparallel.sourceforge.net/

_______________________________________________

Firebird-net-provider mailing list

Fir...@li...

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


845...@S0...

Von: Christoph Gasser
Gesendet: Samstag, 31. Jänner 2015 12:47
An: 'fir...@li...'
Betreff: Firebird EF6 DDEX adding Views

I'm using VS 2012, Firebird 2.5, EF6. When trying to add a View to my model in the designer I get the message:

"The table/view 'Firebird.Firebird.V_MYVIEW' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it."

That's because EF need a PK for every table / view. When using MSSQL there is an approach using ISNULL in the view to be able to add the view to the model. But ISNULL is not supported in Firebird.
The underlying table of the view has PK which is also marked as #PK_GEN# . And I'm able to add this table to my model.

So my question is: Does anyone know how to add a view to a EF6 model in designer?

BR
C

Re: [Firebird-net-provider] Firebird EF6 DDEX adding Views

[Jiří Č. <ji...@ci...>]

> But I then would have to add Entities manually, right? 

No. It's already there.
-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] Firebird EF6 DDEX adding Views

[Christoph G. <chr...@st...>]

Thank you for your reply. I found that information already. I also tried that already. But I then would have to add Entities manually, right? Or did I miss a step? This makes it very "not handsome" to use because during development process the views are changing a lot. Is there any other solution? Like marking columns in the database with #PK_GEN# or something similar?

BR
C


http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/



--

Mgr. Jiří Činčura

Independent IT Specialist



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

Dive into the World of Parallel Programming. The Go Parallel Website,

sponsored by Intel and developed in partnership with Slashdot Media, is your

hub for all things parallel software development, from weekly thought

leadership blogs to news, videos, case studies, tutorials and more. Take a

look and join the conversation now. http://goparallel.sourceforge.net/

_______________________________________________

Firebird-net-provider mailing list

Fir...@li...

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


845...@S0...

Von: Christoph Gasser
Gesendet: Samstag, 31. Jänner 2015 12:47
An: 'fir...@li...'
Betreff: Firebird EF6 DDEX adding Views

I'm using VS 2012, Firebird 2.5, EF6. When trying to add a View to my model in the designer I get the message:

"The table/view 'Firebird.Firebird.V_MYVIEW' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it."

That's because EF need a PK for every table / view. When using MSSQL there is an approach using ISNULL in the view to be able to add the view to the model. But ISNULL is not supported in Firebird.
The underlying table of the view has PK which is also marked as #PK_GEN# . And I'm able to add this table to my model.

So my question is: Does anyone know how to add a view to a EF6 model in designer?

BR
C

Re: [Firebird-net-provider] Firebird EF6 DDEX adding Views

[Jiří Č. <ji...@ci...>]

http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/

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

[Firebird-net-provider] Firebird EF6 DDEX adding Views

[Christoph G. <chr...@st...>]

I'm using VS 2012, Firebird 2.5, EF6. When trying to add a View to my model in the designer I get the message:

"The table/view 'Firebird.Firebird.V_MYVIEW' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it."

That's because EF need a PK for every table / view. When using MSSQL there is an approach using ISNULL in the view to be able to add the view to the model. But ISNULL is not supported in Firebird.
The underlying table of the view has PK which is also marked as #PK_GEN# . And I'm able to add this table to my model.

So my question is: Does anyone know how to add a view to a EF6 model in designer?

BR
C

Re: [Firebird-net-provider] Decorators for FbConnectionString properties

[Jiří Č. <ji...@ci...>]

Sure. Go ahead. Once done create PR on GitHub and that’s it.

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

From: Hernan Martinez [mailto:her...@ob...]
Sent: Tuesday, January 27, 2015 5:06 PM
To: Fir...@li...
Subject: [Firebird-net-provider] Decorators for FbConnectionString properties

Hi dev(s)!

One nice addition would be to decorate FbConnectionString public properties with Attribute decorators like Category, Description, Editor, DefaultValue, etc.
It’s a fairly easy mod (if only with English texts) and I can do it by myself. Would you accept patches? Do you expect any problem with regards to Mono?

Regards,

Hernán Martínez-Foffani
_________________________
OBI - on board intelligence
Director de Tecnología
her...@ob...<mailto:her...@ob...>

[Firebird-net-provider] Decorators for FbConnectionString properties

[Hernan M. <her...@ob...>]

Hi dev(s)!

One nice addition would be to decorate FbConnectionString public properties with Attribute decorators like Category, Description, Editor, DefaultValue, etc.
It’s a fairly easy mod (if only with English texts) and I can do it by myself. Would you accept patches? Do you expect any problem with regards to Mono?

Regards,

Hernán Martínez-Foffani
_________________________ 
OBI - on board intelligence
Director de Tecnología
her...@ob... <mailto:her...@ob...>

[Firebird-net-provider] RES: RES: RES: RES: Error reading data from the connection

[Nicolas F. T. <nft...@ho...>]

Got'it, tanks :)

 

De: Gerdus van Zyl [mailto:ger...@gm...] 
Enviada em: terça-feira, 27 de janeiro de 2015 11:12
Para: For users and developers of the Firebird .NET providers
Assunto: Re: [Firebird-net-provider] RES: RES: RES: Error reading data from the connection

 

The default for ConnectionLifeTime is 0 and thus connections are never released/closed if pooling is enabled. 

Try setting ConnectionLifeTime to 60 (is in seconds) and you might get results more inline with what you expect.

 

On Tue, Jan 27, 2015 at 2:42 PM, Nicolas F. Timmers <nft...@ho... <mailto:nft...@ho...> > wrote:

I do not modify these values even inform them in the connection string, I'm wondering because he is giving this error even after hours after the User no longer used

 

De: Gerdus van Zyl [mailto:ger...@gm... <mailto:ger...@gm...> ] 
Enviada em: terça-feira, 27 de janeiro de 2015 10:04
Para: For users and developers of the Firebird .NET providers
Assunto: Re: [Firebird-net-provider] RES: RES: Error reading data from the connection

 

What is the values on your connection string for 
ConnectionLifeTime

and
MinPoolSize
?

 

On Tue, Jan 27, 2015 at 1:57 PM, Nicolas F. Timmers <nft...@ho... <mailto:nft...@ho...> > wrote:

I think probably the application pool is not running again for this case see
I have.

A customer connected early on the database but is not used more for the day
and the next morning the error occurred and that the firebird was only
stopped night, I believe that the application pool is being never finalized.

 


------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-net-provider mailing list
Fir...@li... <mailto:Fir...@li...> 
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider




-- 

------------------------------------------------------------------------
Gerdus van Zyl

www.infireal.com <http://www.infireal.com> 

Re: [Firebird-net-provider] RES: RES: RES: Error reading data from the connection

[Gerdus v. Z. <ger...@gm...>]

The default for ConnectionLifeTime is 0 and thus connections are never
released/closed if pooling is enabled.
Try setting ConnectionLifeTime to 60 (is in seconds) and you might get
results more inline with what you expect.

On Tue, Jan 27, 2015 at 2:42 PM, Nicolas F. Timmers <nft...@ho...>
wrote:

> I do not modify these values even inform them in the connection string,
> I'm wondering because he is giving this error even after hours after the
> User no longer used
>
>
>
> *De:* Gerdus van Zyl [mailto:ger...@gm...]
> *Enviada em:* terça-feira, 27 de janeiro de 2015 10:04
> *Para:* For users and developers of the Firebird .NET providers
> *Assunto:* Re: [Firebird-net-provider] RES: RES: Error reading data from
> the connection
>
>
>
> What is the values on your connection string for
> ConnectionLifeTime
>
> and
> MinPoolSize
> ?
>
>
>
> On Tue, Jan 27, 2015 at 1:57 PM, Nicolas F. Timmers <nft...@ho...>
> wrote:
>
> I think probably the application pool is not running again for this case
> see
> I have.
>
> A customer connected early on the database but is not used more for the day
> and the next morning the error occurred and that the firebird was only
> stopped night, I believe that the application pool is being never
> finalized.
>
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is
> your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>


-- 
------------------------------------------------------------------------
Gerdus van Zyl
www.infireal.com

[Firebird-net-provider] RES: RES: RES: Error reading data from the connection

[Nicolas F. T. <nft...@ho...>]

I do not modify these values even inform them in the connection string, I'm wondering because he is giving this error even after hours after the User no longer used

 

De: Gerdus van Zyl [mailto:ger...@gm...] 
Enviada em: terça-feira, 27 de janeiro de 2015 10:04
Para: For users and developers of the Firebird .NET providers
Assunto: Re: [Firebird-net-provider] RES: RES: Error reading data from the connection

 

What is the values on your connection string for 
ConnectionLifeTime

and
MinPoolSize
?

 

On Tue, Jan 27, 2015 at 1:57 PM, Nicolas F. Timmers <nft...@ho... <mailto:nft...@ho...> > wrote:

I think probably the application pool is not running again for this case see
I have.

A customer connected early on the database but is not used more for the day
and the next morning the error occurred and that the firebird was only
stopped night, I believe that the application pool is being never finalized.

 

Re: [Firebird-net-provider] RES: Error reading data from the connection

[Michał Z. <mz...@e-...>]

Maybe a better approach would be to catch the exception when writing to a
socket and in that case flush the pool?
Polling on every connection every 2 secs is a major overhead (especially
for server uses with many connections to multiple databases).

Cheers!
Michał

2015-01-27 12:56 GMT+01:00 Gerdus van Zyl <ger...@gm...>:

> The msdn docs do state: "The connection pooler removes a connection from
> the pool after it has been idle for a long time, *or if the pooler
> detects that the connection with the server has been severed*."
> So other database providers probably check periodically for broken
> connections.
>
> however the docs also say "If a connection exists to a server that has
> disappeared, this connection can be drawn from the pool *even if the
> connection pooler has not detected the severed connection and marked it as
> invalid. *This is the case because the overhead of checking that the
> connection is still valid would eliminate the benefits of having a pooler
> by causing another round trip to the server to occur. *When this occurs,
> the first attempt to use the connection will detect that the connection has
> been severed, and an exception is thrown.*"
>
> See attached patch(+ test program) that adds a connection check on idle
> connections in the connection pool cleanup code that is run every 2 seconds
> to remove old connections.
> Even with the patch if the server goes away between checks you can still
> get a broken connection as is the case with other database providers.
>
> This does cause a small network request for each idle connection in the
> pool every 2 seconds so don't know if this patch would be suitable for
> public use.
>
> On Mon, Jan 26, 2015 at 3:32 PM, Luciano Mendes <lur...@gm...>
> wrote:
>
>> Let me copy, once again, the source code of the SW that is not work. Note
>> the
>> I am always open the Polling connection according the documentation (
>> https://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.100).aspx ) and it
>> was broken since the version 4.6.0.0:
>>
>> ===========================
>> using FirebirdSql.Data.FirebirdClient;
>>
>> public static bool ExecuteCommand(string DML)
>>         {
>>             using (FbConnection fbConnection = new
>> FbConnection(connectionString()))
>>             using (FbCommand fbCommand = new FbCommand(DML, fbConnection))
>>                 try
>>                 {
>>                     Cursor.Current = Cursors.WaitCursor;
>>                     fbCommand.Connection.Open();
>>                     fbCommand.ExecuteNonQuery();
>>                     return true;
>>                 }
>>                 catch (FbException ex)
>>                 {
>>                     return false;
>>                 }
>>                 finally
>>                 {
>>                     Cursor.Current = Cursors.Default;
>>                 }
>>         }
>>
>>
>>
>> --
>> View this message in context:
>> http://firebird.1100200.n4.nabble.com/Error-reading-data-from-the-connection-tp4638893p4638932.html
>> Sent from the firebird-net-provider mailing list archive at Nabble.com.
>>
>>
>> ------------------------------------------------------------------------------
>> Dive into the World of Parallel Programming. The Go Parallel Website,
>> sponsored by Intel and developed in partnership with Slashdot Media, is
>> your
>> hub for all things parallel software development, from weekly thought
>> leadership blogs to news, videos, case studies, tutorials and more. Take a
>> look and join the conversation now. http://goparallel.sourceforge.net/
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>
>
> --
> ------------------------------------------------------------------------
> Gerdus van Zyl
> www.infireal.com
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is
> your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>

Re: [Firebird-net-provider] RES: RES: Error reading data from the connection

[Gerdus v. Z. <ger...@gm...>]

What is the values on your connection string for
ConnectionLifeTime
and
MinPoolSize
?

On Tue, Jan 27, 2015 at 1:57 PM, Nicolas F. Timmers <nft...@ho...>
wrote:

> I think probably the application pool is not running again for this case
> see
> I have.
>
> A customer connected early on the database but is not used more for the day
> and the next morning the error occurred and that the firebird was only
> stopped night, I believe that the application pool is being never
> finalized.
>

[Firebird-net-provider] RES: RES: Error reading data from the connection

[Nicolas F. T. <nft...@ho...>]

I think probably the application pool is not running again for this case see
I have.

A customer connected early on the database but is not used more for the day
and the next morning the error occurred and that the firebird was only
stopped night, I believe that the application pool is being never finalized.

-----Mensagem original-----
De: Luciano Mendes [mailto:lur...@gm...] 
Enviada em: segunda-feira, 26 de janeiro de 2015 11:32
Para: fir...@li...
Assunto: Re: [Firebird-net-provider] RES: Error reading data from the
connection

Let me copy, once again, the source code of the SW that is not work. Note
the I am always open the Polling connection according the documentation (
https://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.100).aspx ) and it
was broken since the version 4.6.0.0:

===========================
using FirebirdSql.Data.FirebirdClient; 

public static bool ExecuteCommand(string DML) 
        { 
            using (FbConnection fbConnection = new
FbConnection(connectionString())) 
            using (FbCommand fbCommand = new FbCommand(DML, fbConnection)) 
                try 
                { 
                    Cursor.Current = Cursors.WaitCursor; 
                    fbCommand.Connection.Open(); 
                    fbCommand.ExecuteNonQuery(); 
                    return true; 
                } 
                catch (FbException ex) 
                { 
                    return false; 
                } 
                finally 
                { 
                    Cursor.Current = Cursors.Default; 
                } 
        } 



--
View this message in context:
http://firebird.1100200.n4.nabble.com/Error-reading-data-from-the-connection
-tp4638893p4638932.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

----------------------------------------------------------------------------
--
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] RES: Error reading data from the connection

[Gerdus v. Z. <ger...@gm...>]

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using FirebirdSql.Data.FirebirdClient;
using System.ServiceProcess;

namespace ConnectionPoolTest
{
    class Program
    {

        static void StopFirebirdService()
        {
            var sc = new ServiceController("FirebirdServersifirebird");
            Console.WriteLine("Stopping...");
            sc.Stop();
            sc.WaitForStatus(ServiceControllerStatus.Stopped);
            Console.WriteLine("Stopped");
        }

        static void StartFirebirdService()
        {
            var sc = new ServiceController("FirebirdServersifirebird");
            Console.WriteLine("Starting...");
            sc.Start();
            sc.WaitForStatus(ServiceControllerStatus.Running );
            Console.WriteLine("Started");
        }

        static void Main(string[] args)
        {
            Console.WriteLine("[Connection pool test]");

            var csb = new FbConnectionStringBuilder();
            csb.DataSource = "localhost";
            csb.Port = 55504;
            csb.Database  = "pooltest.fdb";
            csb.UserID = "SYSDBA";
            csb.Password = "masterke";
            csb.Pooling = true;
            csb.MinPoolSize = 0;
            csb.MaxPoolSize = 100;
            csb.ConnectionLifeTime = 500;            

            FbConnection.CreateDatabase(csb.ToString(), true);

            using (var con = new FbConnection(csb.ToString()))
            {
                con.Open();
                using (var trans = con.BeginTransaction())
                {
                    using (var cmd = new FbCommand("select 1 from rdb$database", con, trans))
                    {
                        cmd.ExecuteNonQuery();
                    }
                }
            }
            
            StopFirebirdService();
            System.Threading.Thread.Sleep(5 * 1000);
            StartFirebirdService();

            using (var con = new FbConnection(csb.ToString()))
            {
                con.Open();
                using (var trans = con.BeginTransaction())
                {
                    using (var cmd = new FbCommand("select 1 from rdb$database", con, trans))
                    {
                        cmd.ExecuteNonQuery();
                    }
                }
            }
            
            Console.WriteLine("Press the any key...");
            Console.ReadKey();
        }
    }
}

Re: [Firebird-net-provider] RES: Error reading data from the connection

[Luciano M. <lur...@gm...>]

Let me copy, once again, the source code of the SW that is not work. Note the
I am always open the Polling connection according the documentation (
https://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.100).aspx ) and it
was broken since the version 4.6.0.0:

===========================
using FirebirdSql.Data.FirebirdClient; 

public static bool ExecuteCommand(string DML) 
        { 
            using (FbConnection fbConnection = new
FbConnection(connectionString())) 
            using (FbCommand fbCommand = new FbCommand(DML, fbConnection)) 
                try 
                { 
                    Cursor.Current = Cursors.WaitCursor; 
                    fbCommand.Connection.Open(); 
                    fbCommand.ExecuteNonQuery(); 
                    return true; 
                } 
                catch (FbException ex) 
                { 
                    return false; 
                } 
                finally 
                { 
                    Cursor.Current = Cursors.Default; 
                } 
        } 



--
View this message in context: http://firebird.1100200.n4.nabble.com/Error-reading-data-from-the-connection-tp4638893p4638932.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

Re: [Firebird-net-provider] RES: Error reading data from the connection

[Jiří Č. <ji...@ci...>]

> I am still trying to understand why it is being considered "expected
> behavior" if due to this issue all of my 122 clients need to be re-start
> their application every time the Firebird Server is Stop/Start or every
> time that we have any network issue.

You live in a dream. There was never connection resiliency. If the connection is broken you need to reopen it.
-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] RES: Error reading data from the connection

[Luciano M. <lur...@gm...>]

Don't change anything in your SW because this is not as issue of it.
Use the ADO.NET Provider v.4.5.2.0 that is the lastest version that works
fine.

I am still trying to understand why it is being considered "expected
behavior" if due to this issue all of my 122 clients need to be re-start
their application every time the Firebird Server is Stop/Start or every time
that we have any network issue.



--
View this message in context: http://firebird.1100200.n4.nabble.com/Error-reading-data-from-the-connection-tp4638893p4638930.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

[Firebird-net-provider] RES: Error reading data from the connection

[Nicolas F. T. <nft...@ho...>]

I have other applications in use with Postgree and SQL Server, and work
perfectly in Firebird do not understand why it should be different.

-----Mensagem original-----
De: Luciano Mendes [mailto:lur...@gm...] 
Enviada em: domingo, 25 de janeiro de 2015 10:17
Para: fir...@li...
Assunto: Re: [Firebird-net-provider] Error reading data from the connection

Well I opened the bug http://tracker.firebirdsql.org/browse/DNET-585 but it
was closed as Won't Fix :(



--
View this message in context:
http://firebird.1100200.n4.nabble.com/Error-reading-data-from-the-connection
-tp4638893p4638927.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

----------------------------------------------------------------------------
--
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider