Hennadii (JIRA | 19 Dec 15:21 2014

[FB-Tracker] Created: (DNET-582) Random bug in finalizing DbCommands

Random bug in finalizing DbCommands
-----------------------------------

                 Key: DNET-582
                 URL: http://tracker.firebirdsql.org/browse/DNET-582
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.5.2.0
         Environment: Windows Server 2008 R2. firebird 2.5.3 x64 embedded
            Reporter: Hennadii
            Assignee: Jiri Cincura

Several times I've experienced randomly reproduced bug. It has some different symptoms: OOM, unhandled
crash and so on.
But all this times I had the same stack:
000000001b56edb0 00000000773a186a [FaultingExceptionFrame: 000000001b56edb0] 
000000001b56f300 000007fe9a9920b0 FirebirdSql.Data.FirebirdClient.FbCommand.Release()
[*\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs  <at>  821]
000000001b56f340 000007fe9a9a47f5 FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean)
[*\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs  <at>  384]
000000001b56f3a0 000007fef71cc8da System.ComponentModel.Component.Finalize()
000000001b56f798 000007fef9479d56 [DebuggerU2MCatchHandlerFrame: 000000001b56f798] 

It is locally built library so I'll provide lines referred above:
FbCommand.cs  <at>  821
            if (this.connection != null && this.connection.State == ConnectionState.Open)
            {
                this.connection.InnerConnection.RemovePreparedCommand(this);
            }
(Continue reading)

