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

[Firebird-net-provider] ADO.NET provider for Firebird 4.1.5.0 is ready

[Jiri C. <di...@ci...>]

ADO.NET provider for Firebird 4.1.5.0 is ready:
http://blog.cincura.net/233450-ado-net-provider-for-firebird-4-1-5-0-is-ready/

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

[Firebird-net-provider] [FB-Tracker] Created: (DNET-551) Fix sql generating for table with only one column

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

Fix sql generating for table with only one column
-------------------------------------------------

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


https://github.com/cincuranet/NETProvider/pull/3

-- 
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] Mystery 3.0.2 revisited

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

On Tue, 8 Apr 2014 14:33:35 +0200, André Knappstein
<Kna...@be...> wrote:
> I don't see my posting from this afternoon, yet.

It showed up in my mailbox around 13:00, and it is also in the archive
http://sourceforge.net/p/firebird/mailman/message/32200411/

Mark

[Firebird-net-provider] Mystery 3.0.2 revisited

[André K. <Kna...@be...>]

I don't see my posting from this afternoon, yet.

Nevertheless, don't bother, please.
Maybe you know the feeling that testing something strange for days and
days  won't  bring you further, you ask someone for help  - like I did
with  this  list  this afternoon - and then you suddenly have the idea
for one more test and finally see clear :-)

I  was  me,  after  all,  nothing  wrong - of course - with FBProvider
handling transactions.

For   some   reason   I   had  changed  an outer to an inner join in a
relevant place and the record I thought missing was not fulfilling the
condition on the first select, but on the second.

regards,
André

[Firebird-net-provider] commit mystery 3.0.2

[André K. <Kna...@be...>]

Hi there,

I  nearly  broke  my  head  around  some  mysterious  behaviour  of my
application, and right now I don't know if this is all natural and WAD
or maybe if there was a bug in 3.0.2 or maybe still is.

First  I'm gonna give a brief description and maybe one of the experts
here  can  tell  me  what  I am probably understanding wrong about how
FBProvider handles transactions.

1.)
Transaction  T1  saves  a  new  record  to  the database, then commits
(certified!).

2.)
T2 selects records from the database, but does not get the
recently saved record. T2 commits.

3.)
T3  is really doing the same as T2 (because I am only calling the very
same method!), but now the missing record is selected.

I am handling transactions like this:

  t = connXY.BeginTransaction();
  ...
  ...
  // do the stuff
  ...
  ...
  t.commit();
  t = null;

All transactions are using the same connection object.
Isolation   level   is   "read   committed";   using  all  the default
values.


I  would have expected T2 to select the record that has been committed
to the database by T1. And I am certainly surprised that simply "asking
the database again" will then yield the record.

T1 most definitely is committed. Of course I am using try/catch and in
addition I checked with other software using "read committed" and they
can already select the new record.


Where  is  my  misconception  in this story? I plan to implement a lot
more  "live"  updates  using  events  and  would like to get immediate
selecting of freshly inserted records working.


mit freundlichen Grüßen,

André Knappstein
EDV und Controlling
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail:  kna...@be...

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402

[Firebird-net-provider] [FB-Tracker] Created: (DNET-550) NotSupportedException occurs when using ServerType embedded

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

NotSupportedException occurs when using ServerType embedded
-----------------------------------------------------------

                 Key: DNET-550
                 URL: http://tracker.firebirdsql.org/browse/DNET-550
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 4.1.0.0
            Reporter: Hennadii
            Assignee: Jiri Cincura


Exception throwed from Common.DbValue.GetBytes
public byte[] GetBytes()
{
...
switch (this.Field.DbDataType)
...
default: throw new NotSupportedException("Unknown data type");

with this.Field.DbDataType equal to DbDataType.Null



-- 
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] DDEX not working on VS2013

[Eric F. <esc...@fr...>]

I think you need to be more specific. 

My other providers work; Sql Server, Oracle, MySql

Just not the firebird DDEX.

There is nothing in the machine config DbProviderFactories for firebird


-----Original Message-----
From: Jiri Cincura [mailto:di...@ci...] 
Sent: Wednesday, March 26, 2014 9:05 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] DDEX not working on VS2013

