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

Re: [Firebird-net-provider] Transliteration problem with table locks

[Kjell R. <kje...@ma...>]

Den 2018-09-19 kl. 09:35, skrev Mark Rotteveel:
> Note that your sending this to the old firebird-net-provider mailing 
> list (on source forge) not to the new one (on Google Groups).
>
> On 2018-09-18 20:43, Kjell Rilbe wrote:
>> In firebird-devel, Mark Rotteveel pointed out that the .NET provider
>> seems to use Encoding.Default for TPB, which is not a good choice,
>> considering it's system dependent. I assume TPB want a specific
>> encoding, regardless of client platform.
>>
>> Please consider replacing with Encoding.UTF8, as indicated in the same
>> firebird-devel thread, for all strings in TPB.
>
> It is not that simple: for Firebird 2.5 and earlier, using UTF8 for 
> strings in the TPB is incorrect unless the connection character set is 
> UTF8.

Alright, but the most important point is to never use Ecoding.Default 
directly or indirectly (e.g. via string.ToUpper), because it's platform 
dependent and may turn out right sometimes, but sometimes not. Use well 
defined encodings everywhere.

Regards,
Kjell

Re: [Firebird-net-provider] Transliteration problem with table locks

[Mark R. <ma...@la...>]

Note that your sending this to the old firebird-net-provider mailing 
list (on source forge) not to the new one (on Google Groups).

On 2018-09-18 20:43, Kjell Rilbe wrote:
> In firebird-devel, Mark Rotteveel pointed out that the .NET provider
> seems to use Encoding.Default for TPB, which is not a good choice,
> considering it's system dependent. I assume TPB want a specific
> encoding, regardless of client platform.
> 
> Please consider replacing with Encoding.UTF8, as indicated in the same
> firebird-devel thread, for all strings in TPB.

It is not that simple: for Firebird 2.5 and earlier, using UTF8 for 
strings in the TPB is incorrect unless the connection character set is 
UTF8.

Mark

Re: [Firebird-net-provider] Transliteration problem with table locks

[Kjell R. <kje...@ma...>]

Den 2018-09-18 kl. 09:00, skrev Kjell Rilbe:
> Hi,
>
> I've been using Firebird since a long time, using quoted identifiers 
> with Swedish characters åäö in them. I am now at version 3.0.3 (on 
> Windows Server 2016, 64 bit).
>
> Now I tried this code in C# using FirebirClient 6.3.0.0:
>
> /*-----*/
> Dictionary<string, FbTransactionBehavior> locks = new 
> Dictionary<string, FbTransactionBehavior>() {
>   { "KörningInstans", FbTransactionBehavior.Protected | 
> FbTransactionBehavior.LockWrite },
>   { "Körning", FbTransactionBehavior.Protected | 
> FbTransactionBehavior.LockWrite }
> };
> FbTransaction trans = connection.BeginTransaction(new 
> FbTransactionOptions() {
>   LockTables = locks,
>   TransactionBehavior = FbTransactionBehavior.Consistency | 
> FbTransactionBehavior.Write
> });
> /*-----*/
>
> The BeginTransaction call fails with an exception "arithmetic 
> exception, numeric overflow, or string truncation
> Cannot transliterate character between character sets". Error code in 
> the exception is 335544321. SQLSTATE 22000. It contains 3 errors:
> 1. type 1, error code 335544321, no message.
> 2. type 1, error code 335544565, no message.
> 3. type 0, error code 335544321, message "arithmetic exception, 
> numeric overflow, or string truncation\r\nCannot transliterate 
> character between character sets".
>
> The database is created like this in isql:
> create database 'KorningarDev' user DEV password '***' page_size 4096 
> set names 'UTF8' default character set UTF8 collation UNICODE;
>
> And the connection string looks like this:
> Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User=DEV;Password=*** 
>
>
> So, I see no reason why there would be any transliteratio problems: 
> Windows unicode -> UTF8, and then UTF8 all the way, right?
>
> What might be going on here? Anything I might be doing wrong? Bug in 
> .NET FirebirdClient? Bug in Firebird itself?
>
> Regards,
> Kjell Rilbe

In firebird-devel, Mark Rotteveel pointed out that the .NET provider 
seems to use Encoding.Default for TPB, which is not a good choice, 
considering it's system dependent. I assume TPB want a specific 
encoding, regardless of client platform.

