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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-498) Error in double quoting database object names (tables, columns)

[Phosgen T. (JIRA) <tr...@fi...>]

Error in double quoting database object names (tables, columns)
---------------------------------------------------------------

                 Key: DNET-498
                 URL: http://tracker.firebirdsql.org/browse/DNET-498
             Project: .NET Data provider
          Issue Type: Bug
          Components: DDEX Provider
    Affects Versions: 3.0.0.0
         Environment: 1. Windows 7 SP1 x86, Visual Studio 2012, Firebird 2.5.2 x86, DDEX Provider 3.0.0.0, .NET Provider 3.0.2.0
2. Windows 7 SP1 x64, Visual Studio 2012 Update 2, Firebird 2.5.2 x64, DDEX Provider 3.0.0.0, .NET Provider 3.0.2.0
            Reporter: Phosgen Tepes
            Assignee: Jiri Cincura
            Priority: Critical


I create strongly typed data set, drag table which have double quoted name and columns, in this stage everything is ok, but if i delete or cut any column in data table via designer (real column from database or added via designer) in select command in designer double quoting are dissapearing, and nothing not work because need double quoting. please fix this bug. thank you!

-- 
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] Using factories in 3.0.2

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

It's what it says. Maybe you forgot to modify 64bit version of
machine.config (or vice versa) or maybe you're on .NET 4.0 and
installed .NET 4.5 version of provider or maybe the factory is removed
in app.config or maybe ...

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

Re: [Firebird-net-provider] Using factories in 3.0.2

[Alex C. <acr...@ya...>]

Hello Jiri,

