firebird-net-provider Mailing List for Firebird

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

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

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

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.

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
>

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

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

 

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

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

       

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

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
>

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
>

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

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

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

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

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

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

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

I finally got an error message on this issue.  Here is the data I pulled,
Maybe this will shed some light on what I'm doing wrong.

ErrorMsg: deadlock
ErrorData: Procedure=DataAdapterReturnDT|SprocName=USPVALIDATESESSION|GUID=7c3713d9-26bd-43f5-ba64-5bd1eb8e3fa1|NEWSESSIONTIMEOUT=20|

ErrorStack:    at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
694
   at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line
245
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at FirebirdDAO.DAO.DataAdapterFillDTWTrans(DataTable dt, String
sprocname, SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 629
   at FirebirdDAO.DAO.DataAdapterReturnDTWTrans(String sprocname,
SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 590
   at CBT.Models.DaoAccess.DataAdapterReturnDT(String procedurename,
SProcParam[] sprocparams, Guid guid, Int32 timeout, String controllerpath,
String ipaddr, String browserinfo, TransIsoLvl isolvl) in
c:\WebSites\CBT\CBT\Models\DaoAccess.cs:line 143

The transaction level is "Snapshot"

a follow up error, with the same transaction level about 11 minutes later:
ErrorMsg: lock conflict on no wait transaction
ErrorData: Procedure=DataAdapterReturnDT|SprocName=USPVALIDATESESSION|GUID=662a1981-a9e9-4fda-b287-3397197f0bbb|NEWSESSIONTIMEOUT=20|
ErrorStack:    at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
694
   at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line
245
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at FirebirdDAO.DAO.DataAdapterFillDTWTrans(DataTable dt, String
sprocname, SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 629
   at FirebirdDAO.DAO.DataAdapterReturnDTWTrans(String sprocname,
SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 590
   at CBT.Models.DaoAccess.DataAdapterReturnDT(String procedurename,
SProcParam[] sprocparams, Guid guid, Int32 timeout, String controllerpath,
String ipaddr, String browserinfo, TransIsoLvl isolvl) in
c:\WebSites\CBT\CBT\Models\DaoAccess.cs:line 143

Dixon


On Wed, Mar 19, 2014 at 3:48 PM, E. D. Epperson Jr
<dix...@gm...>wrote:

> When I hit this line:
> conn.Open();
> it breaks out of that block without throwing an exception.  Actually it
> breaks out of that class completely, but it doesn't return a datatable so
> my calling class experiences a datatable == null exception, which I handle.
>
>
> here is the code sample where I open the connection
>
>             try
>             {
>                 if (conn == null)
>                 {
>                     conn = new FbConnection(_connstr);  -- it breaks out
> here
>                 }
>                 switch (conn.State)
>                 {
>                     case ConnectionState.Closed:
>                         conn.Open();
>                         break;
>                     case ConnectionState.Broken:
>                     case ConnectionState.Connecting:
>                     case ConnectionState.Executing:
>                     case ConnectionState.Fetching:
>                         conn.Close();
>                         conn.Open();
>                         break;
>                 }
>                 return conn.State == ConnectionState.Open;
>             }
> ... then I handle any exception thrown here, except it never throws the
> exception.  I guess it just isn't opening the connection
>
> Dixon
>
>
> On Wed, Mar 19, 2014 at 3:36 PM, Jiri Cincura <di...@ci...> wrote:
>
>> On Wed, Mar 19, 2014 at 8:00 PM, E. D. Epperson Jr
>> <dix...@gm...> wrote:
>> > At some point during every day, after creating the FbConnection, I then
>> > Open.  It apparently throws an error, but my try/catch doesn't catch it.
>>
>> How do you know it throw an exception? Did you tried attaching
>> debugger to VS (from other VS)?
>>
>> --
>> 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

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

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.

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.

David De Smet

Message sent from my iPhone

> On 20/03/2014, at 02:00, Jiri Cincura <di...@ci...> wrote:
> 
> What's the datatype in DB and what's in your model? Very likely you
> have a mismatch there.
> 
> 
> -- 
> 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

What's the datatype in DB and what's in your model? Very likely you
have a mismatch there.


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

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