Please consider replacing with Encoding.UTF8, as indicated in the same 
firebird-devel thread, for all strings in TPB.

Also, please consider replacing ALL string.ToUpper() and other string 
methods with methods that use a well defined (not platform dependent) 
encoding, i.e. string.ToUpperInvariant(). string.ToUpper() also uses 
Encoding.Default, an so has the same problems as with TPB above.

Finally, when designing test cases, I hope support for non-ascii 
characters in various places are considered and covered.

I wish I could help out better, i.e. fix stuff myslef and submit pull 
requests, but I'm afraid I would need to study the innards of FIrebird 
communication a few years before being able to fix more than I destroy. :-)

Regards,
Kjell

[Firebird-net-provider] Transliteration problem with table locks

[Kjell R. <kje...@ma...>]

Hi,

I've been using Firebird since a long time, using quoted identifiers 
with Swedish characters åäö in them. I am now at version 3.0.3 (on 
Windows Server 2016, 64 bit).

Now I tried this code in C# using FirebirClient 6.3.0.0:

/*-----*/
Dictionary<string, FbTransactionBehavior> locks = new Dictionary<string, 
FbTransactionBehavior>() {
   { "KörningInstans", FbTransactionBehavior.Protected | 
FbTransactionBehavior.LockWrite },
   { "Körning", FbTransactionBehavior.Protected | 
FbTransactionBehavior.LockWrite }
};
FbTransaction trans = connection.BeginTransaction(new 
FbTransactionOptions() {
   LockTables = locks,
   TransactionBehavior = FbTransactionBehavior.Consistency | 
FbTransactionBehavior.Write
});
/*-----*/

The BeginTransaction call fails with an exception "arithmetic exception, 
numeric overflow, or string truncation
Cannot transliterate character between character sets". Error code in 
the exception is 335544321. SQLSTATE 22000. It contains 3 errors:
1. type 1, error code 335544321, no message.
2. type 1, error code 335544565, no message.
3. type 0, error code 335544321, message "arithmetic exception, numeric 
overflow, or string truncation\r\nCannot transliterate character between 
character sets".

The database is created like this in isql:
create database 'KorningarDev' user DEV password '***' page_size 4096 
set names 'UTF8' default character set UTF8 collation UNICODE;

And the connection string looks like this:
Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User=DEV;Password=***

So, I see no reason why there would be any transliteratio problems: 
Windows unicode -> UTF8, and then UTF8 all the way, right?

What might be going on here? Anything I might be doing wrong? Bug in 
.NET FirebirdClient? Bug in Firebird itself?

Regards,
Kjell Rilbe

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

[Mark R. <ma...@la...>]

You are posting to the old list. The list has moved to Google Groups.

Subscribe by sending a mail to:
fir...@go...

or by visiting
https://groups.google.com/forum/#!forum/firebird-net-provider

Mark

On 16-11-2017 15:33, LtColRDSChauhan wrote:
> Hello,
> 
> 1. I need to frequently copy a table from one database to another. This 
> has started to fail now, apparently due to increase in number of 
> records. Attempting to copy about 13,26,000 records fails reporting 
> “Error reading data from the connection”. Number of records that I can 
> still successful copy is about 13,24,510.
> 
> 3. I copy the in batches of 50,000 records (variable) each. For each 
> batch, i open and close connection. I have tried setting connection 
> pooling true and false both. Also varied the batch size to 5000, 100000 etc.
> 
> 2. My database and client are on the same machine. Other details:
> 
> RAM 16 GB
> 
> Client application 64 Bit
> 
> OS Windows 10 64 Bit
> 
> Firebird ADO.NET <http://ADO.NET> Data Provider – tried both: 5.11.0.0 
> and 5.12.0
> 
> Firebird 3.0.2.32703_0_Win64
> 
> 3. Please suggest possible solutions.
> 
> Regards,
> 
> Rajiv
> 
> 
> 
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> 
> 
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 


-- 
Mark Rotteveel

[Firebird-net-provider] [FB-Tracker] Created: (DNET-851) Can't connect with mixed case user name

[Kjell R. (JIRA) <tr...@fi...>]

Can't connect with mixed case user name
---------------------------------------

                 Key: DNET-851
                 URL: http://tracker.firebirdsql.org/browse/DNET-851
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 6.3.0.0
         Environment: Firebird 3.0.3 64 bit, Windows Server 2016 64 bit, .NET Framework 4.7.1, Visual Studio 2017 Community, C# console application.
            Reporter: Kjell Rilbe
            Assignee: Jiri Cincura
            Priority: Minor