Sure, this is (I'm traslating because is in spanish the exception text):

Can't find the .NET data provider requested. May be is not installed.

At this line:
fabrica=DbProviderFactories.GetFactory("FirebirdSql.Data.FirebirdClient");

Thank you.

Regards,
_______________________________
I'm free, I use GNU/Linux.
Close your Windows, Open your mind.


--- El jue 18-abr-13, Jiri Cincura <di...@ci...> escribió:

> De: Jiri Cincura <di...@ci...>
> Asunto: Re: [Firebird-net-provider] Using factories in 3.0.2
> A: "For users and developers of the Firebird .NET providers" <fir...@li...>
> Fecha: jueves, 18 de abril de 2013, 2:14
> > But my app crashes every time
> I'm trying to execute it.
> 
> Can you provide us exception and other details?
> 
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
> 
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of
> advanced
> analytics on semi-structured data. The platform includes
> APIs for building
> apps and a phenomenal toolset for data science. Developers
> can use
> our toolset for easy data analysis & visualization. Get
> a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 

Re: [Firebird-net-provider] Using factories in 3.0.2

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

> But my app crashes every time I'm trying to execute it.

Can you provide us exception and other details?

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

[Firebird-net-provider] Using factories in 3.0.2

[Alex C. <acr...@ya...>]

Hello all,

I'm trying to update an application that uses Factories from version 2.1 to 3.0.2 of the provider.

I've registered the dll in the gac by using gacutil.exe from VS2010 command line. This is the output of /l option:
FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL

I've added the next lines to machine.config from v2 and v4 of the config directory:

2:
<section name="firebirdsql.data.firebirdclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

<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=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c" />

4:
<section name="firebirdsql.data.firebirdclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

<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=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>

But my app crashes every time I'm trying to execute it.

Could you please help me to fix this issue?? What is wrong?

Thanks in advance.

Regards,

[Firebird-net-provider] [FB-Tracker] Created: (DNET-497) .Net provider Generates "Outer aplly statement"

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

.Net provider Generates "Outer aplly statement"
-----------------------------------------------

                 Key: DNET-497
                 URL: http://tracker.firebirdsql.org/browse/DNET-497
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework support
    Affects Versions: 3.0.2.0
         Environment: Win 7x64, 
            Reporter: Wojciech Kmiecik
            Assignee: Jiri Cincura


hi.

We are using Database First Approach, after linq query 
                    AIds = (from x in context.RISK_T_ASSESS_HIST
                            where (x.ID_RISKOBJECT.HasValue && x.F_CREATEDON >= Freq.StartDate && x.F_CREATEDON <= Freq.EndDate)
                            group x by x.ID_RISKOBJECT into gr
                            let lastCreated = gr.Max(p => p.F_CREATEDON)
                            select new
                            {
                                ObjId = gr.Key
                                ,
                                LastStatus = gr.Where(p => p.F_CREATEDON == lastCreated && p.ID_RISKOBJECT == gr.Key).Select(p => p.F_STATUS).FirstOrDefault()
                            }).Where(x => x.LastStatus == 0 || x.LastStatus == 1).Select(x => x.ObjId.Value).ToArray();

FB receives query  with Outer Apply
Query generowane przez EF


SELECT 
"Project1"."ID_RISKOBJECT" AS "ID_RISKOBJECT"
FROM (SELECT 
    "GroupBy1"."A1" AS "C1", 
    "GroupBy1"."K1" AS "ID_RISKOBJECT"
    FROM ( SELECT 
        "Extent1"."ID_RISKOBJECT" AS "K1", 
        MAX("Extent1"."F_CREATEDON") AS "A1"
        FROM "RISK_T_ASSESS_HIST" AS "Extent1"
        WHERE (("Extent1"."ID_RISKOBJECT" IS NOT NULL) 
        AND ("Extent1"."F_CREATEDON" >= 2013-04-17)) 
        AND ("Extent1"."F_CREATEDON" <= 2013-04-17)
        GROUP BY "Extent1"."ID_RISKOBJECT"
    ) AS "GroupBy1" ) AS "Project1"
OUTER APPLY (SELECT FIRST (1) 
    "Extent2"."F_STATUS" AS "F_STATUS"
    FROM "RISK_T_ASSESS_HIST" AS "Extent2"
    WHERE (((("Extent2"."ID_RISKOBJECT" IS NOT NULL) 
    AND ("Extent2"."F_CREATEDON" >= 2013-04-17)) 
    AND ("Extent2"."F_CREATEDON" <= @2013-04-17)) 
    AND (("Project1"."ID_RISKOBJECT" = "Extent2"."ID_RISKOBJECT") OR (("Project1"."ID_RISKOBJECT" IS NULL) 
    AND ("Extent2"."ID_RISKOBJECT" IS NULL)))) AND (("Extent2"."F_CREATEDON" = "Project1"."C1") 
    AND ("Extent2"."ID_RISKOBJECT" = "Project1"."ID_RISKOBJECT")) ) AS "Limit1"
WHERE (0 = "Limit1"."F_STATUS") OR (1 = "Limit1"."F_STATUS")


-- 
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-496) Why NETProvider-1.7.2 does not work with Firebird Embedded 2.5?

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

 Why NETProvider-1.7.2 does not work with Firebird Embedded 2.5?
----------------------------------------------------------------

                 Key: DNET-496
                 URL: http://tracker.firebirdsql.org/browse/DNET-496
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 1.7.2
         Environment: 
Why NETProvider-1.7.2 does not work with Firebird Embedded 2.5?
            Reporter: Sergey Prochoghev
            Assignee: Jiri Cincura



Why NETProvider-1.7.2 does not work with Firebird Embedded 2.5?

-- 
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] ClearAllPools and opened connections

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

> On this ^ line you'll get exception as the connection1 was also
> cleared aka closed/disposed. I always used ClearAllPools with all
> connections closed so I had no idea it behaves like that.

Interesting, I also never noticed.

> But do you think is correct? Should the ClearAllPools clear even the
> opened connections?

No, it definitely should not.
It would destroy a great part of the logic at least in *my* code :-)

For    those   connections   which  are  not  opened  implicitely  but
explicitely,  I usually check once if their status is OK and then do a
series of commands.
With  what  you  found out it would be possible that some asynchronous
thread would clear the pools in between, right?
Like  cutting  the  branch you sit on in a big tree... no, really, I'd
prefer if this would not be possible :-)


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

> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



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

Re: [Firebird-net-provider] ClearAllPools and opened connections

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