André Ziegler (JIRA | 8 Dec 09:02 2014

[FB-Tracker] Created: (DNET-581) DDEX provider is lost after updating an extension in VS2012

DDEX provider is lost after updating an extension in VS2012
-----------------------------------------------------------

                 Key: DNET-581
                 URL: http://tracker.firebirdsql.org/browse/DNET-581
             Project: .NET Data provider
          Issue Type: Bug
          Components: DDEX Provider
         Environment: Windows 8 (x64), VS2012 Upd4
            Reporter: André Ziegler
            Assignee: Jiri Cincura

When I install an update to extension in VS2012 the DDEX provider is lost:

https://entityframework.codeplex.com/discussions/571855

Using ProcessMonitor I see that the VS writes NEW keys (REG_CREATED_NEW_KEY) under

 HKCU\Software\Microsoft\VisualStudio\11.0_Config\DataProviders 

for OleDb, SQLServer, Oracle, SQLCe, but I can't see Firebird. Why does this happen? I have to run the setup
again and repair the DDEX provider everything this happens again.

--

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

(Continue reading)

Jar Jar Binks (JIRA | 3 Dec 10:38 2014

[FB-Tracker] Created: (DNET-580) Need Dialect 1 Support in Entity Framework 6.x

Need Dialect 1 Support in Entity Framework 6.x
----------------------------------------------

                 Key: DNET-580
                 URL: http://tracker.firebirdsql.org/browse/DNET-580
             Project: .NET Data provider
          Issue Type: New Feature
          Components: Entity Framework support
    Affects Versions: 4.5.2.0
            Reporter: Jar Jar Binks
            Assignee: Jiri Cincura

I need Dialect 1 Support for the Entity Framework 6.x.

I have create a new Fork to implement this feature, But it is implemented with preprocessor directives. I
don't found a point to switch it at runtime.

--

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

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
(Continue reading)

Toni Martir (JIRA | 2 Dec 18:42 2014

[FB-Tracker] Created: (DNET-579) Reading lot of string values from database (fetching string values) performance is poor

Reading lot of string values from database (fetching string values) performance is poor
---------------------------------------------------------------------------------------

                 Key: DNET-579
                 URL: http://tracker.firebirdsql.org/browse/DNET-579
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 4.5.0.0
         Environment: Any
            Reporter: Toni Martir
            Assignee: Jiri Cincura

When fetching rows, reading string column values calls  public static Charset GetCharset(string charsetName)

Replacing the sequential search with a dictionary there is a 80% performance gain when reading strings:

        private static Dictionary<string, Charset> supportedCharsetsNames;

		public static Charset GetCharset(string charsetName)
		{
            return supportedCharsetsNames[charsetName];

		}

And inside InitializeSupportedCharsets:

            supportedCharsetsNames = new Dictionary<string, Charset>();
            foreach (Charset ncharset in charsets)
            {
(Continue reading)

Paul Dryden | 1 Dec 00:44 2014
Picon

visual studion 2010 and producing an edmx file from database

I have several computers that I manage where I can produce and edmx file from a firebird database without problem. However, my main development computer isn't working as it should. I can start a project in VS, then add new item, data, entity data framework. The firebird connection capability is present and I can point to  a database, then I am show the database objects. I selected the tables, then next button. But what is produced is basically an empty edmx file, it has the different sections but no data about the database.

I have tried to set this Windows 7 machine up like one of the machines that is working using three configuration items:

1)  gac entry:
 FirebirdSql.Data.FirebirdClient, Version=4.5.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL

2)Framework machine.config entry:
  <system.data>
    <DbProviderFactories>
       <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=4.5.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/></DbProviderFactories>
  </system.data>

3) Registry data
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\10.0\DataProviders\{92421248-F044-483A-8237-74C7FBC62971} and
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\10.0\DataSources\{2979569E-416D-4DD8-B06B-EBCB70DE7A4E} match on both computers.

Can anyone suggest a way to track this down? I got so frustrated that I rebuilt the dev machine and set it up as described above, but to no avail. Is there a package missing in my VS2010?

pablo en Utah


 

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiri Cincura (JIRA | 27 Nov 12:50 2014

[FB-Tracker] Created: (DNET-578) For [VAR]CHAR constants use real length if there's none from facet

For [VAR]CHAR constants use real length if there's none from facet
------------------------------------------------------------------

                 Key: DNET-578
                 URL: http://tracker.firebirdsql.org/browse/DNET-578
             Project: .NET Data provider
          Issue Type: Improvement
          Components: Entity Framework support
    Affects Versions: 4.5.2.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor

--

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

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Joseph Martinez | 25 Nov 23:48 2014

Special symbols getting converted to something else

I'm having a strange problem.  When special symbols are stored in my database, if the record is edited, it gets written back to the database as a different symbol or several symbols.  Here's an example:

I have a Firebird application that uses C++ and IBObjects.  If I enter or paste into a database field some text containing the Trademark symbol ™ (typed alt-0153.  Bytes are e2 84 a2), it shows correctly in the database, on the screen, etc.

Now, if I access the same database record using .NET, the Firebird .NET provider, and Entity Framework, and edit that record, even if I don't modify the field containing the trademark symbol, when I save the record, it writes the trademark symbol back as: â„¢ (bytes are c3 a2 e2 80 9e c2 a2).

Here is the code that I'm using:

PRODUCT p = db.PRODUCTS.FirstOrDefault<PRODUCT>(pp => pp.PRODBARCODE == ecp.PRODBARCODE && pp.STOREID == _storeid);
p.PRODWEBDIRTY = "F";
db.Entry(p).State = EntityState.Modified;
db.SaveChanges();

Note that PRODWEBDIRTY is not the field containing the trademark symbol.  I guess it's just writing back the entire record to the database, but with the special characters converted.

Why does it do this?  How can I prevent it?

-Joe
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Pascal (JIRA | 24 Nov 10:34 2014

[FB-Tracker] Created: (DNET-577) The utilisation of parameters writes in the standard output so the performances are considerably descreased

The utilisation of parameters writes in the standard output so the performances are considerably descreased
-----------------------------------------------------------------------------------------------------------

                 Key: DNET-577
                 URL: http://tracker.firebirdsql.org/browse/DNET-577
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.5.2.0
         Environment: Client application runs on a Windows 7 64 bits with FirebirdSql.Data.FirebirdClient.dll
4.5.2.0 (also tested with 2.7.5.0 and there's the same issue).

Firebird 2.1.4.18393 (Win32) on a Windows Server 2003 SP2 64 bits.
            Reporter: Pascal
            Assignee: Jiri Cincura
            Priority: Blocker

To insert datas in a Firebird database, I use a FbCommand with parameters and transactions to be as quick as possible.
But the FbCommand writes in the standard ouput all values of all parameters. So when with anoter database
the job lasts one hour, with Firebird it lasts ten hours.

It's very important for me to get a fix and I can't go to production with this low performances.

The code is made to work with SQL Server, Oracle, MySQL, PostgreSQL and Firebird.

This is an example of code to reproduce:

       public void InsererEnregistrement(string nomTable)
        {
            const IsolationLevel isolationLevel = IsolationLevel.ReadUncommitted;
            const int nbreLigneTotal = 1000;

            var parametres = new List<string>();

            for (int i = 1; i <= 50; i++)
                parametres.Add(" <at> p" + i);

            var commande = String.Format("INSERT INTO {0} VALUES (" + parametres.Aggregate((a, b) => a + ", " + b) + ")", nomTable);

            using (var connexion = new FbConnection())
            {
                connexion.ConnectionString = ConnectionStringBuilder.ConnectionString;

                connexion.Open();

                using (var command = new FbCommand())
                {                  
                    command.Connection = connexion;
                    command.CommandText = commande;

                    DbTransaction transaction = connexion.BeginTransaction(isolationLevel);

                    command.Transaction = transaction;

                    for (int i = 1; i <= 25; i++)
                    {
                        var parametre = new FbParameter();
                        parametre.ParameterName = " <at> p" + i;
                        parametre.DbType = DbType.Int32;
                        command.Parameters.Add(parametre);
                    }

                    for (int i = 26; i <= 50; i++)
                    {
                        var parametre = new FbParameter();
                        parametre.ParameterName = " <at> p" + i;
                        parametre.DbType = DbType.String;
                        command.Parameters.Add(parametre);
                    }

                    command.Prepare();

                    for (int i = 0; i <= nbreLigneTotal; i++)
                    {
                        command.Parameters[0].Value = (i + 1) * 100000;
                        command.Parameters[1].Value = i;
                        command.Parameters[2].Value = 0;

                        for (int j = 4; j <= 25; j++)
                            command.Parameters[j - 1].Value = 1234567890;

                        for (int j = 26; j <= 50; j++)
                            command.Parameters[j - 1].Value = "01234657890123456789012345678901234567890123456789";

                        command.ExecuteNonQuery();

                        if ((i != 0) && ((i % 1000) == 0))
                        {
                            transaction.Commit();
                            if (i != nbreLigneTotal)
                            {
                                transaction = connexion.BeginTransaction(isolationLevel);
                                command.Transaction = transaction;
                            }
                        }
                    }
                }
            }
        }

And for each row inserted, I got this in the standard output :
FirebirdSql.Data.FirebirdClient Information: 0 : Command:
INSERT INTO SMR8_MODIF_C50T50L0100000 VALUES ( <at> p1,  <at> p2,  <at> p3,  <at> p4,  <at> p5,  <at> p6,  <at> p7,  <at> p8,  <at> p9,  <at> p10,  <at> p11,
 <at> p12,  <at> p13,  <at> p14,  <at> p15,  <at> p16,  <at> p17,  <at> p18,  <at> p19,  <at> p20,  <at> p21,  <at> p22,  <at> p23,  <at> p24,  <at> p25,  <at> p26,  <at> p27,  <at> p28,
 <at> p29,  <at> p30,  <at> p31,  <at> p32,  <at> p33,  <at> p34,  <at> p35,  <at> p36,  <at> p37,  <at> p38,  <at> p39,  <at> p40,  <at> p41,  <at> p42,  <at> p43,  <at> p44,  <at> p45,
 <at> p46,  <at> p47,  <at> p48,  <at> p49,  <at> p50)
Parameters:
Name: <at> p1	Type:Integer	Used Value:100000
Name: <at> p2	Type:Integer	Used Value:0
Name: <at> p3	Type:Integer	Used Value:0
Name: <at> p4	Type:Integer	Used Value:1234567890
Name: <at> p5	Type:Integer	Used Value:1234567890
Name: <at> p6	Type:Integer	Used Value:1234567890
Name: <at> p7	Type:Integer	Used Value:1234567890
Name: <at> p8	Type:Integer	Used Value:1234567890
Name: <at> p9	Type:Integer	Used Value:1234567890
Name: <at> p10	Type:Integer	Used Value:1234567890
Name: <at> p11	Type:Integer	Used Value:1234567890
Name: <at> p12	Type:Integer	Used Value:1234567890
Name: <at> p13	Type:Integer	Used Value:1234567890
Name: <at> p14	Type:Integer	Used Value:1234567890
Name: <at> p15	Type:Integer	Used Value:1234567890
Name: <at> p16	Type:Integer	Used Value:1234567890
Name: <at> p17	Type:Integer	Used Value:1234567890
Name: <at> p18	Type:Integer	Used Value:1234567890
Name: <at> p19	Type:Integer	Used Value:1234567890
Name: <at> p20	Type:Integer	Used Value:1234567890
Name: <at> p21	Type:Integer	Used Value:1234567890
Name: <at> p22	Type:Integer	Used Value:1234567890
Name: <at> p23	Type:Integer	Used Value:1234567890
Name: <at> p24	Type:Integer	Used Value:1234567890
Name: <at> p25	Type:Integer	Used Value:1234567890
Name: <at> p26	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p27	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p28	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p29	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p30	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p31	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p32	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p33	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p34	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p35	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p36	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p37	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p38	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p39	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p40	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p41	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p42	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p43	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p44	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p45	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p46	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p47	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p48	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p49	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789
Name: <at> p50	Type:VarChar	Used Value:01234657890123456789012345678901234567890123456789

If you think, it's important to continue to write parameters in the standard output, you can put in the setup
the bin/release dll without writing and the bin/debug dll with writing.
So the developpers can use the release or the debug version depending of their needs.

Regards,

--

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

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Jiri Cincura (JIRA | 13 Nov 09:00 2014

[FB-Tracker] Created: (DNET-576) IPv6 support

IPv6 support
------------

                 Key: DNET-576
                 URL: http://tracker.firebirdsql.org/browse/DNET-576
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider
    Affects Versions: 4.5.2.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor

--

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

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
Jiri Cincura (JIRA | 11 Nov 15:03 2014

[FB-Tracker] Created: (DNET-575) ClearPool is not using NormalizedConnectionString

ClearPool is not using NormalizedConnectionString
-------------------------------------------------

                 Key: DNET-575
                 URL: http://tracker.firebirdsql.org/browse/DNET-575
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.5.2.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura

--

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

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
LtColRDSChauhan | 10 Nov 22:54 2014
Picon

Stored Procedure's Exception Not Thrown by Update of FbDataAdapter

Hello,

1.  For a batch update i'm asigning stored procedures to the insert / udpate / delete commands of FbDataAdapter object.

2.  The Update call of FbDataAdapter object, does not throw FB exception thrown by my stored procedure.
Instead, such rows are left unchanged while the rest are still updated.

Thanks and Regards,
Lt Col (Retd) Rajiv D.S. Chauhan
------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Gmane