I created a user and database in isql connected to security3.db:

create user "KorningarDev" password '***';
create database 'KorningarDev' user "KorningarDev" password '***' page_size 4096 set names 'UTF8' default character set UTF8 collation UNICODE;

I can use this database from FlameRobin, specifying the user name with quotes "KorningarDev". But I can't connect to it from the FirebirdClient. I've tried several different variations of connection string, but nothing works.

With a uppercase user, this connection string works:

Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User=DEV;Password=***

With the mixed case user name, none of these semm to work:

Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User=KorningarDev;Password=***
Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User="KorningarDev";Password=***
Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User='KorningarDev';Password=***

I would assume that the FirebirdClient, along the way, loses the quotes on the user name, causing the login request to attemt login with an uppercased username KORNINGARDEV.

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-850) Incorrect SQL generated when 2 or more columns should be returned on update

[Georgi P. (JIRA) <tr...@fi...>]

Incorrect SQL generated when 2 or more columns should be returned on update
---------------------------------------------------------------------------

                 Key: DNET-850
                 URL: http://tracker.firebirdsql.org/browse/DNET-850
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework Core
    Affects Versions: 6.3.0.0
            Reporter: Georgi Panayotov
            Assignee: Jiri Cincura


When I have 2 or more columns that are calculated and they should be returned on update then wrong SQL is generated. I found this on https://github.com/ralmsdeveloper/EntityFrameworkCore.FirebirdSQL ,  but as I see the code this should appear here too.
The generated code is like:
...
RETURNING COLUMN1 INTO :COLUMN1, COLUMN2 INTO :COLUMN2
...

but it should be:
RETURNING COLUMN1, COLUMN2 INTO :COLUMN1, :COLUMN2

I've created a fork to try to fix the issue - the commit is:
https://github.com/gpanayotov/FirebirdSql.Data.FirebirdClient/commit/17e3255d32a9ca573b7e21d8fb6314a4d98b510c

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-849) WIN1251 is invalid character on .Net Core projects

[jack128 (JIRA) <tr...@fi...>]

WIN1251 is invalid character on .Net Core projects
--------------------------------------------------

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


Project:

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <OutputType>Exe</OutputType>
    <TargetFrameworks>netcoreapp2.1;net461</TargetFrameworks>
  </PropertyGroup>

  <ItemGroup>
    <PackageReference Include="FirebirdSql.Data.FirebirdClient" Version="6.3.0" />
  </ItemGroup>

</Project>

Code:

class Program
    {
        static void Main(string[] args)
        {
            Test();            
            Console.ReadKey();
        }

        static void Test()
        {
            var connectionString = new FbConnectionStringBuilder 
            { 
                Charset = "WIN1251",
                Database = "localhost:D:\\DataBases\\CM\\New2\\CMBASE (2).FDB",
                UserID = "SYSDBA",
                Password = "masterkey"                
            };           
            
            var connection = new FbConnection(connectionString.ToString());
            try
            {
                connection.Open();
                Console.WriteLine("Connection is successful");
            }
            catch (Exception e)
            {
                Console.Write("ERROR: ");
                Console.WriteLine(e);                
            }
            finally
            {
                connection.Close();
            }            
        }
    }

build project, run \bin\Debug\net461\MultiTargetConsoleApp.exe, output: "Connection is successful"   as expected
but when you run core version dotnet .\bin\Debug\netcoreapp2.1\MultiTargetConsoleApp.dll     output: ERROR: FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Invalid character set specified

If I set charset to NONE, error is disappear.


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

        