On Wed, 17 Apr 2013 10:29:57 +0200, Jiri Cincura <di...@ci...>
wrote:
> Hi *,
> 
> I just found behavior that surprised me. Suppose pooling is on and
> (all connections to same database):
> Open connection1.
> Open connection2.
> Close connection2.
> FbConnection.ClearAllPools();
> Try to use connection1.
> 
> On this ^ line you'll get exception as the connection1 was also
> cleared aka closed/disposed. I always used ClearAllPools with all
> connections closed so I had no idea it behaves like that.
> 
> But do you think is correct? Should the ClearAllPools clear even the
> opened connections?

This behavior matches with my expectations for a method called
ClearAllPools(). Maybe you should keep the existing behavior and add a
method 'ClearAllPools(bool closeOpenConnections)' which allows explicit
control over this behavior.

Mark

Re: [Firebird-net-provider] ClearAllPools and opened connections

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

ClearAllPools should not close/dispose open connections.
A function to close all pooled connections might be useful however for when
you need to close all connections maybe with different name like
CloseAllPooledConnections


On Wed, Apr 17, 2013 at 10:29 AM, Jiri Cincura <di...@ci...> wrote:

> Hi *,
>
> I just found behavior that surprised me. Suppose pooling is on and
> (all connections to same database):
> Open connection1.
> Open connection2.
> Close connection2.
> FbConnection.ClearAllPools();
> Try to use connection1.
>
> On this ^ line you'll get exception as the connection1 was also
> cleared aka closed/disposed. I always used ClearAllPools with all
> connections closed so I had no idea it behaves like that.
>
> But do you think is correct? Should the ClearAllPools clear even the
> opened connections?
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
Gerdus van Zyl
http://about.me/gerdus

[Firebird-net-provider] ClearAllPools and opened connections

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

Hi *,

I just found behavior that surprised me. Suppose pooling is on and
(all connections to same database):
Open connection1.
Open connection2.
Close connection2.
FbConnection.ClearAllPools();
Try to use connection1.

On this ^ line you'll get exception as the connection1 was also
cleared aka closed/disposed. I always used ClearAllPools with all
connections closed so I had no idea it behaves like that.

But do you think is correct? Should the ClearAllPools clear even the
opened connections?

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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-495) Please, I need Data creation of football bet

[Joseph O. (JIRA) <tr...@fi...>]

Please, I need Data creation of football bet
--------------------------------------------

                 Key: DNET-495
                 URL: http://tracker.firebirdsql.org/browse/DNET-495
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ASP.NET Providers
    Affects Versions: 2.1.0
         Environment: Port Harcourt
            Reporter: Joseph Ogbuke
            Assignee: Jiri Cincura


software platform

-- 
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-494) GCC

[Joseph O. (JIRA) <tr...@fi...>]

GCC
---

                 Key: DNET-494
                 URL: http://tracker.firebirdsql.org/browse/DNET-494
             Project: .NET Data provider
          Issue Type: Bug
          Components: Borland Data Provider
    Affects Versions: 2.1.0
         Environment: lagos
            Reporter: Joseph Ogbuke
            Assignee: Jiri Cincura


software platform

-- 
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-493) Multiple websites in IIS with native dll use 100% or core CPU

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

Multiple websites in IIS with native dll use 100% or core CPU
-------------------------------------------------------------

                 Key: DNET-493
                 URL: http://tracker.firebirdsql.org/browse/DNET-493
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 2.5.0
         Environment: Windows 7, IIS7
            Reporter: Icemedia
            Assignee: Jiri Cincura


http://stackoverflow.com/questions/16029488/multiple-websites-in-iis-with-native-dll-use-100-or-core-cpu

I have an application which makes uses of firebird embedded. There are five instances of this application in IIS all in the same Application Pool. 

Whenever one of the sites in the pool is stopped or recycled the other four websites will then have a thread each that uses 100% of the CPU for the core it's running on (I can't tell if it's a new thread of an existing one that jumps to 100%) . So there are four threads using 100% CPU of four cores.

