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

Re: [Firebird-net-provider] FBUserData create new

[David C. <wav...@gm...>]

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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-719) Connection rejected by remote interface - Firebird 1.5 on Linux Server

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

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-718) The auto created triggers can have names which are too long

[Leonard W. (JIRA) <tr...@fi...>]

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-717) NullReferenceException in FbConnectionPoolManager.Release

[Fatal E. (JIRA) <tr...@fi...>]

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

        

Re: [Firebird-net-provider] .NET provider and embedded server

[Wolfgang R. <Wol...@ri...>]

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

Re: [Firebird-net-provider] .NET provider and embedded server

[Jiří Č. <ji...@ci...>]

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] .NET provider and embedded server

[Wolfgang R. <Wol...@ri...>]

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] [FB-Tracker] Created: (DNET-716) Connection to Firebird throws NullReferenceException on mono

[Anton K. (JIRA) <tr...@fi...>]

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-715) FbDataReader should use only Ordinal CS/CI matches for column names

[Workdev T. da I. L. (J. <tr...@fi...>]

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

       

Re: [Firebird-net-provider] Subsequent error 'lock conflict on no wait transaction' using TransactionScope across DBs

[Jiří Č. <ji...@ci...>]

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

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

Re: [Firebird-net-provider] Subsequent error 'lock conflict on no wait transaction' using TransactionScope across DBs

[David C. <wav...@gm...>]

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
>

[Firebird-net-provider] [FB-Tracker] Created: (DNET-714) DbUpdateConcurrencyException is not thrown when expected

[Scot L. (JIRA) <tr...@fi...>]

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-713) FirebirdSql.VisualStudio.DataTools.dll ConnectionProperties is null on Add Connection Dialog

[FEBit B. (J. <tr...@fi...>]

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

       

Re: [Firebird-net-provider] Subsequent error 'lock conflict on no wait transaction' using TransactionScope across DBs

[Jiří Č. <ji...@ci...>]

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

[Firebird-net-provider] Subsequent error 'lock conflict on no wait transaction' using TransactionScope across DBs

[David C. <wav...@gm...>]

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]

[Firebird-net-provider] [FB-Tracker] Created: (DNET-712) Problem with accented letters in charset NONE

[Marcos G. F. S. (JIRA) <tr...@fi...>]

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

       

[Firebird-net-provider] [FB-Tracker] Created: (DNET-711) Throw NotSupportedException for CROSS/OUTER apply

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

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

        

[Firebird-net-provider] ADO.NET provider 5.6.0.0

[Jiří Č. <ji...@ci...>]

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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-710) missing firebird data source visual studio 2015 ( no problem with vs 2013)

[FEBit B. (J. <tr...@fi...>]

missing firebird data source visual studio 2015 ( no problem with vs 2013)
--------------------------------------------------------------------------

                 Key: DNET-710
                 URL: http://tracker.firebirdsql.org/browse/DNET-710
             Project: .NET Data provider
          Issue Type: Bug
          Components: DDEX Provider
    Affects Versions: 5.5.0.0
         Environment: Windows 8.1
            Reporter: FEBit Bilişim
            Assignee: Jiri Cincura


On VS2015 Server Explorer Add Data Connection Data Sources List 
FireBird is missing firebird.

But Working On VS2013 perfect.

installed softwares:
ddex provider for firebird 3.0.2.0 
firebirdClient 5.5.0.0

machineconfig s are modified;
<configSections>
<section name="firebirdsql.data.firebirdclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data,  Version=5.5.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
..
..
<add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=5.5.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
   </DbProviderFactories>


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

       

Re: [Firebird-net-provider] EntitiyFramework and Update

[Геннадий З. <zab...@gm...>]

FB.NET doesn't wait on locks, it returns immediately with exception.
All other known for me  are waiting on locks. That's the behavior you
observe.
You need to override creation of transaction. You should use
FbTransaction with TBP in which you specify waiting option and
timeout.

On 26 October 2016 at 12:27, Gerdus van Zyl <ger...@gm...> wrote:
> I suspect the default transaction option might not be the same in firebird
> and other databases.
> Try setting the IsolationLevel to SERIALIZABLE on the transaction.
>
> On Wed, Oct 26, 2016 at 10:19 AM, Jiří Činčura <ji...@ci...> wrote:
>>
>> There's really nothing EF related. You can try it with multiple console
>> windows with multiple transactions together. It's fundamental way how
>> transactions work.
>>
>> --
>> Mgr. Jiří Činčura
>> Independent IT Specialist
>>
>>
>>
>> ------------------------------------------------------------------------------
>> The Command Line: Reinvented for Modern Developers
>> Did the resurgence of CLI tooling catch you by surprise?
>> Reconnect with the command line and become more productive.
>> Learn the new .NET and ASP.NET CLI. Get your free copy!
>> http://sdm.link/telerik
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
>
> --
> ------------------------------------------------------------------------
> Gerdus van Zyl
> www.infireal.com
>
> ------------------------------------------------------------------------------
> The Command Line: Reinvented for Modern Developers
> Did the resurgence of CLI tooling catch you by surprise?
> Reconnect with the command line and become more productive.
> Learn the new .NET and ASP.NET CLI. Get your free copy!
> http://sdm.link/telerik
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] EntitiyFramework and Update

