[Firebird-net-provider] [FB-Tracker] Created: (DNET-549) When you change culture of application while it's connected to firebird database, the connection won't be returned into pool.

[Lukáš V. (J. <tr...@fi...>]

When you change culture of application while it's connected to firebird database, the connection won't be returned into pool.
-----------------------------------------------------------------------------------------------------------------------------

                 Key: DNET-549
                 URL: http://tracker.firebirdsql.org/browse/DNET-549
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, ASP.NET Providers
    Affects Versions: 4.1.0.0
         Environment:  Fb .NET Provider version 4.1.0.0 and .NET FW version: 4.0.30319 and ASP .NET 4.0.30319.34009. OS: Windows 8.1 64bit
            Reporter: Lukáš Vykydal
            Assignee: Jiri Cincura


i found interesting bug. When you change culture of application while it's connected to firebird database, the connection won't be returned into pool.

Here is example code (from Page_Load) :
       this.Culture = "en-GB";
        FbConnection fbc = new FbConnection("Database=d:/database.fdb;DataSource=localhost;User=sysdba;Password=masterkey;Dialect=1;Charset=UTF8;Pooling=true;MinPoolSize=0;MaxPoolSize=10;Connection lifetime=30;");
        fbc.Open();

        this.Culture = "cs-CZ";

//        this.Culture = "en-GB";    When you change it back everything will be OK

        fbc.Close();

this code will fail after 10 calls on "System.InvalidOperationException: Connection pool is full". Its thrown from "FirebirdSql.Data.FirebirdClient.Pool.CreateNewConnectionIfPossibleImpl".

After quick look into the source code i think that problem is in generating NormalizedConnectionString (FbConnectgionString.cs:233). This code is probably culture dependent.

I'm using  Fb .NET Provider version 4.1.0.0 and .NET FW version: 4.0.30319 and ASP .NET 4.0.30319.34009

-- 
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