I've been using Process Explorer to try and find out more. The threads all have a call stack that looks mostly like this:
ntoskrnl.exe!KiCpuId+0xb6
ntoskrnl.exe!KeWaitForMutexObject+0x13c0
ntoskrnl.exe!KeUpdateRunTime+0x51
ntdll.dll!NtWaitForSingleObject+0xa
KERNELBASE.dll!WaitForSingleObjectEx+0x9a
fbembed.dll!BLOB_edit+0x3430c
fbembed.dll!BLOB_edit+0x1faa6c
fbembed.dll!BLOB_edit+0x1fb5f9
fbembed.dll!isc_dsql_execute_immediate+0x1c1
MSVCR80.dll!endthreadex+0x47
MSVCR80.dll!endthreadex+0x104
KERNEL32.DLL!BaseThreadInitThunk+0x1a
ntdll.dll!RtlUserThreadStart+0x21

This is running in IIS7 and IIS8 with .NET framework version is 2.0

I think firebird is trying to acquire some kind of lock? 

-- 
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] VS2012 AND VS2010 DDEX Provider registration vanishing

[De R. A. <ADe...@gw...>]

Greetings to everybody,

It seems I cannot get the Firebird DDEX provider to be installed correctly. I've used the manual method (before a working setup came out) and the new setup that has been made for the different VS versions.
Whatever method I use, it seems that the provider cannot stay registered in Visual Studio continuously. After a few sessions, the provider isn't displayed anymore. Server-explorer connections with this provider are still there, but throw an error on opening.

*         Datatools in the gac -> it's there

*         Provider in the gac -> it's there

*         machineconfig 32-bit and 64-bit for .NET v4.0.30319 contains both an entry

*         Registry files are still there

Every time, I try manual install steps and/or the setup to get the provider back and start VS2010/VS2012 with the /resetpckgs option (I need it since I'm working with EF 5) and it seems to restore the registration to visual studio. To be frank, I am still unable to recognize the exact step that solves the problem (temporarily)and every time I just try to reset everything back to zero (what it would look like if firebird DDEX-provider wasn't installed). For this problem to appear, it could as well take up to 30 windows restarts or just even one. I also noticed that this never happens "in-between". The provider only goes missing after a restart of windows, but not vs2012 or vs2010.

Does anyone have similar problems?

p.s: I am sorry if the format of this mail doesn't match the conventions for posting to this mailing list. I didn't use any mailing list until now.

Alexandre De Riemaecker

[Firebird-net-provider] [FB-Tracker] Created: (DNET-492) An event is not registered (QueueEvents)

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

An event is not registered (QueueEvents) 
-----------------------------------------

                 Key: DNET-492
                 URL: http://tracker.firebirdsql.org/browse/DNET-492
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 1.7.2
            Reporter: Sergey Prochoghev
            Assignee: Jiri Cincura
            Priority: Critical


It's works like a charm for the  Firebird 2.0 but doesn't for the Firebird 2.5

Here is the example code:
     ...
     EvLOGP200:= FirebirdSql.Data.Firebird.FbRemoteEvent.Create(FbConnectionFDB , ['INS_FDB001_TAB001']);
     Include(EvLOGP200.RemoteEventCounts, FbConnectionFDB001_InfoMessage) ;
    
    EvLOGP200.QueueEvents; 

Here is an error message:

encountered unhandled exception class FirebirdSql.Data.common.IscException

Here is the debug:

-> interruption ... "Unable to complete network request to host "0.0.0.0"." 

-- 
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-491) interruption for QueueEvents

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

 interruption  for QueueEvents
------------------------------

                 Key: DNET-491
                 URL: http://tracker.firebirdsql.org/browse/DNET-491
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 1.7.2
         Environment: Не регистрируется событие  (QueueEvents)
            Reporter: Sergey Prochoghev
            Assignee: Jiri Cincura
            Priority: Critical


Для   Firebird 2.0 - всё работает - OK.

Для Firebird 2.5  не работает :
     ...
     EvLOGP200:=  FirebirdSql.Data.Firebird.FbRemoteEvent.Create(FbConnectionFDB , ['INS_FDB001_TAB001']);
     Include(EvLOGP200.RemoteEventCounts,  FbConnectionFDB001_InfoMessage) ;
    
     EvLOGP200.QueueEvents;      -> interruption   ... "Unable to complete network request to host "0.0.0.0"."  

-- 
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-490) FbBatchExecution closes database connection

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