On Wed, Mar 26, 2014 at 2:57 PM, Eric FE <esc...@fr...>
wrote:
> Shouldn't the installer do that?

The *ADO.NET Provider's* installer does that.

--
Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ |
http://www.ID3renamer.com

----------------------------------------------------------------------------
--
Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the
definitive new guide to graph databases and their applications. Written by
three acclaimed leaders in the field, this first edition is now available.
Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] DDEX not working on VS2013

[Jiri C. <di...@ci...>]

On Wed, Mar 26, 2014 at 2:57 PM, Eric FE <esc...@fr...> wrote:
> Shouldn't the installer do that?

The *ADO.NET Provider's* installer does that.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] DDEX not working on VS2013

[Eric F. <esc...@fr...>]

Shouldn't the installer do that?

-----Original Message-----
From: Jiri Cincura [mailto:di...@ci...] 
Sent: Wednesday, March 26, 2014 3:55 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] DDEX not working on VS2013

On Tue, Mar 25, 2014 at 10:38 PM, Eric FE <esc...@fr...>
wrote:
> When I change any values in the connection dialog, the dialog disappears.

Provider is not registered in GAC matching machine.config (or vice versa).

--
Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ |
http://www.ID3renamer.com

----------------------------------------------------------------------------
--
Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the
definitive new guide to graph databases and their applications. Written by
three acclaimed leaders in the field, this first edition is now available.
Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.

[Joël G. <J.G...@fa...>]

Hi Firebird-net-provider,

Still no solution, has anyone an idea how to fix this? I have the idea, EF still finds traces of the old version of the Firebird .Net provider… What I also saw is that the Firebird .Net provider EF6 is only on NuGet and not as an install, so Windows has no notice of the new driver.

Kind regards,

Joël Gijbels.

Van: Joël Gijbels
Verzonden: woensdag 19 maart 2014 9:29
Aan: 'mc...@mc...'; fir...@li...
Onderwerp: RE: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.

HI Marco,

Thanks for your response. I forgot to mention that in my initial quest. Yes, I did do that. Here is the content of my App.config fil:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <system.data>
    <DbProviderFactories>
      <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />
    </DbProviderFactories>
  </system.data>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" />
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
</configuration>

Kind regards,

Joël Gijbels

Van: Marco Castro - McSoft [mailto:mc...@mc...]
Verzonden: dinsdag 18 maart 2014 19:19
Aan: Joël Gijbels; fir...@li...<mailto:fir...@li...>
Onderwerp: RE: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.



Hello Joel,
Did you configured your App.config file with this provider configuration?
<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.1" />
  </startup>
  <system.data>
    <DbProviderFactories>
      <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />
    </DbProviderFactories>
  </system.data>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" />
    </providers>
  </entityFramework>
</configuration>

          Best  regards,
Marco Aurelio Castro
Director
McSoft
McSoft<http://www.mcsoft.com.br> | A Empresa<http://www.mcsoft.com.br/TextoGenerico.aspx?FileName=fnEmpresa.htm> | Nosso sistema<http://www.mcsoft.com.br/TextoGenerico.aspx?FileName=fnSolucoes.htm>
[Facebook]<http://www.facebook.com/McSoftBH>[Twitter]<http://twitter.com/mcsoft>


----- Original Message -----
From: Joël Gijbels [mailto:J.G...@fa...]
To: fir...@li...<mailto:fir...@li...>
Sent: Tue, 18 Mar 2014 11:00:26 +0000
Subject: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.
Hi Firebird-net-provider,

As a .Net developer I have been asked to connect to a Firebird database via Entity Framework. I installed both the Data Provider and the DDEX.

[cid:image002.jpg@01CF3497.1BAF19C0]

Via NuGet I added Entity Framework 6.0.2 and the Firebird ADO.NET Data Provider (Entity Framework 6).

[cid:image004.jpg@01CF3497.1BAF19C0]

So far so good, I managed to open the ADO.Net Entity Data Model wizard, select the correct database for a database first approach. But then I get this confusing error according to the version of the database provider I have installed.

[cid:image009.jpg@01CF3497.1BAF19C0]

