Pascal (JIRA | 24 Apr 14:41 2015

[FB-Tracker] Created: (DNET-604) Improvement the time to execute parametred queries

Improvement the time to execute parametred queries
--------------------------------------------------

                 Key: DNET-604
                 URL: http://tracker.firebirdsql.org/browse/DNET-604
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 4.6.2.0
            Reporter: Pascal
            Assignee: Jiri Cincura

When FirebirdSql.Data.FirebirdClient is used to insert a lot of records in a table using parametred
query, it's possible to gain time in the FbCommand.UpdateParameterValues :

Change this code :
  for (int i = 0; i < this.statement.Parameters.Count; i++)
            {
                index = i;

                if (this.namedParameters.Count > 0)
                {
                        index = this.Parameters.IndexOf(this.namedParameters[i]);
                        if (index == -1)
                        {
                            throw new FbException(String.Format("Must declare the variable '{0}'", this.namedParameters[i]));
                        }
                }

by this one :
(Continue reading)

Wolfgang Janz (JIRA | 22 Apr 10:13 2015

[FB-Tracker] Created: (DNET-603) operating system directive CreateFile failed

operating system directive CreateFile failed
--------------------------------------------

                 Key: DNET-603
                 URL: http://tracker.firebirdsql.org/browse/DNET-603
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.5.2.0
            Reporter: Wolfgang Janz
            Assignee: Jiri Cincura

we are recently getting an error when using firebird (filebased-database). Here is the stacktrace:

FirebirdSql.Data.FirebirdClient.FbException: operating system directive CreateFile failed --->
FirebirdSql.Data.Common.IscException: operating system directive CreateFile failed
bei FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector(IntPtr[] statusVector) in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:Zeile 420.
bei FirebirdSql.Data.Client.Native.FesDatabase.Attach(DatabaseParameterBuffer dpb, String
dataSource, Int32 port, String database) in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:Zeile 291.
bei FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:Zeile 191.
— Ende der internen Ausnahmestapelüberwachung —
bei FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:Zeile 196.
bei FirebirdSql.Data.FirebirdClient.FbConnection.Open() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnection.cs:Zeile 539.
bei NHibernate.Connection.DriverConnectionProvider.GetConnection()

(Continue reading)

Jiri Cincura (JIRA | 19 Apr 09:31 2015

[FB-Tracker] Created: (DNET-602) Some unit tests for FbTrace

Some unit tests for FbTrace
---------------------------

                 Key: DNET-602
                 URL: http://tracker.firebirdsql.org/browse/DNET-602
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider
    Affects Versions: 4.6.2.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor

--

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

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Jiří Činčura | 15 Apr 15:51 2015
Picon

ADO.NET provider 4.6.2.0

More info http://blog.cincura.net/233504-ado-net-provider-4-6-2-0-for-firebird-is-ready/ .

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

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiří Činčura | 10 Apr 13:18 2015
Picon

Scripts parsing

Hi *,

I’m now working on improving the parser we use in Isql namespace for processing scripts. I tested a lot of
scripts I have myself. But that’s for sure only small sample of what’s possible. If you have any
script(s) you think use some really “nice” FB statement, if yould be nice to have it shared here. 

Thanks.

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

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiří Činčura | 10 Apr 13:16 2015
Picon

Migrations

Hi guys,

Small update on Migrations for EF. EF had regression in 6.x
(https://entityframework.codeplex.com/workitem/2683) which is now fixed. But will be included in
6.2. So I'm holding it. I'll then merge the branch, process PRs and it goes out. I don't want to release it
before, because there will be a lot of whining and I just don't want to go there (and if somebody really wants
it the branch is public).

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

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiri Cincura (JIRA | 9 Apr 17:14 2015

[FB-Tracker] Created: (DNET-600) Connection string improperly parsed

Connection string improperly parsed
-----------------------------------

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

Connection string "data source=localhost;port number=20455;initial catalog=;user
id=SYSDBA;password=masterkey;pooling=False;packet size=16384;character set=UTF8" is not
properly parsed. The initial catalog is mixed with user id.

--

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

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
(Continue reading)

Jiri Cincura (JIRA | 9 Apr 17:08 2015

[FB-Tracker] Created: (DNET-599) SetDefaultOptions sets "catalog" instead of "initial catalog"

SetDefaultOptions sets "catalog" instead of "initial catalog"
-------------------------------------------------------------

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

The line "this.options.Add("catalog", DefaultCatalog);" should be "this.options.Add("initial
catalog", DefaultCatalog);".

--

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

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
(Continue reading)

Sergey Isupov (JIRA | 9 Apr 11:30 2015

[FB-Tracker] Created: (DNET-598) DDEX crashes Visual studio

DDEX crashes Visual studio
--------------------------

                 Key: DNET-598
                 URL: http://tracker.firebirdsql.org/browse/DNET-598
             Project: .NET Data provider
          Issue Type: Bug
          Components: DDEX Provider
    Affects Versions: 4.6.1.0
         Environment: Windows 8 Pro, Visual Studio 2013 Pro, Firebird 2.5, Version of firebird .net adapter is
4.6.1.0. DDEX 3.0.1.0
            Reporter: Sergey Isupov
            Assignee: Jiri Cincura
            Priority: Critical

I'm trying to create table adapter wiht the following query:

select i.ID, count(C.ID_LEGAL_PERSON) as CLIENT_COUNT, sum(ceil(a.symbols_count /
e.STRING_LENGTH)) as SYMBOLS_COUNT, sum(p.issue_sum) as TOTAL_SUM, count(a.id) as ADS_COUNT
from ISSUE I
inner join ISSUE_ADS IA on I.ID = IA.ID_ISSUE
inner join ADS A on IA.ID_ADS = A.ID
inner join "Client" C on A.C_ID = C.ID_LEGAL_PERSON
inner join PAYMENT P on P.id = ia.id_payment
inner join Edition e on e.ID = i.ID_EDITION
where I.ID =  <at> ID_ISSUE and
      C.ID_SOURCE =  <at> ID_SOURCE and
      e.id =  <at> id_edition
      group by 1

(Continue reading)

Picon

Random crashes in Finalizers

Hello everyone.

I want to discuss changes in finalizers regarding a couple of crashes
we experience in our FB using.

Issues in tracker:
http://tracker.firebirdsql.org/browse/DNET-582
http://tracker.firebirdsql.org/browse/DNET-597

As for 582 we have discussion in PR that crutches it on GitHub:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/19

As for 597 try...catch doesn't work, it is a more complicated problem.

My suggestion is to refactor Dispose/Finalizer methods to not use
managed objects which might be already disposed.

Maybe anyone have another thought?
JIri, what do you think?

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Hennadii (JIRA | 1 Apr 08:44 2015

[FB-Tracker] Created: (DNET-597) Access violation in FesStatement.Finalize

Access violation in FesStatement.Finalize
-----------------------------------------

                 Key: DNET-597
                 URL: http://tracker.firebirdsql.org/browse/DNET-597
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, Entity Framework support
    Affects Versions: 4.6.1.0
         Environment: Firebird 2.5.2. x86 FB ADO .NET 4.6.1.0
            Reporter: Hennadii
            Assignee: Jiri Cincura

In our CI I've experienced access violation while running firebird.sqlclient.tests with following
managed stack:

   at FB_965910463_Class.isc_dsql_free_statement(IntPtr[], Int32 ByRef, Int16)
   at FB_965910463_Class.IFbClient.isc_dsql_free_statement(IntPtr[], Int32 ByRef, Int16)
   at FirebirdSql.Data.Client.Native.FesStatement.Free(Int32)
   at FirebirdSql.Data.Common.StatementBase.Release()
   at FirebirdSql.Data.Client.Native.FesStatement.Release()
   at FirebirdSql.Data.Client.Native.FesStatement.Dispose(Boolean)
   at FirebirdSql.Data.Common.StatementBase.Finalize()

I don't have a native stack for this, but I look forward get it.

My suggestion bases on this:
 "isc_dsql_allocate_statement2() 
function is similar to the isc_dsql_alloc_statement() function except that 
statement handles allocated using isc_dsql_allocate_statement2() are 
(Continue reading)


Gmane