FbBatchExecution closes database connection
-------------------------------------------

                 Key: DNET-490
                 URL: http://tracker.firebirdsql.org/browse/DNET-490
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 3.0.2.0
         Environment: Windows 7 SP1, DDEX 3.0.0.0, Firebird embedded server 2.5.2.26539, Visual Studio 2010, .NET Framework 4.0, and that's all I can think of.
            Reporter: Brian Liedtke
            Assignee: Jiri Cincura
            Priority: Minor


When calling the FbExecutionBatch.Execute method with an open FbConnection. The FbConnection is closed upon exit of the FbExecutionBatch.Execute method.

-- 
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] Question on FbBatchExecution

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

On Fri, Apr 5, 2013 at 7:43 AM, Brian Liedtke <li...@fr...> wrote:
> Is anyone working on this? If not, I may take a stab at it if I can find the time.

I'm not aware of anybody.

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

Re: [Firebird-net-provider] Question on FbBatchExecution

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

On Fri, Apr 5, 2013 at 7:50 AM, Brian Liedtke <li...@fr...> wrote:
> I assume you refer to the JIRA issue tracking software?

Yes.

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

Re: [Firebird-net-provider] Question on FbBatchExecution

[Brian L. <li...@fr...>]

I assume you refer to the JIRA issue tracking software?

-----Original Message----- 
From: Jiri Cincura 
Sent: Thursday, April 04, 2013 11:09 PM 
To: For users and developers of the Firebird .NET providers 
Subject: Re: [Firebird-net-provider] Question on FbBatchExecution 

On Fri, Apr 5, 2013 at 3:07 AM, Brian Liedtke <li...@fr...> wrote:
> Any reason for this?

Because it's implemented like this. :) It's probably bug. It should
close the connection only if it opened it. Create a tracker item for
this. I'll fix it into next release.

Re: [Firebird-net-provider] Question on FbBatchExecution

[Brian L. <li...@fr...>]

Will do.

I'll keep my workaround then of reopening the connection after the Execute and
comment it for whomever gets the code (probably me).

It would be nice to have a LOAD statement (or utility) to batch load data from a
CSV (or other delimited text) file. The third party utilities suggested by the Firebird website
really don't fit the bill since they either don't work (do not handle NULLs, BLOBs, or are depricated.
Or they only offer a GUI interface which I do not want to pass on to my users).
Right now, I create an FbBatchExecution object (which is how I found this 'bug') and load from there.
It has got my problem of loading 260,000 records down to about 15 minutes, but I think that can
be improved.

Is anyone working on this? If not, I may take a stab at it if I can find the time.

Brian

-----Original Message----- 
From: Jiri Cincura 
Sent: Thursday, April 04, 2013 11:09 PM 
To: For users and developers of the Firebird .NET providers 
Subject: Re: [Firebird-net-provider] Question on FbBatchExecution 

On Fri, Apr 5, 2013 at 3:07 AM, Brian Liedtke <li...@fr...> wrote:
> Any reason for this?

Because it's implemented like this. :) It's probably bug. It should
close the connection only if it opened it. Create a tracker item for
this. I'll fix it into next release.

Re: [Firebird-net-provider] Question on FbBatchExecution

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

On Fri, Apr 5, 2013 at 3:07 AM, Brian Liedtke <li...@fr...> wrote:
> Any reason for this?

Because it's implemented like this. :) It's probably bug. It should
close the connection only if it opened it. Create a tracker item for
this. I'll fix it into next release.

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

[Firebird-net-provider] Question on FbBatchExecution

[Brian L. <li...@fr...>]

I execute a script. Everything runs fine, but my database connection
is closed upon return from the Execute method.

Any reason for this?

Brian Liedtke

Re: [Firebird-net-provider] Sweep

[Nicolas T. <nft...@ho...>]

Perfect, tank you

Enviado pelo meu Windows Phone
________________________________
De: Jiri Cincura
Enviada em: 03/04/2013 07:08
Para: For users and developers of the Firebird .NET providers
Assunto: Re: [Firebird-net-provider] Sweep

On Wed, Apr 3, 2013 at 2:20 AM, Nicolas Timmers <nft...@ho...> wrote:
> There is a method on firebord data provider to perform database sweep??

Yes. Services namespace. FbValidationFlags.SweepDatabase flag.

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

------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider