firebird-net-provider Mailing List for Firebird

Wrong generate SQL statement for the stored procedure
-----------------------------------------------------

                 Key: DNET-723
                 URL: http://tracker.firebirdsql.org/browse/DNET-723
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework support
    Affects Versions: 5.6.0.0
         Environment: Firebird 2.5.2, Firebird Entity Framework Provider - version 5.6.0, Firebird ADO.NET Data Povider - version 5.6.0, Entity Framework - version 6.1.3 
            Reporter: Denis Maslov
            Assignee: Jiri Cincura


Good day!

When I try execute simple procedure over EF, i got the next error: "FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error SQL error code = -204 Implementation limit exceeded ..." 
In the end, I found that the problem in the wrong EF generation sql statement.

Text procedure (Firebrd):
procedure B_IMP_I_REESTR ( 
    IDUSER integer, 
    IMPMODE integer, 
    IDGEN integer, 
    IDPARENT integer, 
    IDTCH integer, 
    NOMER varchar(15), 
    SBORNIK integer, 
    NAME varchar(250), 
    VIX_DAN blob sub_type 0 segment size 80, 
    ISSYSTEM integer, 
    POKAZ varchar(8), 
    GOD integer, 
    RABMAT integer, 
    IDGROUP integer, 
    IDPODGROUP integer, 
    IDTYPE integer, 
    ORDERVIEW integer, 
    CREATEDATE date, 
    AUTHOR varchar(250), 
    NORM_GUID varchar(100), 
    INSTALL_GUID varchar(100), 
    INDEX_YEAR integer, 
    INDEX_MONTH integer, 
    INDEX_ORGNAME varchar(250), 
    INDTYPE varchar(50)) 
returns ( 
    ID integer) 
...

Text procedure (EF generate):
SELECT 
1 AS "C1", 
"A"."ID" AS "ID" 
FROM "B_IMP_I_REESTR"(CAST(@IDUSER AS INT), CAST(@IMPMODE AS INT), CAST(@IDGEN AS INT), CAST(@IDPARENT AS INT), CAST(@IDTCH AS INT), CAST(@NOMER AS VARCHAR(8191)), CAST(@SBORNIK AS INT), CAST(@NAME AS VARCHAR(8191)), CAST(@VIX_DAN AS BLOB SUB_TYPE BINARY), CAST(@ISSYSTEM AS INT), CAST(@POKAZ AS VARCHAR(8191)), CAST(@GOD AS INT), CAST(@RABMAT AS INT), CAST(@IDGROUP AS INT), CAST(@IDPODGROUP AS INT), CAST(@IDTYPE AS INT), CAST(@ORDERVIEW AS INT), CAST(@CREATEDATE AS TIMESTAMP), CAST(@AUTHOR AS VARCHAR(8191)), CAST(@NORM_GUID AS VARCHAR(8191)), CAST(@INSTALL_GUID AS VARCHAR(8191)), CAST(@INDEX_YEAR AS INT), CAST(@INDEX_MONTH AS INT), CAST(@INDEX_ORGNAME AS VARCHAR(8191)), CAST(@INDTYPE AS VARCHAR(8191))) AS "A" 


For example, why INDTYPE varchar(50) -> CAST(@INDTYPE AS VARCHAR(8191)) ???


Regards, Maslov Denis.

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

        

Dynamic SQL Statement generation limit error: eror code = -204 Implementation limit exceeded block size exceeds implementation restriction
------------------------------------------------------------------------------------------------------------------------------------------

                 Key: DNET-722
                 URL: http://tracker.firebirdsql.org/browse/DNET-722
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, DDEX Provider, Entity Framework support
    Affects Versions: 5.6.0.0
         Environment: Windows 8, Visual Studio 2013 Update 5, Firebird-2.5.6.27020_0 (Win32), FirebirdSql.Data.FirebirdClient 5.6.0.0, DDEXProvider-3.0.2.0
            Reporter: Vladimir
            Assignee: Jiri Cincura


Hello, please help me with "Dynamic SQL Error: error code = -204 Implementation limit exceeded block size exceeds implementation restriction" error 

Project details: .NET 4.5.2 WPF-app 
nuget-packages: 
Firebird Entity Framework Provider - version 5.6.0 
Firebird ADO.NET Data Povider - version 5.6.0 
Entity Framework - version 6.1.3 

I have a number of Stored Procedures in my DB, which i use a lot. But when i tried to use these procedures with EntityFramework, i faced with an unsolvable problem. For this bug i chose two similar Stored Procedures: B_IMP_I_OGL and B_IMP_I_REESTR and created two projects to work with them. B_IMP_I_OGL - works perfectly, B_IMP_I_REESTR - returns following error during compilation: 

"FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error 
SQL error code = -204 
Implementation limit exceeded 
block size exceeds implementation restriction" 

B_IMP_I_REESTR has 25 input parameters, while B_IMI_I_OGL has only 7 parameters. (Both procedures return only one parameter - integer ID) 

This is my procedure: 

create or alter procedure B_IMP_I_REESTR ( 
    IDUSER integer, 
    IMPMODE integer, 
    IDGEN integer, 
    IDPARENT integer, 
    IDTCH integer, 
    NOMER varchar(15), 
    SBORNIK integer, 
    NAME varchar(250), 
    VIX_DAN blob sub_type 0 segment size 80, 
    ISSYSTEM integer, 
    POKAZ varchar(8), 
    GOD integer, 
    RABMAT integer, 
    IDGROUP integer, 
    IDPODGROUP integer, 
    IDTYPE integer, 
    ORDERVIEW integer, 
    CREATEDATE date, 
    AUTHOR varchar(250), 
    NORM_GUID varchar(100), 
    INSTALL_GUID varchar(100), 
    INDEX_YEAR integer, 
    INDEX_MONTH integer, 
    INDEX_ORGNAME varchar(250), 
    INDTYPE varchar(50)) 
returns ( 
    ID integer) 
as 
declare variable REORDERING integer; 
declare variable AINSERTING integer; 
declare variable IDIND integer; 
declare variable ISSYSTEM_OLD integer; 
declare variable IDPARENT_OLD integer; 
BEGIN 
 ... 
 END 
  execute procedure B_IMP_U_REESTR_HIDE(:ID); 
  SUSPEND; 
END 