[Firebird-net-provider] [FB-Tracker] Reopened: (DNET-846) Query´s to an older FB1.5-Server causes SQLDA-error

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

     [ http://tracker.firebirdsql.org/browse/DNET-846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jiri Cincura reopened DNET-846:
-------------------------------


> Query´s to an older FB1.5-Server causes SQLDA-error
> ---------------------------------------------------
>
>                 Key: DNET-846
>                 URL: http://tracker.firebirdsql.org/browse/DNET-846
>             Project: .NET Data provider
>          Issue Type: Bug
>    Affects Versions: 6.2.0.0
>         Environment: Client: Windows 10 x64, Server: Windows Server 2016 with FB1.5.6.5026
>            Reporter: Andreas Franz
>            Assignee: Jiri Cincura
>
> Sometimes (not reproducible) I get an non-specific "SQLDA"-error, if a simple query is send to an FB1.5 server. On server-side, there´s an error 10054 in logfile.
> I can´t update to a newer Firebird-server version because of an older expensive special software with BDE-access. 
> Older providers (I guess <4.5) didn´t have this problem. I have updated provider to 6.2, because of an additional FB2.5-server I have to connect, too (in same application).
> Is FB1.5 incompatible with newer providers? Are there any examples for detailled error-handling?

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

       

[Firebird-net-provider] [FB-Tracker] Created: (DNET-848) REOPEN -Query´s to an older FB1.5-Server causes SQLDA-error

[Andreas F. (JIRA) <tr...@fi...>]

REOPEN -Query´s to an older FB1.5-Server causes SQLDA-error
-----------------------------------------------------------

                 Key: DNET-848
                 URL: http://tracker.firebirdsql.org/browse/DNET-848
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 6.2.0.0
         Environment: Client: Windows 10 x64, Server: Windows Server 2016 with FB1.5.6.5026
            Reporter: Andreas Franz
            Assignee: Jiri Cincura


Sometimes (not reproducible) I get an non-specific "SQLDA"-error, if a simple query is send to an FB1.5 server. On server-side, there´s an error 10054 in logfile.
I can´t update to a newer Firebird-server version because of an older expensive special software with BDE-access. 
Older providers (I guess <4.5) didn´t have this problem. I have updated provider to 6.2, because of an additional FB2.5-server I have to connect, too (in same application).
Is FB1.5 incompatible with newer providers? Are there any examples for detailled error-handling?


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

       

[Firebird-net-provider] [FB-Tracker] Created: (DNET-847) ReadBuffer might overwrite items on resizing

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

ReadBuffer might overwrite items on resizing
--------------------------------------------

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


When the write position is before (after wrap) read position and resize happens, the read items might be overwritten if enough is written to the buffer.

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-846) Query´s to an older FB1.5-Server causes SQLDA-error

[Andreas F. (JIRA) <tr...@fi...>]

Query´s to an older FB1.5-Server causes SQLDA-error
---------------------------------------------------

                 Key: DNET-846
                 URL: http://tracker.firebirdsql.org/browse/DNET-846
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 6.2.0.0
         Environment: Client: Windows 10 x64, Server: Windows Server 2016 with FB1.5.6.5026
            Reporter: Andreas Franz
            Assignee: Jiri Cincura


Sometimes (not reproducible) I get an non-specific "SQLDA"-error, if a simple query is send to an FB1.5 server. On server-side, there´s an error 10054 in logfile.
I can´t update to a newer Firebird-server version because of an older expensive special software with BDE-access. 
Older providers (I guess <4.5) didn´t have this problem. I have updated provider to 6.2, because of an additional FB2.5-server I have to connect, too (in same application).
Is FB1.5 incompatible with newer providers? Are there any examples for detailled error-handling?


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

       

[Firebird-net-provider] [FB-Tracker] Created: (DNET-845) error 10054 on fbserver if I exit my application (FbRemoteEvent-usage)

[Andreas F. (JIRA) <tr...@fi...>]

error 10054 on fbserver if I exit my application (FbRemoteEvent-usage)
----------------------------------------------------------------------

                 Key: DNET-845
                 URL: http://tracker.firebirdsql.org/browse/DNET-845
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 6.2.0.0
         Environment: Client: Windows 10 x64, Server: Windows Server 2016 with Firebird-Server 2.5.8.27089
            Reporter: Andreas Franz
            Assignee: Jiri Cincura


Closing an application with FbRemoteEvent-usage causes an 10054 error in firebird.log. "CancelEvent" and "Dispose" has no effect. Seems connection is terminated hard on application exit.

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-844) NullReferenceException on Version10.GdsDatabase.BeginTransaction(TransactionParameterBuffer tpb)

[Christian B (JIRA) <tr...@fi...>]

NullReferenceException on Version10.GdsDatabase.BeginTransaction(TransactionParameterBuffer tpb)
------------------------------------------------------------------------------------------------

                 Key: DNET-844
                 URL: http://tracker.firebirdsql.org/browse/DNET-844
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.12.1.0
         Environment: WindowsServer 2012R2