Any help would be appreciated. If you need more info, please let me know.

Thanks in advance for your advice.

Kind regards,

Joël Gijbels.

Re: [Firebird-net-provider] Connection close after culture change

[Lukáš V. <l.v...@gm...>]

It's working ok.

Thank you, for quick fix.




2014-03-25 8:27 GMT+01:00 Jiri Cincura <di...@ci...>:

> Done. You can get the build and test it from
>
> https://ci.appveyor.com/api/buildjobs/scoyb237n16urixi/artifacts/NETProvider/source/FirebirdSql/Data/bin/Release_45/FirebirdSql.Data.FirebirdClient.dll
> (I'm currently testing AppVeyor ;), handy right now)
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] DDEX not working on VS2013

[Jiri C. <di...@ci...>]

On Tue, Mar 25, 2014 at 10:38 PM, Eric FE <esc...@fr...> wrote:
> When I change any values in the connection dialog, the dialog disappears.

Provider is not registered in GAC matching machine.config (or vice versa).

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

[Firebird-net-provider] DDEX not working on VS2013

[Eric F. <esc...@fr...>]

Hello,

 

I'm trying to use the DDEX Provider Version 3.0.1 in VS2013, but it's not
working.

 

When I change any values in the connection dialog, the dialog disappears.

 

Has anyone got the DDEX provider working in VS2013?

 

 

I'm in the process of adding Firebird support to my ORM.

 

Thanks,

 

 

Eric Schneider

 

Frozen Elephant Inc.

739 N. Thompson Dr. #207

Madison, WI

53704

 

Re: [Firebird-net-provider] Connection close after culture change

[Jiri C. <di...@ci...>]

Done. You can get the build and test it from
https://ci.appveyor.com/api/buildjobs/scoyb237n16urixi/artifacts/NETProvider/source/FirebirdSql/Data/bin/Release_45/FirebirdSql.Data.FirebirdClient.dll
(I'm currently testing AppVeyor ;), handy right now)

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

[Firebird-net-provider] Question about the Firebird .Net Client for EF6.

[Joël G. <J.G...@fa...>]

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech

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

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

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

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


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

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

        this.Culture = "cs-CZ";

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

        fbc.Close();

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

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

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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

Re: [Firebird-net-provider] Connection close after culture change

[Jiri C. <di...@ci...>]

On Fri, Mar 21, 2014 at 10:18 AM, Lukáš Vykydal <l.v...@gm...> wrote:
> i found interesting bug

Yeah. Good catch. Can you please report it to tracker, I'll solve it quickly.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Unique Constraint Exception thrown when it shouldn't

[David De S. <ida...@gm...>]

Hi Jiri,

It was indeed a violation of unique constraint.
However, specifying Dialect 3 worked without any problem.

Thank you,
David


On Thu, Mar 20, 2014 at 1:59 AM, Jiri Cincura <di...@ci...> wrote:

> What's the complete message? Isn't it a violation on PK?
>
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] DB Type decimal is not returning as decimal

[David De S. <ida...@gm...>]

Hi,

Sorry for late reply.

> What is the precision and scale of the DECIMAL?

Is 18,2

> Have you created a dialect 1 (deprecated) or dialect 3 database?

I haven't specified any dialect. I thought that without specifying one it
would set the default to 3 but it isn't.
I created again the DB using dialect 3 and it is working without any
problem. The return value is not decimal.

Btw, is there a reason why the dialect defaults to 1 instead of 3 when
using FbConnectionStringBuilder?

Thank you,
David


On Thu, Mar 20, 2014 at 4:05 AM, Mark Rotteveel <ma...@la...>wrote:

> On Thu, 20 Mar 2014 03:51:23 -0600, David De Smet <ida...@gm...>
> wrote:
> > I'm using LLBLGen for creating the script and model.
> >
> > The script for creating the DB is DECIMAL, so is the DB end result. I
> > verified with Flamerobin.
>
> What is the precision and scale of the DECIMAL?
>
> > The model is also decimal and when writing .NET code the value I'm
> passing
> > for save is decimal. But as said, the return value is Int64 or long if
> > coding in C#.
> >
> > I'm using Firebird Embedded.
>
> Have you created a dialect 1 (deprecated) or dialect 3 database?
>
> Mark
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] FbClient v4.0.30319