[Gerdus v. Z. <ger...@gm...>]

I suspect the default transaction option might not be the same in firebird
and other databases.
Try setting the IsolationLevel to SERIALIZABLE on the transaction.

On Wed, Oct 26, 2016 at 10:19 AM, Jiří Činčura <ji...@ci...> wrote:

> There's really nothing EF related. You can try it with multiple console
> windows with multiple transactions together. It's fundamental way how
> transactions work.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------
> ------------------
> The Command Line: Reinvented for Modern Developers
> Did the resurgence of CLI tooling catch you by surprise?
> Reconnect with the command line and become more productive.
> Learn the new .NET and ASP.NET CLI. Get your free copy!
> http://sdm.link/telerik
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
------------------------------------------------------------------------
Gerdus van Zyl
www.infireal.com

Re: [Firebird-net-provider] EntitiyFramework and Update

[Jiří Č. <ji...@ci...>]

There's really nothing EF related. You can try it with multiple console
windows with multiple transactions together. It's fundamental way how
transactions work.

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

Re: [Firebird-net-provider] EntitiyFramework and Update

[Roman P. <rpa...@ak...>]

I added one more db connection into app. This time it was PostgreSql and Postgres worked with same behavior as MySql. I don't know is Postgres real db or not, but it allows to change different fields in one record for concurrent queries.

May be I just can't correctly describe the problem. Jiri, I put archive with source code into google drive https://drive.google.com/file/d/0B8UZY3a6pO3iTkRHZ1NIQVlrS3M/view?usp=sharing . Can you review my code, may be I just lost some specific configuration part or something similar. 

--
Roman Patutin

-----Original Message-----
From: Jiří Činčura [mailto:ji...@ci...] 
Sent: Wednesday, October 26, 2016 7:37 AM
To: fir...@li...
Subject: Re: [Firebird-net-provider] EntitiyFramework and Update

When the two transactions update same record *at the same time*, there's nothing you can do it. One will fail. You can minimize that keeping the transactions as short as possible. Comparing TX handling with MySQL is wrong; I guess you used MyISAM tables, where TXs are virtually non-existent. Try any other real DB and you'll get the same problem.

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

Re: [Firebird-net-provider] EntitiyFramework and Update

[Jiří Č. <ji...@ci...>]

When the two transactions update same record *at the same time*, there's
nothing you can do it. One will fail. You can minimize that keeping the
transactions as short as possible. Comparing TX handling with MySQL is
wrong; I guess you used MyISAM tables, where TXs are virtually
non-existent. Try any other real DB and you'll get the same problem.

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

[Firebird-net-provider] EntitiyFramework and Update

[Roman P. <rpa...@ak...>]

Hi All, 

 

I created simple WinForms application that work with FireBird database.
Database contain only one table with one record with four fields (id,
firstname, secondanme, email).  For emulate a real program flow I start 3
concurrent query for table. Each query update own field (first for email,
second for firstname, third for lastname). After starting program I've got
exception with message "lock conflict on no wait transaction".

 

For testing purpose I changed database from FireBird to MySql and this
exceptions is gone. Configuration for DbContext is the same, I just changed
connection string. 

 

How I can fix this behavior for FireBird net provider and and switch it
close to MySql. 

 

FireBird version: 2.5 

FirebirdSql.Data.FirebirdClient: 4.10

 

--

Roman Patutin