Firebird-Server Version 2.5.4
EntityFramework Version 6.1.3
EntityFramework.Firebird Version 5.12.1.0
Provider Version 5.12.1.0
Provider Version 5.12.1.0
            Reporter: Christian B
            Assignee: Jiri Cincura
            Priority: Critical


It happens every few days, that we get NullReferenceException in our web-service. This happens on select and also on update (save changes). We can now only "fix" it, when we restart the web-service (pool). 

Callstack - Select: It happens on ToList(), First(), FirstOrDefault()

System.NullReferenceException Void BeginTransaction(FirebirdSql.Data.Common.TransactionParameterBuffer)    bei FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction(TransactionParameterBuffer tpb)
   bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.BeginTransaction(TransactionParameterBuffer tpb)
   bei FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction()
   bei FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
   bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
   bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   bei System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   bei System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   bei System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   bei System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   bei System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
   bei System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   bei System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
   bei System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   bei System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   bei System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
  
Callstack - Update:
   
System.NullReferenceException Void BeginTransaction(FirebirdSql.Data.Common.TransactionParameterBuffer)    bei FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction(TransactionParameterBuffer tpb)
   bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.BeginTransaction(TransactionParameterBuffer tpb)
   bei FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction()
   bei FirebirdSql.Data.FirebirdClient.FbConnectionInternal.BeginTransaction(IsolationLevel level, String transactionName)
   bei FirebirdSql.Data.FirebirdClient.FbConnection.BeginDbTransaction(IsolationLevel isolationLevel)
   bei System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   bei System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.BeginTransaction(DbConnection connection, BeginTransactionInterceptionContext interceptionContext)
   bei System.Data.Entity.Core.EntityClient.EntityConnection.BeginDbTransaction(IsolationLevel isolationLevel)
   bei System.Data.Entity.Core.EntityClient.EntityConnection.BeginTransaction()
   bei System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   bei System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction)
   bei System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)
   bei System.Data.Entity.Internal.InternalContext.SaveChanges()
   bei BetAdmin.Data.BetAdminContext.SaveChanges()

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-843) Provide InfoMessage event for DbService

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

Provide InfoMessage event for DbService
---------------------------------------

                 Key: DNET-843
                 URL: http://tracker.firebirdsql.org/browse/DNET-843
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 6.1.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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-842) Support for CryptKeyCallback handling in DropDatabase

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

Support for CryptKeyCallback handling in DropDatabase
-----------------------------------------------------

                 Key: DNET-842
                 URL: http://tracker.firebirdsql.org/browse/DNET-842
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 6.1.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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-841) Support for CryptKeyCallback handling in CreateDatabase

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

Support for CryptKeyCallback handling in CreateDatabase
-------------------------------------------------------

                 Key: DNET-841
                 URL: http://tracker.firebirdsql.org/browse/DNET-841
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 6.1.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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-840) Bug if use Replace with parameter

[jack128 (JIRA) <tr...@fi...>]

Bug if use Replace with parameter
---------------------------------

                 Key: DNET-840
                 URL: http://tracker.firebirdsql.org/browse/DNET-840
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 6.1.0.0
         Environment: win64, fb3.0.1
            Reporter: jack128
            Assignee: Jiri Cincura


script to create db:

CREATE DATABASE 'localhost:C:\Data\TEMP_3ED4BB49-EE30-4D79-8038-EBC5C24C536D.FDB'
USER 'SYSDBA' PASSWORD 'masterkey';

create table TempTable (caption varchar(255));

insert into TempTable values('1'); 
commit;

test:
        static void Main(string[] args)
        {
            var filename = @"C:\Data\Temp_3ED4BB49-EE30-4D79-8038-EBC5C24C536D.fdb";
 
            var connectionString = new FbConnectionStringBuilder
            {
                UserID = "SYSDBA",
                Password = "masterkey",
                Database = filename,
            }.ConnectionString;

            using (var conn = new FbConnection(connectionString))
            {
                conn.Open();
                using (var command = conn.CreateCommand())
                {
                    const string sql = @"select * from TempTable t where t.caption like Replace(@p, '~', '~~')"; // this query does not return row, although should
                    //const string sql = @"select * from TempTable t where t.caption like @p"; // this query returns row as expected

                    command.CommandText = sql;
                    var p = command.CreateParameter();
                    p.ParameterName = "p";
                    p.Value = "1";
                    command.Parameters.Add(p);

                    using (var reader = command.ExecuteReader())
                    {
                        if (!reader.Read())
                            throw new Exception("1 row should be returned");
                    }
                }
            }
        }


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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-838) Support for DROP PACKAGE in FbScript

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