[Jiri C. <di...@ci...>]

On Fri, Mar 21, 2014 at 4:06 PM, E. D. Epperson Jr
<dix...@gm...> wrote:
> I 'stumbled' across some code that gave me a pretty good idea.  Here is what
> I came up with, is this a good way of doing it?  Also
> what would I use for Chaos?  What is a good value for the waittimeout?

You can check sources directly. Either you use the .NET enum for TIL
or you can directly use the ISC values if you need something to
fine-tune and you know what you're doing. :) Check
https://github.com/cincuranet/NETProvider/blob/master/NETProvider/source/FirebirdSql/Data/FirebirdClient/FbTransaction.cs
.

Timeout is anything from one second up, that's how Firebird handles it.

> Finally, I need to verify my understanding of the Wait and WaitTimeout.
> Wait says if another transaction has the record, wait until either the
> record is available or until the timeout expires.  If no other transaction
> has the record, proceed with no waiting.  Is that correct?

Basically yes.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] FbClient v4.0.30319

[E. D. E. J. <dix...@gm...>]

I 'stumbled' across some code that gave me a pretty good idea.  Here is
what I came up with, is this a good way of doing it?  Also
what would I use for Chaos?  What is a good value for the waittimeout?

Finally, I need to verify my understanding of the Wait and WaitTimeout.
 Wait says if another transaction has the record, wait until either the
record is available or until the timeout expires.  If no other transaction
has the record, proceed with no waiting.  Is that correct?

here is my sample code.

public enum TransIsoLvl
{
  Chaos
, ReadCommitted
, ReadUnCommitted
, RepeatableRead
, Serializable
, Snapshot
, Unspecified
}

private FbTransactionOptions buildTransOpt(TransIsoLvl isolvl)
{
FbTransactionOptions fbopt = new FbTransactionOptions();
fbopt.TransactionBehavior = FbTransactionBehavior.Wait;
fbopt.WaitTimeout = new TimeSpan(_transtimeout);
switch (isolvl)
{
case TransIsoLvl.ReadCommitted:
fbopt.TransactionBehavior |= FbTransactionBehavior.ReadCommitted;
fbopt.TransactionBehavior |= FbTransactionBehavior.NoRecVersion;
break;
case TransIsoLvl.ReadUnCommitted:
fbopt.TransactionBehavior |= FbTransactionBehavior.ReadCommitted;
fbopt.TransactionBehavior |= FbTransactionBehavior.RecVersion;
break;
case TransIsoLvl.RepeatableRead:
fbopt.TransactionBehavior |= FbTransactionBehavior.Concurrency;
break;
case TransIsoLvl.Serializable:
fbopt.TransactionBehavior |= FbTransactionBehavior.Consistency;
break;
case TransIsoLvl.Snapshot:
fbopt.TransactionBehavior |= FbTransactionBehavior.Concurrency;
break;
}
return fbopt;
}

// then to use, here is an example of use

