Re: [Firebird-net-provider] connection pooling - connection not closing after lifetime over

2012-02-19 Thread Jiri Cincura
On Mon, Jul 25, 2011 at 11:04 AM, Jiri Cincura wrote: > Might be a bug. I'll look at it. Bug. Fixed now. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Virtualizati

Re: [Firebird-net-provider] connection pooling - connection not closing after lifetime over

2011-07-25 Thread Jiri Cincura
On Mon, Jul 25, 2011 at 10:45, Gerdus van Zyl wrote: > Is this a bug or is it by design? Might be a bug. I'll look at it. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

[Firebird-net-provider] connection pooling - connection not closing after lifetime over

2011-07-25 Thread Gerdus van Zyl
I have set Pooling = True and ConnectionLifeTime = 10 in my connection string. The expected result would be that 10 seconds after the connection is last used the connection is closed. Unfortunately looking at the connections using Database Workbench the connection seems to stay open till program te

Re: [Firebird-net-provider] connection pooling in amultithreadingenvironment

2010-03-22 Thread Bruce Tiffany
irebird .NET providers Subject: Re: [Firebird-net-provider] connection pooling in amultithreadingenvironment Use a connection within a using clause. using (FbConnection connection = OpenConnection()) {

Re: [Firebird-net-provider] connection pooling in a multithreadingenvironment

2010-03-20 Thread Gareth
Use a connection within a using clause. using (FbConnection connection = OpenConnection()) { using (FbCommand command = new FbCommand(commandName, connection))

Re: [Firebird-net-provider] connection pooling in a multithreadingenvironment

2010-03-19 Thread Jiri Cincura
On Fri, Mar 19, 2010 at 21:39, Bruce Tiffany wrote: > Yes, we can simulate it consistently by using multithreading to simulate > simultaneous users in a web environment.  It bombs every time. Are you using one connection on more threads (simultaneously)? > The deal was we were having lingering

Re: [Firebird-net-provider] connection pooling in a multithreadingenvironment

2010-03-19 Thread Bruce Tiffany
{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{} -Original Message- From: Jiri Cincura [mailto:[email protected]] Sent: Saturday, February 20, 2010 9:27 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] connection pooling in a multithreadingenvironment On Fri, F

Re: [Firebird-net-provider] connection pooling in a multithreading environment

2010-02-20 Thread Jiri Cincura
On Fri, Feb 5, 2010 at 03:17, Bruce Tiffany wrote: > We encountered an error in FB 2.1.0 and 2.5.1 in some web applications: Is the application run under IIS? > Similar errors were occurring too frequently from various Firebird Does it mean you can simulate it consistently? > Specifically, the

[Firebird-net-provider] connection pooling in a multithreading environment

2010-02-09 Thread Bruce Tiffany
We encountered an error in FB 2.1.0 and 2.5.1 in some web applications: Message: Object reference not set to an instance of an object. Source: FirebirdSql.Data.FirebirdClient Stack trace: at FirebirdSql.Data.FirebirdClient.FbCommand.RollbackIm

[Firebird-net-provider] connection pooling in a multithreading environment

2010-02-04 Thread Bruce Tiffany
We encountered an error in FB 2.1.0 and 2.5.1 in some web applications: Message: Object reference not set to an instance of an object. Source: FirebirdSql.Data.FirebirdClient Stack trace: at FirebirdSql.Data.FirebirdClient.FbCommand.RollbackImplici

Re: [Firebird-net-provider] Connection Pooling Options With Firebird

2008-01-07 Thread Dean Harding
John Martinez wrote: > connectionString= > > "userid=SYSDBA;password=masterkey;database=c:\mydb.fdb;datasource=Localhost;port=3050;charset=NONE;Role=;Connection > > lifetime=0;Connection > timeout=15;Pooling=True;MinPoolSize=10;MaxPoolSize=20;Connection > Lifetime=5;dialect=1;Packet Si

[Firebird-net-provider] Connection Pooling Options With Firebird

2008-01-07 Thread John Martinez
I'm new to .NET, and only have about 6 months of web application development, so any help or push in the right direction is appreciated. I've got a web application developed in RAD Studio 2007, using Delphi for .NET and am seeking the best practices for managing the connections. Several users w

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Phillip M. Day
Thank you very much for your help. Phillip -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Tuesday, October 09, 2007 5:52 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Connection

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Jiri Cincura
On 10/9/07, Phillip M. Day <[EMAIL PROTECTED]> wrote: > So, if I understand this correctly.. > > For each request that my .Net application processes, I should create a > new FBConnection object with the connection string I am currently using. > My current code only creates the FBConnection for each

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Phillip M. Day
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Tuesday, October 09, 2007 2:38 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Connection Pooling On 10/9/07, Phillip M. Day <[EMAIL PROTECTED]> wrote: > Do you mind po

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Jiri Cincura
On 10/9/07, Phillip M. Day <[EMAIL PROTECTED]> wrote: > Do you mind pointing me towards a sample project or code that I can > reference? Try to run one and more instances and see how many connections you see in DB when pooling is true and when false. class Program { static void Main(s

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Phillip M. Day
.NET providers Subject: Re: [Firebird-net-provider] Connection Pooling On 10/9/07, Phillip M. Day <[EMAIL PROTECTED]> wrote: > I guess that is what I am asking. How do I use a connection pool? You already has "Pooling=true" in connection string. So just open/close connections

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Jiri Cincura
On 10/9/07, Phillip M. Day <[EMAIL PROTECTED]> wrote: > I guess that is what I am asking. How do I use a connection pool? You already has "Pooling=true" in connection string. So just open/close connections where you need. Try to open at least as possible and close as fast as possbile. Provider wi

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Phillip M. Day
: [Firebird-net-provider] Connection Pooling Why not to create connection(s) where you need and use connection pool? IMO saving object to the session is a really bad idea. -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Connection Pooling

2007-10-09 Thread Jiri Cincura
Why not to create connection(s) where you need and use connection pool? IMO saving object to the session is a really bad idea. -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com --

[Firebird-net-provider] Connection Pooling

2007-10-09 Thread Phillip Day
I am fairly new to .Net and would like to understand a "best practice" of using Firebird in my .Net project. I have a web application that we are converting from CGI to .NET. The CGI application establishes a connection for every request. When architecting the .Net application, would the best

Re: [Firebird-net-provider] Connection pooling in embedded

2007-02-08 Thread Jiri Cincura
Yes, it does. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology

[Firebird-net-provider] Connection pooling in embedded

2007-02-07 Thread Vlad Orlovsky
Hi All, Does it make sense to set Pooling and MaxPoolSize properties for embedded? cb = new FbConnectionStringBuilder(); cb.ServerType = FbServerType.Embedded; cb.Database = PATH2DB; cb.Charset = "UNIC

Re: [Firebird-net-provider] Connection Pooling Problem

2006-04-04 Thread Eric Walmsley
Hi,  I did have Pooling=true when I ran the example and got the 10 connections. If I disable Pooling, then everything works, but the app runs a lot slower. Cheers Eric Carlos Guzmán Álvarez wrote: Hello: This connection string has pooling disabled ... I will try to make a tes

Re: [Firebird-net-provider] Connection Pooling Problem

2006-04-04 Thread Carlos Guzmán Álvarez
Hello: value="User=SYSDBA;Password=masterkey;Database=C:\ChARMTeamData\ChARM.fdb;DataSource=localhost;Charset=NONE;Pooling=false;MinPoolSize=10;MaxPoolSize=200;Connection Lifetime=5;ServerType=0" /> This connection string has pooling disabled ... I will try to make a test to see if there any pro

[Firebird-net-provider] Connection Pooling Problem

2006-04-03 Thread Eric Walmsley
Hi, I'm using version 1.7.1 and trying to use connection pooling, but the connections just grow and grow until I get a timeout. I've looked on the web and know about using the same connection string, but it doesn't seem to work. in Web.Config, I have: value="User=SYSDBA;Password=masterkey;D