Support for DROP PACKAGE in FbScript
------------------------------------

                 Key: DNET-838
                 URL: http://tracker.firebirdsql.org/browse/DNET-838
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 6.1.0.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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-839) Support for DROP PACKAGE BODY in FbScript

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

Support for DROP PACKAGE BODY in FbScript
-----------------------------------------

                 Key: DNET-839
                 URL: http://tracker.firebirdsql.org/browse/DNET-839
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 6.1.0.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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-837) Windows Trusted Authentication Exception when it is tried by PC outside domain

[Luciano M. (JIRA) <tr...@fi...>]

Windows Trusted Authentication Exception when it is tried by PC outside domain
------------------------------------------------------------------------------

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


Inittial Setup
- Firebird Server under Windows Active Directory domain (e.g.: CINMOTO)
- .NET Client application installed on a PC outside Active directory control (e.g.: Windows 10 Professional without registered on CINMOTO domain)
- Client user (PC_NAME\USER_NAME) is on RDB$ADMIN database (e.g.: THUNDERBOY\LURON)

Step to reproduce this issue:
- Try to connect to the database without provide password (Windows Trusted Authentication)

Actual Result
============================================
System.Exception: InitializeSecurityContext failed
   em FirebirdSql.Data.Client.Managed.SspiHelper.GetClientSecurity(Byte[] serverToken)
   em FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.ProcessTrustedAuthResponse(SspiHelper sspiHelper, IResponse& response)
   em FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.AttachWithTrustedAuth(DatabaseParameterBuffer dpb, String dataSource, Int32 port, String database, Byte[] cryptKey)
   em FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
   em FirebirdSql.Data.FirebirdClient.FbConnection.Open()
============================================

Expected Result
- No exception should happen

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-836) FB3 bool support in EF

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

FB3 bool support in EF
----------------------

                 Key: DNET-836
                 URL: http://tracker.firebirdsql.org/browse/DNET-836
             Project: .NET Data provider
          Issue Type: New Feature
          Components: Entity Framework
    Affects Versions: 6.0.0.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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-834) Support for CREATE PACKAGE in FbScript

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

Support for CREATE PACKAGE in FbScript 
---------------------------------------

                 Key: DNET-834
                 URL: http://tracker.firebirdsql.org/browse/DNET-834
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 6.0.0.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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-835) Support for CREATE PACKAGE BODY in FbScript

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

Support for CREATE PACKAGE BODY in FbScript
-------------------------------------------

                 Key: DNET-835
                 URL: http://tracker.firebirdsql.org/browse/DNET-835
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 6.0.0.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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-833) "Unable to enlist in transaction, a local transaction already exists" in multithreaded environments

[Daniel H (JIRA) <tr...@fi...>]

"Unable to enlist in transaction, a local transaction already exists" in multithreaded environments
---------------------------------------------------------------------------------------------------

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


We are developing an ASP.NET Core (.NET Core Version 2.1.1) web application. 
We are using a Firebird 3 Connection Pool with the following options in the connection string:

- Pooling: True
- MinPoolSize: 0
- MaxPoolSize: 50
- Auto_Commit: false
- Enlist: true

On serveral occasions we receive the following exception: 
"Unable to enlist in transaction, a local transaction already exists".

This happens in our minimal breaking exampple, if we call the following code with a few threads over HTTP GET:

        [HttpGet]
        public async Task<IActionResult> GetX()
        {
            IEnumerable<string> x= null;
            using (var ts = new TransactionScope( TransactionScopeAsyncFlowOption.Enabled))
            {
                using (var connection = new FbConnection(connectionString))
                {
                    roles = await connection.QueryAsync<string>(
                        sql: "SELECT strField FROM X",
                        commandType: CommandType.Text);
                }
                ts.Complete();
            }
            return Ok(x);
        }

If we encapsulate the TransactionScope block with a Semaphore it runs fine.
Therefore the question: Does this library supporting multithreading or do we need to protect Firebird calls with a semaphore?


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