public void DataAdapterFillDSWTrans(DataSet ds, string sprocname,
SProcParam[] parms, TransIsoLvl isolvl = TransIsoLvl.Snapshot)
{
if (ReinitializeConnection())
{
using (FbTransaction trans = conn.BeginTransaction(buildTransOpt(isolvl)))
{

Dixon


On Fri, Mar 21, 2014 at 10:36 AM, E. D. Epperson Jr <dix...@gm...
> wrote:

> Pardon my ignorance but is there any documentation on FbTransaction and
> FbTransactionOptions?
>
> What I want to do is start a transaction with IsolationLevel of snapshot,
> and with wait timeout of 1/10 second.
>
> Here is what I've come up with, but not sure I've the correct behavior nor
> if this is even smart to do this
>
> FbTransactionOptions fbopt = new FbTransactionOptions();
> fbopt.WaitTimeout = new TimeSpan(1000000);
> fbopt.TransactionBehavior = FbTransactionBehavior.Wait |
> FbTransactionBehavior.Concurrency;
> using(FbTransaction trans = conn.BeginTransaction(fbopt))
> {
> ...
> }
>
> Also, since this is a method called by many other methods, I would like to
> be able to change the IsolationLevel, in code, when needed.  So is this the
> correct way to do it and is there any documentation what behavior equals
> what isolation level?
>
> Dixon
>
>
> On Thu, Mar 20, 2014 at 4:43 PM, Jiri Cincura <di...@ci...> wrote:
>
>> On Thu, Mar 20, 2014 at 3:16 PM, E. D. Epperson Jr
>> <dix...@gm...> wrote:
>> > recommend something I could try to reduce or eliminate the deadlocks
>>
>> Without a knowledge of what and why the program is doing this it's
>> hard to have some advice. Basically you want to eliminate the records
>> being updated from two transactions at the same time.
>>
>>
>> --
>> Jiri {x2} Cincura (x2develop.com founder)
>> http://blog.cincura.net/ | http://www.ID3renamer.com
>>
>>
>> ------------------------------------------------------------------------------
>> Learn Graph Databases - Download FREE O'Reilly Book
>> "Graph Databases" is the definitive new guide to graph databases and their
>> applications. Written by three acclaimed leaders in the field,
>> this first edition is now available. Download your free book today!
>> http://p.sf.net/sfu/13534_NeoTech
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>
>
> --
> Dixon Epperson
>



-- 
Dixon Epperson

Re: [Firebird-net-provider] FbClient v4.0.30319

[E. D. E. J. <dix...@gm...>]

Pardon my ignorance but is there any documentation on FbTransaction and
FbTransactionOptions?

What I want to do is start a transaction with IsolationLevel of snapshot,
and with wait timeout of 1/10 second.

Here is what I've come up with, but not sure I've the correct behavior nor
if this is even smart to do this

FbTransactionOptions fbopt = new FbTransactionOptions();
fbopt.WaitTimeout = new TimeSpan(1000000);
fbopt.TransactionBehavior = FbTransactionBehavior.Wait |
FbTransactionBehavior.Concurrency;
using(FbTransaction trans = conn.BeginTransaction(fbopt))
{
...
}

Also, since this is a method called by many other methods, I would like to
be able to change the IsolationLevel, in code, when needed.  So is this the
correct way to do it and is there any documentation what behavior equals
what isolation level?

Dixon


On Thu, Mar 20, 2014 at 4:43 PM, Jiri Cincura <di...@ci...> wrote:

> On Thu, Mar 20, 2014 at 3:16 PM, E. D. Epperson Jr
> <dix...@gm...> wrote:
> > recommend something I could try to reduce or eliminate the deadlocks
>
> Without a knowledge of what and why the program is doing this it's
> hard to have some advice. Basically you want to eliminate the records
> being updated from two transactions at the same time.
>
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
Dixon Epperson

[Firebird-net-provider] Connection close after culture change

[Lukáš V. <l.v...@gm...>]

Good morning,

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

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

         this.Culture = "cs-CZ";

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

         fbc.Close();

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

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

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

Thank you for answer

Lukáš Vykydal

Re: [Firebird-net-provider] FbClient v4.0.30319

[Jiri C. <di...@ci...>]

On Thu, Mar 20, 2014 at 3:16 PM, E. D. Epperson Jr
<dix...@gm...> wrote:
> recommend something I could try to reduce or eliminate the deadlocks

Without a knowledge of what and why the program is doing this it's
hard to have some advice. Basically you want to eliminate the records
being updated from two transactions at the same time.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] FbClient v4.0.30319

[E. D. E. J. <dix...@gm...>]

I know.  I'm rewriting that part of the code to try to eliminate the
multiple simultaneous hits.  But I had thought Snapshot would eliminate it.
 Can you recommend something I could try to reduce or eliminate the
deadlocks?  I haven't put any WAIT into any of these procedures.  Should I
try that?

Dixon


On Thu, Mar 20, 2014 at 10:12 AM, Jiri Cincura <di...@ci...> wrote:

> That's normal FbException you get from server. Nothing magic. You're
> getting deadlock in your transaction(s).
>
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
Dixon Epperson