1) I added this Stored Procedure "B_IMP_I_REESTR" to my model.edmx file (and checked in Model Browser\Storage Model, that it has been added) 
2) Then i opened Model Browser again and created complex type with one integer field named ID (return type for import function) 
3) Then i created import function for B_IMP_I_REESTR procedure, which returns complex type (2) 
4) This is calling code: 
var temp_B_IMP_I_REESTR = Context.B_IMP_I_REESTR(10, 1, 19105302, 1399455, null, "132456", 0, "some text", null, 0, "", null, 0, 
               1, 1, 1399451, 6000000, null, "some other text", Guid.NewGuid().ToString(), null, null, null, "", "some random text"); 
 foreach (B_IMP_I_REESTR_ReturnType bImpReestReturnComplexType in temp_B_IMP_I_REESTR) 
            { 
                MessageBox.Show(bImpReestReturnComplexType.ID.ToString()); 
            } 

And then i get unresolved exception: 
 "System.Data.Entity.Core.EntityCommandExecutionException" in EntityFramework.dll 

Visual studio Output gives me the following statement: 

FirebirdSql.Data.FirebirdClient Information: 0 : Command: 
SELECT 
1 AS "C1", 
"A"."ID" AS "ID" 
FROM "B_IMP_I_REESTR"(CAST(@IDUSER AS INT), CAST(@IMPMODE AS INT), CAST(@IDGEN AS INT), CAST(@IDPARENT AS INT), CAST(@IDTCH AS INT), CAST(@NOMER AS VARCHAR(8191)), CAST(@SBORNIK AS INT), CAST(@NAME AS VARCHAR(8191)), CAST(@VIX_DAN AS BLOB SUB_TYPE BINARY), CAST(@ISSYSTEM AS INT), CAST(@POKAZ AS VARCHAR(8191)), CAST(@GOD AS INT), CAST(@RABMAT AS INT), CAST(@IDGROUP AS INT), CAST(@IDPODGROUP AS INT), CAST(@IDTYPE AS INT), CAST(@ORDERVIEW AS INT), CAST(@CREATEDATE AS TIMESTAMP), CAST(@AUTHOR AS VARCHAR(8191)), CAST(@NORM_GUID AS VARCHAR(8191)), CAST(@INSTALL_GUID AS VARCHAR(8191)), CAST(@INDEX_YEAR AS INT), CAST(@INDEX_MONTH AS INT), CAST(@INDEX_ORGNAME AS VARCHAR(8191)), CAST(@INDTYPE AS VARCHAR(8191))) AS "A" 
Parameters: 
Name:IDUSER	Type:Integer	Used Value:10 
Name:IMPMODE	Type:Integer	Used Value:1 
Name:IDGEN	Type:Integer	Used Value:19105302 
Name:IDPARENT	Type:Integer	Used Value:1399455 
Name:IDTCH	Type:Integer	Used Value:<null> 
Name:NOMER	Type:VarChar	Used Value:132456 
Name:SBORNIK	Type:Integer	Used Value:0 
Name:NAME	Type:VarChar	Used Value:some text 
Name:VIX_DAN	Type:Binary	Used Value:<null> 
Name:ISSYSTEM	Type:Integer	Used Value:0 
Name:POKAZ	Type:VarChar	Used Value: 
Name:GOD	Type:Integer	Used Value:<null> 
Name:RABMAT	Type:Integer	Used Value:0 
Name:IDGROUP	Type:Integer	Used Value:1 
Name:IDPODGROUP	Type:Integer	Used Value:1 
Name:IDTYPE	Type:Integer	Used Value:1399451 
Name:ORDERVIEW	Type:Integer	Used Value:6000000 
Name:CREATEDATE	Type:TimeStamp	Used Value:<null> 
Name:AUTHOR	Type:VarChar	Used Value:some other text 
Name:NORM_GUID	Type:VarChar	Used Value:da204a67-c82d-49ba-8475-945110f3c2f7 
Name:INSTALL_GUID	Type:VarChar	Used Value:<null> 
Name:INDEX_YEAR	Type:Integer	Used Value:<null> 
Name:INDEX_MONTH	Type:Integer	Used Value:<null> 
Name:INDEX_ORGNAME	Type:VarChar	Used Value: 
Name:INDTYPE	Type:VarChar	Used Value:some random text 


FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error 
SQL error code = -204 
Implementation limit exceeded 
block size exceeds implementation restriction ---&amp;gt; FirebirdSql.Data.Common.IscException: Dynamic SQL Error 
SQL error code = -204 
Implementation limit exceeded 
block size exceeds implementation restriction 
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response) 
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() 
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() 
   в FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) 
   в FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) 
   в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) 
   в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)

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

       

Dynamic SQL Statement generation limit error: eror code = -204 Implementation limit exceeded block size exceeds implementation restriction
------------------------------------------------------------------------------------------------------------------------------------------

                 Key: DNET-721
                 URL: http://tracker.firebirdsql.org/browse/DNET-721
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, DDEX Provider, Entity Framework support
    Affects Versions: 5.6.0.0
         Environment: Windows 8, Visual Studio 2013 Update 5, Firebird-2.5.6.27020_0 (Win32), FirebirdSql.Data.FirebirdClient 5.6.0.0, DDEXProvider-3.0.2.0
            Reporter: Vladimir
            Assignee: Jiri Cincura


Hello, please help me with "Dynamic SQL Error: error code = -204 Implementation limit exceeded block size exceeds implementation restriction" error 

Project details: .NET 4.5.2 WPF-app 
nuget-packages: 
Firebird Entity Framework Provider - version 5.6.0 
Firebird ADO.NET Data Povider - version 5.6.0 
Entity Framework - version 6.1.3 

I have a number of Stored Procedures in my DB, which i use a lot. But when i tried to use these procedures with EntityFramework, i faced with an unsolvable problem. For this bug i chose two similar Stored Procedures: B_IMP_I_OGL and B_IMP_I_REESTR and created two projects to work with them. B_IMP_I_OGL - works perfectly, B_IMP_I_REESTR - returns following error during compilation: 

"FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error 
SQL error code = -204 
Implementation limit exceeded 
block size exceeds implementation restriction" 

B_IMP_I_REESTR has 20 input parameters, while B_IMI_I_OGL has only 7 parameters. (Both procedures return only one parameter - integer ID) 

This is my procedure: 

create or alter procedure B_IMP_I_REESTR ( 
    IDUSER integer, 
    IMPMODE integer, 
    IDGEN integer, 
    IDPARENT integer, 
    IDTCH integer, 
    NOMER varchar(15), 
    SBORNIK integer, 
    NAME varchar(250), 
    VIX_DAN blob sub_type 0 segment size 80, 
    ISSYSTEM integer, 
    POKAZ varchar(8), 
    GOD integer, 
    RABMAT integer, 
    IDGROUP integer, 
    IDPODGROUP integer, 
    IDTYPE integer, 
    ORDERVIEW integer, 
    CREATEDATE date, 
    AUTHOR varchar(250), 
    NORM_GUID varchar(100), 
    INSTALL_GUID varchar(100), 
    INDEX_YEAR integer, 
    INDEX_MONTH integer, 
    INDEX_ORGNAME varchar(250), 
    INDTYPE varchar(50)) 
returns ( 
    ID integer) 
as 
declare variable REORDERING integer; 
declare variable AINSERTING integer; 
declare variable IDIND integer; 
declare variable ISSYSTEM_OLD integer; 
declare variable IDPARENT_OLD integer; 
BEGIN 
 ...
 END 
  execute procedure B_IMP_U_REESTR_HIDE(:ID); 
  SUSPEND; 
END 


1) I added this Stored Procedure "B_IMP_I_REESTR" to my model.edmx file (and checked in Model Browser\Storage Model, that it has been added) 
2) Then i opened Model Browser again and created complex type with one integer field named ID (return type for import function) 
3) Then i created import function for B_IMP_I_REESTR procedure, which returns complex type (2) 
4) This is calling code: 
var temp_B_IMP_I_REESTR = Context.B_IMP_I_REESTR(10, 1, 19105302, 1399455, null, "132456", 0, "some text", null, 0, "", null, 0, 
               1, 1, 1399451, 6000000, null, "some other text", Guid.NewGuid().ToString(), null, null, null, "", "some random text"); 
 foreach (B_IMP_I_REESTR_ReturnType bImpReestReturnComplexType in temp_B_IMP_I_REESTR) 
            { 
                MessageBox.Show(bImpReestReturnComplexType.ID.ToString()); 
            } 

And then i get unresolved exception: 
 "System.Data.Entity.Core.EntityCommandExecutionException" in EntityFramework.dll 

Visual studio Output gives me the following statement: 

FirebirdSql.Data.FirebirdClient Information: 0 : Command: 
SELECT 
1 AS "C1", 
"A"."ID" AS "ID" 
FROM "B_IMP_I_REESTR"(CAST(@IDUSER AS INT), CAST(@IMPMODE AS INT), CAST(@IDGEN AS INT), CAST(@IDPARENT AS INT), CAST(@IDTCH AS INT), CAST(@NOMER AS VARCHAR(8191)), CAST(@SBORNIK AS INT), CAST(@NAME AS VARCHAR(8191)), CAST(@VIX_DAN AS BLOB SUB_TYPE BINARY), CAST(@ISSYSTEM AS INT), CAST(@POKAZ AS VARCHAR(8191)), CAST(@GOD AS INT), CAST(@RABMAT AS INT), CAST(@IDGROUP AS INT), CAST(@IDPODGROUP AS INT), CAST(@IDTYPE AS INT), CAST(@ORDERVIEW AS INT), CAST(@CREATEDATE AS TIMESTAMP), CAST(@AUTHOR AS VARCHAR(8191)), CAST(@NORM_GUID AS VARCHAR(8191)), CAST(@INSTALL_GUID AS VARCHAR(8191)), CAST(@INDEX_YEAR AS INT), CAST(@INDEX_MONTH AS INT), CAST(@INDEX_ORGNAME AS VARCHAR(8191)), CAST(@INDTYPE AS VARCHAR(8191))) AS "A" 
Parameters: 
Name:IDUSER	Type:Integer	Used Value:10 
Name:IMPMODE	Type:Integer	Used Value:1 
Name:IDGEN	Type:Integer	Used Value:19105302 
Name:IDPARENT	Type:Integer	Used Value:1399455 
Name:IDTCH	Type:Integer	Used Value:<null> 
Name:NOMER	Type:VarChar	Used Value:132456 
Name:SBORNIK	Type:Integer	Used Value:0 
Name:NAME	Type:VarChar	Used Value:some text 
Name:VIX_DAN	Type:Binary	Used Value:<null> 
Name:ISSYSTEM	Type:Integer	Used Value:0 
Name:POKAZ	Type:VarChar	Used Value: 
Name:GOD	Type:Integer	Used Value:<null> 
Name:RABMAT	Type:Integer	Used Value:0 
Name:IDGROUP	Type:Integer	Used Value:1 
Name:IDPODGROUP	Type:Integer	Used Value:1 
Name:IDTYPE	Type:Integer	Used Value:1399451 
Name:ORDERVIEW	Type:Integer	Used Value:6000000 
Name:CREATEDATE	Type:TimeStamp	Used Value:<null> 
Name:AUTHOR	Type:VarChar	Used Value:some other text 
Name:NORM_GUID	Type:VarChar	Used Value:da204a67-c82d-49ba-8475-945110f3c2f7 
Name:INSTALL_GUID	Type:VarChar	Used Value:<null> 
Name:INDEX_YEAR	Type:Integer	Used Value:<null> 
Name:INDEX_MONTH	Type:Integer	Used Value:<null> 
Name:INDEX_ORGNAME	Type:VarChar	Used Value: 
Name:INDTYPE	Type:VarChar	Used Value:some random text 


FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error 
SQL error code = -204 
Implementation limit exceeded 
block size exceeds implementation restriction ---&amp;gt; FirebirdSql.Data.Common.IscException: Dynamic SQL Error 
SQL error code = -204 
Implementation limit exceeded 
block size exceeds implementation restriction 
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response) 
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() 
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() 
   в FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) 
   в FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) 
   в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) 
   в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)

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

       

Dynamic SQL Statement generation limit error: eror code = -204 Implementation limit exceeded block size exceeds implementation restriction
------------------------------------------------------------------------------------------------------------------------------------------

                 Key: DNET-720
                 URL: http://tracker.firebirdsql.org/browse/DNET-720
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, DDEX Provider, Entity Framework support
    Affects Versions: 5.6.0.0
         Environment: Windows 8, Visual Studio 2013 Update 5, Firebird-2.5.6.27020_0 (Win32), FirebirdSql.Data.FirebirdClient 5.6.0.0, DDEXProvider-3.0.2.0
            Reporter: Vladimir
            Assignee: Jiri Cincura


Hello, please help me with "Dynamic SQL Error: error code = -204 Implementation limit exceeded block size exceeds implementation restriction" error

Project details: .NET 4.5.2 WPF-app
nuget-packages:
Firebird Entity Framework Provider - version 5.6.0
Firebird ADO.NET Data Povider  - version 5.6.0
Entity Framework - version 6.1.3

I have a number of Stored Procedures in my DB, which i use a lot. But when i tried to use these procedures with EntityFramework, i faced with an unsolvable problem.  For this bug i chose two similar Stored Procedures: B_IMP_I_OGL and B_IMP_I_REESTR and created two projects to work with them. B_IMP_I_OGL - works perfectly, B_IMP_I_REESTR - returns following error during compilation:

"FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction"

B_IMP_I_REESTR has 20 input parameters, while B_IMI_I_OGL has only 7 parameters. (Both procedures return only one parameter - integer ID)

This is my procedure:

create or alter procedure B_IMP_I_REESTR (
    IDUSER integer,
    IMPMODE integer,
    IDGEN integer,
    IDPARENT integer,
    IDTCH integer,
    NOMER varchar(15),
    SBORNIK integer,
    NAME varchar(250),
    VIX_DAN blob sub_type 0 segment size 80,
    ISSYSTEM integer,
    POKAZ varchar(8),
    GOD integer,
    RABMAT integer,
    IDGROUP integer,
    IDPODGROUP integer,
    IDTYPE integer,
    ORDERVIEW integer,
    CREATEDATE date,
    AUTHOR varchar(250),
    NORM_GUID varchar(100),
    INSTALL_GUID varchar(100),
    INDEX_YEAR integer,
    INDEX_MONTH integer,
    INDEX_ORGNAME varchar(250),
    INDTYPE varchar(50))
returns (
    ID integer)
as
declare variable REORDERING integer;
declare variable AINSERTING integer;
declare variable IDIND integer;
declare variable ISSYSTEM_OLD integer;
declare variable IDPARENT_OLD integer;
BEGIN
  IF (:IDTCH = 0)
  THEN IDTCH = NULL;

  UPDATE B_TEMP_BLOB SET BLOB1 = :VIX_DAN WHERE ID = :IDGEN;
  SELECT BLOB1 FROM B_TEMP_BLOB WHERE ID = :IDGEN INTO :VIX_DAN;

  IF (:NORM_GUID <> '') THEN
  BEGIN
    SELECT ID, ISSYSTEM
    FROM B_IMP_F_REESTR(:IDUSER, :IMPMODE, :NORM_GUID)
    INTO ID, ISSYSTEM_OLD;

    /* Только поиск для определения наличия записи */
    IF (IMPMODE = 2) THEN BEGIN
      SUSPEND;
      EXIT;
    END

    IF (:ORDERVIEW IS NULL OR :ORDERVIEW <= 0)
    THEN
      SELECT MAX(ORDERVIEW) + 1
        FROM B_REESTR
        WHERE IDPARENT = :IDPARENT
          /*AND RABMAT = :RABMAT /* для подстраховки */
        INTO :ORDERVIEW;
    ELSE
      REORDERING = 1;

    IF (ORDERVIEW IS NULL) THEN
      ORDERVIEW = 1;
    ELSE
      REORDERING = 1;

    IF (:ID IS NULL) THEN
    BEGIN
      ID = GEN_ID (A_G_SMETA, 1);
      AINSERTING = 1;
    END

    IF (:IDGROUP = 0 OR :IDPODGROUP = 0) THEN
      SELECT IDGROUP, IDPODGROUP
        FROM B_READ_DEFAULT_REESTR_GROUPS (:IDUSER, :GOD)
        INTO :IDGROUP, :IDPODGROUP;

    IF (:REORDERING = 1) THEN
      EXECUTE PROCEDURE B_WRITE_NEWORDER_REESTR(
          :IDUSER, :ID, :IDPARENT, :RABMAT, :ORDERVIEW )
        RETURNING_VALUES (:REORDERING);

    SELECT INDEX_ID_MES
      FROM B_FIND_IND_PARAMS (:IDUSER, :INDEX_YEAR, :INDEX_MONTH, :INDEX_ORGNAME)
      INTO :IDIND;

    IF (:AINSERTING = 1) THEN
    BEGIN
      INSERT INTO B_REESTR (
          ID, IDPARENT, IDTCH, NOMER, SBORNIK, NAME, VIX_DAN, ISSYSTEM,
          POKAZ, GOD, RABMAT, IDGROUP, IDPODGROUP, IDTYPE, IDIND,
          ORDERVIEW, CREATEDATE, AUTHOR, NORM_GUID, INDTYPE, INSTALL_GUID)
        VALUES (
          :ID, :IDPARENT, :IDTCH, :NOMER, :SBORNIK, :NAME, :VIX_DAN, :ISSYSTEM,
          :POKAZ, :GOD, :RABMAT, :IDGROUP, :IDPODGROUP, :IDTYPE, :IDIND,
          :ORDERVIEW, :CREATEDATE, :AUTHOR, :NORM_GUID, :INDTYPE, :INSTALL_GUID);
    END
    ELSE
    BEGIN
      IF (:ISSYSTEM_OLD = 1)
      THEN ISSYSTEM = 1;

      /* <[9129]> - перенос нескрытых папок и сборников внутри скрываемого */
      if ((:SBORNIK=0) and (-10000/*FEB60E9A677D*/ - :RABMAT in (0, 2, 3)/*[9F5FFA1322A6]*/)) then
      for select :IDPARENT
        from B_REESTR
        where ID = :ID
        into :IDPARENT_OLD
      do
      update B_REESTR
        set IDPARENT = :IDPARENT_OLD
        where IDPARENT = :ID
          and RABMAT in (0, 2, 3);/*[9F5FFA1322A6]*/
      /* поиск нескрытых родителей по рекурсии вверх, равно как и перенос
         нескрытых дочерних узлов нижних уровней, выполнится в процессе Их
         (родительских или дочерних узлов) "сокрытия" при импорте
         </[9129]> */

      UPDATE B_REESTR
        SET IDPARENT     = :IDPARENT,
            IDTCH        = :IDTCH,
            NOMER        = :NOMER,
            SBORNIK      = :SBORNIK,
            NAME         = :NAME,
            VIX_DAN      = :VIX_DAN,
            ISSYSTEM     = :ISSYSTEM,
            POKAZ        = :POKAZ,
            GOD          = :GOD,
            RABMAT       = :RABMAT,
            IDGROUP      = :IDGROUP,
            IDPODGROUP   = :IDPODGROUP,
            IDTYPE       = :IDTYPE,
            ORDERVIEW    = :ORDERVIEW,
            IDIND        = :IDIND,
            CREATEDATE   = :CREATEDATE,
            AUTHOR       = :AUTHOR,
            NORM_GUID    = :NORM_GUID,
            INDTYPE      = :INDTYPE,
            INSTALL_GUID = :INSTALL_GUID
        WHERE ID = :ID;
    END
  END

  execute procedure B_IMP_U_REESTR_HIDE(:ID); /* [9129] - поддержка информации о скрытии/удалении */

  SUSPEND;
END


1) I added this Stored Procedure "B_IMP_I_REESTR" to my model.edmx file  (and checked in Model Browser\Storage Model, that it has been added)
2) Then i opened Model Browser again and created complex type with one integer field named ID (return type for import function)
3) Then i created import function for B_IMP_I_REESTR procedure, which returns complex type (2)
4) This is calling code:
var temp_B_IMP_I_REESTR = Context.B_IMP_I_REESTR(10, 1, 19105302, 1399455, null, "132456", 0, "some text", null, 0, "", null, 0,
               1, 1, 1399451, 6000000, null, "some other text", Guid.NewGuid().ToString(), null, null, null, "", "some random text");
 foreach (B_IMP_I_REESTR_ReturnType bImpReestReturnComplexType in temp_B_IMP_I_REESTR)
            {
                MessageBox.Show(bImpReestReturnComplexType.ID.ToString());
            }

And then i get unresolved exception:
 "System.Data.Entity.Core.EntityCommandExecutionException" in EntityFramework.dll

Visual studio Output gives me the following statement:

FirebirdSql.Data.FirebirdClient Information: 0 : Command:
SELECT 
1 AS "C1", 
"A"."ID" AS "ID"
FROM "B_IMP_I_REESTR"(CAST(@IDUSER AS INT), CAST(@IMPMODE AS INT), CAST(@IDGEN AS INT), CAST(@IDPARENT AS INT), CAST(@IDTCH AS INT), CAST(@NOMER AS VARCHAR(8191)), CAST(@SBORNIK AS INT), CAST(@NAME AS VARCHAR(8191)), CAST(@VIX_DAN AS BLOB SUB_TYPE BINARY), CAST(@ISSYSTEM AS INT), CAST(@POKAZ AS VARCHAR(8191)), CAST(@GOD AS INT), CAST(@RABMAT AS INT), CAST(@IDGROUP AS INT), CAST(@IDPODGROUP AS INT), CAST(@IDTYPE AS INT), CAST(@ORDERVIEW AS INT), CAST(@CREATEDATE AS TIMESTAMP), CAST(@AUTHOR AS VARCHAR(8191)), CAST(@NORM_GUID AS VARCHAR(8191)), CAST(@INSTALL_GUID AS VARCHAR(8191)), CAST(@INDEX_YEAR AS INT), CAST(@INDEX_MONTH AS INT), CAST(@INDEX_ORGNAME AS VARCHAR(8191)), CAST(@INDTYPE AS VARCHAR(8191))) AS "A"
Parameters:
Name:IDUSER	Type:Integer	Used Value:10
Name:IMPMODE	Type:Integer	Used Value:1
Name:IDGEN	Type:Integer	Used Value:19105302
Name:IDPARENT	Type:Integer	Used Value:1399455
Name:IDTCH	Type:Integer	Used Value:<null>
Name:NOMER	Type:VarChar	Used Value:132456
Name:SBORNIK	Type:Integer	Used Value:0
Name:NAME	Type:VarChar	Used Value:some text
Name:VIX_DAN	Type:Binary	Used Value:<null>
Name:ISSYSTEM	Type:Integer	Used Value:0
Name:POKAZ	Type:VarChar	Used Value:
Name:GOD	Type:Integer	Used Value:<null>
Name:RABMAT	Type:Integer	Used Value:0
Name:IDGROUP	Type:Integer	Used Value:1
Name:IDPODGROUP	Type:Integer	Used Value:1
Name:IDTYPE	Type:Integer	Used Value:1399451
Name:ORDERVIEW	Type:Integer	Used Value:6000000
Name:CREATEDATE	Type:TimeStamp	Used Value:<null>
Name:AUTHOR	Type:VarChar	Used Value:some other text
Name:NORM_GUID	Type:VarChar	Used Value:da204a67-c82d-49ba-8475-945110f3c2f7
Name:INSTALL_GUID	Type:VarChar	Used Value:<null>
Name:INDEX_YEAR	Type:Integer	Used Value:<null>
Name:INDEX_MONTH	Type:Integer	Used Value:<null>
Name:INDEX_ORGNAME	Type:VarChar	Used Value:
Name:INDTYPE	Type:VarChar	Used Value:some random text


FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction ---&amp;gt; FirebirdSql.Data.Common.IscException: Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response)
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()
   в FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText)
   в FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
   в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
   в FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)

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

       

Is this the same for the other FbUserData fields:
1. GroupID
2. GroupName
3. UserID

The rest (it First/Middle/LastName seem to work fine). If there are
differences between versions, that would be worth knowing. We are running
Firebird v2.5, and I am developing on VS2013 using the ADO.NET client
v5.6.0.

Thanks,
David

On 1/8/2011 6:41 AM, Jiri Cincura wrote:
> On Sat, Jan 8, 2011 at 14:14, Rick Roen <
Ric...@pu...> wrote:
>> What is the RoleName used for here?
>
> It does nothing. It's in API, but currently it's not wired on server
> to anything.
>
>> How do I add this user to a Role?
>
> You're not adding users to roles. Users are using roles. It's not the
> same as groups in OSs, for instance (but a lot of people are confused
> with it).
>

Connection rejected by remote interface - Firebird 1.5 on Linux Server
----------------------------------------------------------------------

                 Key: DNET-719
                 URL: http://tracker.firebirdsql.org/browse/DNET-719
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 5.6.0.0
         Environment: Linux Server with Centos 6.5,  Firebird 1.5.6.5026-0.i686
            Reporter: Felix Martinez
            Assignee: Jiri Cincura


ErrorCode: 335544421
Number: 335544421, Class: 0, Line: 0
ErrorMessage: connection rejected by remote interface

It seems hapen when try to get version at Connection

My Connection String
string connectionString =
                @"
                Server=localhost;
                User=SYSDBA;
                Password=masterkey;
                Database=192.168.1.100:/home/dbs/data.fdb;
                Port=3050;
                Dialect=3;
                Charset=NONE;
                Connection lifetime=0; 
                Packet Size=8192;
                ServerType=0;";


With same connection string and Firebird version on any Windows based server it works.

I know Firebird version is old but is in production environment.

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

        

The auto created triggers can have names which are too long
-----------------------------------------------------------

                 Key: DNET-718
                 URL: http://tracker.firebirdsql.org/browse/DNET-718
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework support
    Affects Versions: 5.6.0.0
         Environment: ,Net 4.5.2 EF6.1.3 Firebird 2.5.2 .NetProvider 5.6.0.0
            Reporter: Leonard Wennekers
            Assignee: Jiri Cincura


The migration below will generate an exception on the trigger because of the identify: true inside SequenceId = c.Long(nullable: false, identify: true)
The used name of the trigger ID_HistoryUnknownMessages_SequenceId is not allowed because of it's length. 


CreateTable(
    "HistoryUnknownMessages",
    c => new
    {
        SequenceId = c.Long(nullable: false, identify: true),
        EventOccurred = c.DateTime(nullable: false),
        Address = c.String(nullable: false, maxLength: 15),
        Message = c.String(nullable: false, maxLength: 1000),
    })
    .PrimaryKey(t => t.SequenceId, name: "PK_HistoryUnknownMessages");

2016-11-17 09:20:57,105 [TestRunnerThread] DEBUG IOLAN.Context.Management.MigrationLogger - Verbose (): CREATE TABLE "HistoryUnknownMessages" (
	"SequenceId" BIGINT NOT NULL, 
	"EventOccurred" TIMESTAMP NOT NULL, 
	"Address" VARCHAR(15) NOT NULL, 
	"Message" VARCHAR(1000) NOT NULL
)
2016-11-17 09:20:57,105 [TestRunnerThread] DEBUG IOLAN.Context.Management.MigrationLogger - Verbose (): ALTER TABLE "HistoryUnknownMessages" ADD CONSTRAINT "PK_HistoryUnknownMessages" PRIMARY KEY ("SequenceId")
2016-11-17 09:20:57,105 [TestRunnerThread] DEBUG IOLAN.Context.Management.MigrationLogger - Verbose (): EXECUTE BLOCK
AS
BEGIN
	if (not exists(select 1 from rdb$generators where rdb$generator_name = 'GEN_IDENTITY')) then
	begin
		execute statement 'create sequence GEN_IDENTITY';
	end
END
2016-11-17 09:20:57,105 [TestRunnerThread] DEBUG IOLAN.Context.Management.MigrationLogger - Verbose (): CREATE OR ALTER TRIGGER "ID_HistoryUnknownMessages_SequenceId" ACTIVE BEFORE INSERT ON "HistoryUnknownMessages"
AS
BEGIN
	if (new."SequenceId" is null) then
	begin
		new."SequenceId" = next value for GEN_IDENTITY;
	end
END
  


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

        

NullReferenceException in FbConnectionPoolManager.Release
---------------------------------------------------------

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


I am getting a null reference exception in:

internal void Release(FbConnectionInternal connection)
{
    this.CheckDisposed();
    this._pools.GetOrAdd(connection.Options.NormalizedConnectionString, (string _) => new FbConnectionPoolManager.Pool(connection.Options)).ReleaseConnection(connection);
}

Running the code in a debugger shows that connection.Options is null. I think it should be connection.NormalizedConnectionString instead.

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

        

Hi Jiří,

thank you, it works now - the database file is created

Wolfgang


--
-- Wolfgang Riedmann 
-- Riedmann GmbH - srl.
-- Individuelle EDV-Lösungen - Soluzioni informatiche personalizzate
-- I-39012 Meran, Postgranz 16b
-- Telefon +39 0473 201 239
-- http://www.riedmann.it - wol...@ri...

-----Ursprüngliche Nachricht-----
Von: Jiří Činčura [mailto:ji...@ci...] 
Gesendet: Montag, 14. November 2016 20:59
An: fir...@li...
Betreff: Re: [Firebird-net-provider] .NET provider and embedded server

Use `Client Library` parameter.

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

On Mon, Nov 14, 2016, at 19:20, Wolfgang Riedmann wrote:
> Hello,
> 
> I've tried to use the latest .NET provider for Firebird with Firebird 
> 3.01. Unfortunately on connecting to a database the driver complains 
> that it cannot find fbembed.
> 
> But for Firebird 3.0 the fbembed.dll was removed and integrated in the 
> client.dll.
> 
> What can I do to make the .NET provider work with Firebird 3.0 databases?
> Unfortunately the use of the fbembed.dll from Firebird 2.5 is not an 
> option as the database files are not compatible between Firebird 2.5 
> and Firebird 3.0.
> 
> Thank you very much for any help!
> 
> Wolfgang
> 
> 
> ----------------------------------------------------------------------
> -------- _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Use `Client Library` parameter.

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

On Mon, Nov 14, 2016, at 19:20, Wolfgang Riedmann wrote:
> Hello,
> 
> I've tried to use the latest .NET provider for Firebird with Firebird
> 3.01. Unfortunately on connecting to a database the driver complains that
> it cannot find fbembed.
> 
> But for Firebird 3.0 the fbembed.dll was removed and integrated in the
> client.dll.
> 
> What can I do to make the .NET provider work with Firebird 3.0 databases?
> Unfortunately the use of the fbembed.dll from Firebird 2.5 is not an
> option as the database files are not compatible between Firebird 2.5 and
> Firebird 3.0.
> 
> Thank you very much for any help!
> 
> Wolfgang
> 
> 
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Hello,

I've tried to use the latest .NET provider for Firebird with Firebird 3.01. Unfortunately on connecting to a database the driver complains that it cannot find fbembed.

But for Firebird 3.0 the fbembed.dll was removed and integrated in the client.dll.

What can I do to make the .NET provider work with Firebird 3.0 databases? Unfortunately the use of the fbembed.dll from Firebird 2.5 is not an option as the database files are not compatible between Firebird 2.5 and Firebird 3.0.

Thank you very much for any help!

Wolfgang

Connection to Firebird throws NullReferenceException on mono
------------------------------------------------------------

                 Key: DNET-716
                 URL: http://tracker.firebirdsql.org/browse/DNET-716
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.6.0.0
         Environment: kubuntu 16.04 x64 + mono 4.6.1 + FirebirdSQL ADO.NET driver 5.6.0.0
            Reporter: Anton Kasyanov
            Assignee: Jiri Cincura


An attempt to connect to the Firebird databse results in an NullReferenceException with the following stacktrace:

  at System.Text.Encoding.GetBytes (System.String s) [0x00015] in <dca3b561b8ad4f9fb10141d81b39ff45>:0 
  at FirebirdSql.Data.Client.Managed.GdsConnection.UserIdentificationData () [0x00141] in <1c49352b896a4a9dba73865ddab7b59e>:0 
  at FirebirdSql.Data.Client.Managed.GdsConnection.Identify (System.String database) [0x00044] in <1c49352b896a4a9dba73865ddab7b59e>:0 
  at FirebirdSql.Data.FirebirdClient.ClientFactory.CreateManagedDatabase (FirebirdSql.Data.FirebirdClient.FbConnectionString options) [0x00042] in <1c49352b896a4a9dba73865ddab7b59e>:0 
  at FirebirdSql.Data.FirebirdClient.ClientFactory.CreateDatabase (FirebirdSql.Data.FirebirdClient.FbConnectionString options) [0x00010] in <1c49352b896a4a9dba73865ddab7b59e>:0 
  at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect () [0x0001e] in <1c49352b896a4a9dba73865ddab7b59e>:0 
  at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager+Pool.CreateNewConnection (FirebirdSql.Data.FirebirdClient.FbConnectionString connectionString) [0x00006] in <1c49352b896a4a9dba73865ddab7b59e>:0 
  at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager+Pool.CreateNewConnectionIfPossibleImpl (FirebirdSql.Data.FirebirdClient.FbConnectionString connectionString) [0x00020] in <1c49352b896a4a9dba73865ddab7b59e>:0 
  at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager+Pool.GetConnection (FirebirdSql.Data.FirebirdClient.FbConnection owner) [0x00024] in <1c49352b896a4a9dba73865ddab7b59e>:0 
  at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get (FirebirdSql.Data.FirebirdClient.FbConnectionString connectionString, FirebirdSql.Data.FirebirdClient.FbConnection owner) [0x00035] in <1c49352b896a4a9dba73865ddab7b59e>:0 
  at FirebirdSql.Data.FirebirdClient.FbConnection.Open () [0x00086] in <1c49352b896a4a9dba73865ddab7b59e>:0

The exception is thrown at the line

private byte[] UserIdentificationData()
{
...
  var user = Encoding.UTF8.GetBytes(Environment.GetEnvironmentVariable("USERNAME"));
...
}

of the class FirebirdSql.Data.Client.Managed.GdsConnection

Earlier this method used Environment.UserName in this line, however this was changed by the commit https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/commit/7e1e4a1e1eb362c2c96a141a51952b23c9970f79

The USERNAME environment variable is not set in linux bu default. Setting it hides the issue and can be considered as a workaround.

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

        

FbDataReader should use only Ordinal CS/CI matches for column names
-------------------------------------------------------------------

                 Key: DNET-715
                 URL: http://tracker.firebirdsql.org/browse/DNET-715
             Project: .NET Data provider
          Issue Type: Task
    Affects Versions: 5.6.0.0
         Environment: Was simply too bad it
            Reporter: Workdev Tecnologia da Informação LTDA
            Assignee: Jiri Cincura


While you treating the fields in this way no longer will update the version. We have other things to improve not disrupt what was good.

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

       

You have basically only one option. 2PC. But that's not something
ADO.NET handles.

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

Thanks for getting back to me.

Can you or anyone please let me know what is the recommended approach in
the ADO.NET provider for performing a transaction across, let's say, 2
databases (eg a single command in each)?

On 5 November 2016 at 08:37, Jiří Činčura <ji...@ci...> wrote:

> I don't think the TransactionScope block is a good idea here (well, it
> never is). Having it between multiple databases mean spinning MSDTC and
> enlisting there. I don't remember from top of my head whether that works
> in FirebirdClient or not. And the ChangeDatabase is ADO.NET non-sense
> for MS SQL. In Firebird you can't switch databases. You just need to
> open another connection (which is what the implementation does). So I
> suppose some transaction is still dangling there on 2nd run.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------
> ------------------
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

DbUpdateConcurrencyException is not thrown when expected
--------------------------------------------------------

                 Key: DNET-714
                 URL: http://tracker.firebirdsql.org/browse/DNET-714
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, Entity Framework support
    Affects Versions: 5.5.0.0
         Environment: FB3, .NET 4.6.2, Win7 64, EF6.1.3
            Reporter: Scot Lunsford
            Assignee: Jiri Cincura


The following sql is executed for an update. The SQL looks correct. But it doesn't detect that the update failed because another user edited the same row. Instead it throw the DbUpdateException because the returned CreateUser value is null.

FirebirdSql.Data.FirebirdClient Information: 0 : Command:
EXECUTE BLOCK (
p0 BLOB SUB_TYPE TEXT = @p0, p1 BIGINT = @p1, p2 CHAR(16) CHARACTER SET OCTETS = @p2
) RETURNS (
"CREATEUSER" VARCHAR(31), "MODUSER" VARCHAR(31), "CREATEDATE" TIMESTAMP, "MODDATE" TIMESTAMP, "ROWVERSION" CHAR(16) CHARACTER SET OCTETS)
AS BEGIN
UPDATE "SCENARIO"
SET "DESCRIPTION" = :p0
WHERE (("SCENARIOID" = :p1) AND ("ROWVERSION" = :p2))
RETURNING "CREATEUSER", "MODUSER", "CREATEDATE", "MODDATE", "ROWVERSION" INTO :"CREATEUSER", :"MODUSER", :"CREATEDATE", :"MODDATE", :"ROWVERSION";
SUSPEND;
END

Parameters:
Name:@p0	Type:Text	Used Value:This scenario was edit testing again
Name:@p1	Type:BigInt	Used Value:1032
Name:@p2	Type:Guid	Used Value:0b5f7468-0580-a347-b2f0-6214478f2d8c

Exception thrown: 'System.Data.Entity.Infrastructure.DbUpdateException' in EntityFramework.dll
A null store-generated value was returned for a non-nullable member 'CREATEUSER' of type 'CAG.DBManager.DataLayer.Models.SCENARIO'.
Exception thrown: 'System.Data.Entity.Infrastructure.DbUpdateException' in DataLayer.dll

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

        

FirebirdSql.VisualStudio.DataTools.dll ConnectionProperties is null on Add Connection Dialog
--------------------------------------------------------------------------------------------

                 Key: DNET-713
                 URL: http://tracker.firebirdsql.org/browse/DNET-713
             Project: .NET Data provider
          Issue Type: Bug
          Components: DDEX Provider
            Reporter: FEBit Bilişim
            Assignee: Jiri Cincura
            Priority: Blocker


ConnectionProperties is null while use vs2013 server explorer / Data Connections / Add Connection Dialog

A first chance exception of type 'System.NullReferenceException' occurred in FirebirdSql.VisualStudio.DataTools.dll
Additional information: Object reference not set to an instance of an object.

       public override void LoadProperties()
        {
            System.Diagnostics.Trace.WriteLine("FbDataConnectionUIControl::LoadProperties()");

            try
            {
                this.txtDataSource.Text = (string)ConnectionProperties["Data Source"];


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

       

I don't think the TransactionScope block is a good idea here (well, it
never is). Having it between multiple databases mean spinning MSDTC and
enlisting there. I don't remember from top of my head whether that works
in FirebirdClient or not. And the ChangeDatabase is ADO.NET non-sense
for MS SQL. In Firebird you can't switch databases. You just need to
open another connection (which is what the implementation does). So I
suppose some transaction is still dangling there on 2nd run.

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

Hi Jiri and all,

We are running FB v2.5, and I am using the ADO v5.5.0 DLL to connect from
my VS2013 C# project to 4 different databases. I have a little tool for
user management, and to narrow the focus, one of the operations is to
delete the user by:
- REVOKE ALL GRANTs across all DBs
- DROP the USER

The approach I have taken is to use
the System.Transactions.TransactionScope object, a
single FirebirdSql.Data.FirebirdClient.FbConnection object (which is
enlisted), and when switching DBs I call FbConnection::ChangeDatabase().
This seems to work fine the first time, but the very next time to call this
method to delete a different user, the error message appears (also
attached):
unsuccessful metadata update
ERASE RDB$USER_PRIVILEGES failed in REVOKE ALL ON ALL
lock conflict on no wait transaction
Acquire lock for relation (RDB$USER_PRIVILEGES) failed

This occurs in both Debug and Release builds. Opening and closing the EXE
between operations and the problem goes away. It seems as if the first
deletion of the user and its associated REVOKEs has left some hanging hook
into things that prevents further operations from being performed. I have
tried changing the IsolationLevel on the connection but that doesn't seem
to matter.

Is the approach taken below the recommended flow? Any tips/ideas would be
welcome.

Best regards,
David

                using (System.Transactions.TransactionScope scope = new
System.Transactions.TransactionScope())
                {
                    System.Transactions.IsolationLevel isolationLevel =
System.Transactions.Transaction.Current.IsolationLevel;
                    System.Diagnostics.Debug.WriteLine("IsolationLevel = "
+ isolationLevel.ToString() + " versus " + csb.IsolationLevel.ToString());
                    csb.IsolationLevel = IsolationLevel.Serializable;
                    System.Diagnostics.Debug.WriteLine("ConnectionTimeout =
" + csb.ConnectionTimeout.ToString());
                    csb.ConnectionTimeout = 4;
                    csb.Enlist = true;
                    using (FirebirdSql.Data.FirebirdClient.FbConnection
conn = new
FirebirdSql.Data.FirebirdClient.FbConnection(csb.ConnectionString))
                    {
                        conn.Open();
                        // REVOKE all rights for the given user. This must
be done for each database.
                        //
http://www.firebirdsql.org/refdocs/langrefupd25-security-grant-revoke.html#langrefupd25-security-revoke-all-on-all
                        string sUser = lstUsers.SelectedItem.ToString();
                        string sSQL = "REVOKE ALL ON ALL FROM " + sUser;
                        FbCommand cmd;
                        foreach (Globals.DbAliases alias in
Enum.GetValues(typeof(Globals.DbAliases)))
                        {

conn.ChangeDatabase(Globals.m_dictDbAliases[alias].Alias);
                            System.Diagnostics.Debug.WriteLine("Revoking
from DB " + conn.Database.ToString());
                            cmd = new FbCommand(sSQL, conn);
                            cmd.ExecuteNonQuery();
                        }
                        // Delete the user.
                        //
http://www.firebirdsql.org/refdocs/langrefupd25-security-sql-user-mgmt.html#langrefupd25-security-drop-user
                        sSQL = "DROP USER " + sUser;
                        cmd = new FbCommand(sSQL, conn);
                        cmd.ExecuteNonQuery();
                    } // using conn
                    //
http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.complete.aspx
                    scope.Complete();
                } // using scope


[image: Inline images 1]

Problem with accented letters in charset NONE
---------------------------------------------

                 Key: DNET-712
                 URL: http://tracker.firebirdsql.org/browse/DNET-712
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.6.0.0
         Environment: Firebird 2.5.6, Visual Studio Community 2015, C# 6.0, .Net Framework 4.5.1, Windows 10 Home
            Reporter: Marcos Gerene Felix Spirito
            Assignee: Jiri Cincura


In this version, the ç, ê, ã and others like these are broken and show "?".

So, I downgrade to 5.5.0.0 and it's works ok again.

The example:

StringBuilder stringConnection = new StringBuilder();
stringConnection.AppendLine("User=SYSDBA;Password=masterkey;Database="+caminhoBanco+";DataSource="+ipServidor+";");
stringConnection.AppendLine("Port=" + portaFirebird + ";Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;");
stringConnection.AppendLine("MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;");

var connection = new FbConnection(stringConnection.ToString().Trim());
connection.Open();
var command = new FbCommand("SELECT * FROM EMPRESA WHERE EMP_ID = 1", connection);
var rd = new command..ExecuteReader();
string test = "";
if (rd.Read())
{
   test = rd["EMP_RAZAO"].ToString();	
}

The string "test" returns "CONSTRU??O" in 5.6.0.0 (bug) and "CONSTRUÇÃO" in 5.5.0.0 (ok).

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

       

Throw NotSupportedException for CROSS/OUTER apply
-------------------------------------------------

                 Key: DNET-711
                 URL: http://tracker.firebirdsql.org/browse/DNET-711
             Project: .NET Data provider
          Issue Type: Task
          Components: Entity Framework support
    Affects Versions: 5.6.0.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

        

More info:
http://blog.cincura.net/233580-ado-net-provider-5-6-0-0-for-firebird-is-ready-with-net-core-support/
.

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