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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-734) database C:\JAMSOFT SISTEMAS\JNFCE\BANCO\JAMSOFTINFO.DLL shutdown

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

database C:\JAMSOFT SISTEMAS\JNFCE\BANCO\JAMSOFTINFO.DLL shutdown
-----------------------------------------------------------------

                 Key: DNET-734
                 URL: http://tracker.firebirdsql.org/browse/DNET-734
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.7.0.0
         Environment: Windows 7 x86 3GB (Firebird 3.1)
            Reporter: Ralms
            Assignee: Jiri Cincura


Good night friends.

I'm having trouble trying to open two connections in firebird 3.1, is there anything already to solve this problem?


at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:line 196 at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 202 at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 106 at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString connectionString, FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 221 at FirebirdSql.Data.FirebirdClient.FbConnection.Open() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnection.cs:line 534 at 

-- 
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-733) InnerException's message in IscException isn't appended to the final message

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

InnerException's message in IscException isn't appended to the final message
----------------------------------------------------------------------------

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




-- 
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-732) Drop pre-EF6 support in FirebirdClient (EF6 kept intact)

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

Drop pre-EF6 support in FirebirdClient (EF6 kept intact)
--------------------------------------------------------

                 Key: DNET-732
                 URL: http://tracker.firebirdsql.org/browse/DNET-732
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider, Entity Framework support
            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

        

Re: [Firebird-net-provider] Entity Framework 5

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

OK, looks like this is not a problem, so I created DNET-732 for it and
it will eventually happen.

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

On Tue, Jan 10, 2017, at 18:27, Jiří Činčura wrote:
> > Too much effort?
> 
> Correct. 
> 
> Currently MS's story is only EF6 and EFCore so I don't want to waste too
> much of my free time on anything extra. Considering the move to EF6 from
> EF5 is not that difficult I don't see much reasons to keep it (and there
> has been plenty of time to do it). And of course there are always
> previous versions available.
> 
> -- 
> Mgr. Jiří Činčura
> Independent IT Specialist
> 
> ------------------------------------------------------------------------------
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Very slow query with FireBird ado.net provider

[Federico P. <fed...@e-...>]

Hi jiri,
 first of all, thanks for your support.

I have a problem with firebird ado.net provider.

My query is very slow, i think because in database there are some blob
field.
Is possible to esclude in query string?

Thank you so mutch

Federico


-- 
-- 
*Federico Paoloni*

*Responsabile Sviluppo*
e-Lios S.r.l.
Via le Mosse,22
62032 Camerino (MC)

Web: http://www.e-lios.eu - E-Mail: fed...@e-...



​
Il contenuto di predetta comunicazione ed i suoi allegati (se presenti) è
strettamente personale e riservata alla persona di cui all’indirizzo.
Si raccomanda il rispetto delle norme di cui al D. Lgs. 196/03 e s.m.i.

Se avete ricevuto questo messaggio per errore, siete pregati di cancellarlo
immediatamente e di informare cortesemente il mittente. La non autorizzata
pubblicazione, utilizzazione, diffusione, spedizione, stampa o copia di
questo messaggio e dei suoi allegati sono rigorosamente vietati.

This e-mail and all attachments (if any) are strictly confidential and
intended solely for the use of the individual to whom it is addressed.If
you have received this e-mail in error please kindly inform the sender and
delete it from your system. Unauthorized publication, use, disclosure,
forwarding, printing or copying of this email and its associated
attachments are strictly prohibited.

Re: [Firebird-net-provider] .NET 4 support

[Alexander Muylaert-G. <amu...@ho...>]

Hi Gerdus


The question is... should "we" be affected by "your" difficulties upgrading 500 pcs.  I have the same problem, it is even thousands and all running on different locations, but we try to manage.  (Failing miserably, but that is another story)

I agree with your opinion that you can stay on current implementation and not migrate away to all the new features.  If it works, it works, no?


Besides new features and code clean ups... what with bugfixes though.  I don't think we can keep on expecting from Jiri to backport all fixes to all version all the time.

I rather see Jiri working on the new event system then to keep 4.0 code running.


kind regards


a




Verzonden vanuit Outlook<http://aka.ms/weboutlook>


________________________________
Van: Gerdus van Zyl <ger...@gm...>
Verzonden: zondag 15 januari 2017 15:55
Aan: For users and developers of the Firebird .NET providers
Onderwerp: Re: [Firebird-net-provider] .NET 4 support

I am still using 4.0 due to the difficulty upgrading 500+ computers and a painful amount of customers still on XP. The downside of desktop software.
That being said the current code is stable and fast in our experience so would be happy to stay on the current version until we are ready to upgrade .net version.

On 15 January 2017 at 15:11, Jirí Cincura <ji...@ci...<mailto:ji...@ci...>> wrote:
Hello *,

reading the
===
As previously announced, starting January 12, 2016 Microsoft will no longer provide security updates, technical support or hotfixes for .NET 4, 4.5, and 4.5.1 frameworks. All other framework versions, including 3.5, 4.5.2, 4.6 and 4.6.1, will be supported for the duration of their established lifecycle. The decision to end support for these versions will allow us to invest more resources towards improvements of the .NET Framework.
===

makes me wonder who here is using strictly 4.0, still one year after it's no longer supported. ;) It would make my life easier to drop .NET 4 support and invest my resources to moving forward faster. 4.5.2+ would still be supported, of course.

--
Mgr. Jirí Cincura
Independent IT Specialist


------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...<mailto:Fir...@li...>
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider




--
------------------------------------------------------------------------
Gerdus van Zyl
www.infireal.com<http://www.infireal.com>

Re: [Firebird-net-provider] .NET 4 support

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

I am still using 4.0 due to the difficulty upgrading 500+ computers and a
painful amount of customers still on XP. The downside of desktop software.
That being said the current code is stable and fast in our experience so
would be happy to stay on the current version until we are ready to upgrade
.net version.

On 15 January 2017 at 15:11, Jiří Činčura <ji...@ci...> wrote:

> Hello *,
>
> reading the
> ===
> As previously announced, starting January 12, 2016 Microsoft will no
> longer provide security updates, technical support or hotfixes for .NET 4,
> 4.5, and 4.5.1 frameworks. All other framework versions, including 3.5,
> 4.5.2, 4.6 and 4.6.1, will be supported for the duration of their
> established lifecycle. The decision to end support for these versions will
> allow us to invest more resources towards improvements of the .NET
> Framework.
> ===
>
> makes me wonder who here is using strictly 4.0, still one year after it's
> no longer supported. ;) It would make my life easier to drop .NET 4 support
> and invest my resources to moving forward faster. 4.5.2+ would still be
> supported, of course.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------
> ------------------
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>


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

[Firebird-net-provider] .NET 4 support

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

Hello *,



reading the

===

As previously announced, starting January 12, 2016 Microsoft will no
longer provide security updates, technical support or hotfixes for .NET
4, 4.5, and 4.5.1 frameworks. All other framework versions, including
3.5, 4.5.2, 4.6 and 4.6.1, will be supported for the duration of their
established lifecycle. The decision to end support for these versions
will allow us to invest more resources towards improvements of the .NET
Framework.
===



makes me wonder who here is using strictly 4.0, still one year after
it's no longer supported. ;) It would make my life easier to drop .NET 4
support and invest my resources to moving forward faster. 4.5.2+ would
still be supported, of course.


-- 

Mgr. Jiří Činčura

Independent IT Specialist

Re: [Firebird-net-provider] About GUIDs in Firebird

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

> I may have missed the point or I'm not aware of all the details here but
> trying to use a GUID in its string representation is a failure by itself. 

Thank you!

> Is there a case where this is needed because doing it right (using a Guid
> as its type and not as string) and use parameters isn't possible? 

I'm not aware of any. Except when you want to show the Guid for some
logging/debugging purposes and you're looking for it in database. But
still...

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

Re: [Firebird-net-provider] Entity Framework 5

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

> Too much effort?

Correct. 

Currently MS's story is only EF6 and EFCore so I don't want to waste too
much of my free time on anything extra. Considering the move to EF6 from
EF5 is not that difficult I don't see much reasons to keep it (and there
has been plenty of time to do it). And of course there are always
previous versions available.

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

Re: [Firebird-net-provider] About GUIDs in Firebird

[Ralf J. <ral...@ma...>]

I may have missed the point or I'm not aware of all the details here but trying to use a GUID in its string representation is a failure by itself. 
I see no benefit in making something work that isn't advisable in the first place. Like trying to move a datetime as string to the db and hoping it get interpreted correctly. 

Is there a case where this is needed because doing it right (using a Guid as its type and not as string) and use parameters isn't possible? 

-----Ursprüngliche Nachricht-----
Von: Jiří Činčura [mailto:ji...@ci...] 
Gesendet: Dienstag, 10. Januar 2017 15:20
An: For users & developers of the Firebird .NET providers <fir...@li...>
Betreff: [Firebird-net-provider] About GUIDs in Firebird

Hi *,

we have this ticket DNET-509 in tracker. Although I agree the change would be nice, it's also a breaking change as huge as it can get. What's your take on it? Or do you see clean way out?

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

------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi _______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5

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

Too much effort?


On 10 January 2017 at 19:21, Jiří Činčura <ji...@ci...> wrote:
>> Have you considered supporting two separate libraries? In two separate
>> branches/nuget and so on?
>
> Not really.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] About GUIDs in Firebird

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

We had encountered this one in our migration to .net provider, it
caused us much pain, because divergence with other SQL providers.

I'd vote for changing this and declaring it as breaking change. With
supplied fixes for existing code, of course.

On 10 January 2017 at 16:20, Jiří Činčura <ji...@ci...> wrote:
> Hi *,
>
> we have this ticket DNET-509 in tracker. Although I agree the change
> would be nice, it's also a breaking change as huge as it can get. What's
> your take on it? Or do you see clean way out?
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5

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

> Have you considered supporting two separate libraries? In two separate
> branches/nuget and so on?

Not really. 

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

Re: [Firebird-net-provider] Entity Framework 5

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

Have you considered supporting two separate libraries? In two separate
branches/nuget and so on?

On 9 January 2017 at 16:55, Jiří Činčura <ji...@ci...> wrote:
> Hi *,
>
> anybody still using EF5 (or even EF4)? Or is everybody on EF6...
> Thinking about slimming the FirebirdSql.Data.FirebirdClient and removing
> the old EF support and keeping only EF6 (EntityFramework.Firebird).
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] About GUIDs in Firebird

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

Hi *,

we have this ticket DNET-509 in tracker. Although I agree the change
would be nice, it's also a breaking change as huge as it can get. What's
your take on it? Or do you see clean way out?

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

Re: [Firebird-net-provider] Fill Method of FbDataAdapter fails

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

> I think I am running out of memory which leads to the connection being
> terminated.
> In such a case the Exception should be Out of Memory.
> Possibly the Exception caught is incorrect.
> Can this be confirmed please.

Yes it can.

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

Re: [Firebird-net-provider] Events

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

> is it neccessary or recommended to dispose a FbRemoteEvent with this new
> release? (I assume it should be disposed)

Yes, it's recommended. It's the only way to close the underlying socket.
 
> Number of events: Is this the number the program can listen to or
> something different?

Yes.

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

Re: [Firebird-net-provider] Events

[Nikolaus K. <par...@gm...>]

Hello Jiri,

is it neccessary or recommended to dispose a FbRemoteEvent with this new release? (I assume it should be disposed)

Number of events: Is this the number the program can listen to or something different?

Thanks

Niko

-----Ursprüngliche Nachricht-----
Von: Jiří Činčura [mailto:ji...@ci...] 
Gesendet: Dienstag, 10. Jänner 2017 11:32
An: For users & developers of the Firebird .NET providers <fir...@li...>
Betreff: [Firebird-net-provider] Events

Hi *,

The events code was not much reliable and I recently got time to work on it to improve it. So in foreseeable future the changes from `events` branch will be merged and new version will be released. Given it's breaking changes it's going to be very very likely new major version.

Here's a simple demo code to see how it works now:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/events/Provider/src/FirebirdSql.Data.UnitTests/FbRemoteEventTests.cs#L40

The major changes are:
* Number of events is now limited to ushort.MaxValue. FTW!
* FbRemoteEvent now takes connection string instead of FbConnection (so it's connection independent).
* It implements IDisposable.
* The RemoteEventCounts event is fired for every event fired with some count (aka Count > 0).
* There's a new event RemoteEventError allowing you to be notified in case i.e. the events channel is broken and exception is thrown.
* No extra threads are created or used.

That's about it. Questions?

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

------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi _______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Events

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

Hi *,

The events code was not much reliable and I recently got time to work on
it to improve it. So in foreseeable future the changes from `events`
branch will be merged and new version will be released. Given it's
breaking changes it's going to be very very likely new major version.

Here's a simple demo code to see how it works now:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/events/Provider/src/FirebirdSql.Data.UnitTests/FbRemoteEventTests.cs#L40

The major changes are:
* Number of events is now limited to ushort.MaxValue. FTW!
* FbRemoteEvent now takes connection string instead of FbConnection (so
it's connection independent).
* It implements IDisposable.
* The RemoteEventCounts event is fired for every event fired with some
count (aka Count > 0).
* There's a new event RemoteEventError allowing you to be notified in
case i.e. the events channel is broken and exception is thrown.
* No extra threads are created or used.

That's about it. Questions?

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

[Firebird-net-provider] Fill Method of FbDataAdapter fails

[LtColRDSChauhan <rds...@gm...>]

>
>    1. Fill Method of FbDataAdapter fails (LtColRDSChauhan)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 9 Jan 2017 22:30:21 +0530
> From: LtColRDSChauhan <rds...@gm...>
> Subject: [Firebird-net-provider] Fill Method of FbDataAdapter fails
> To: fir...@li...
> Message-ID:
>         <CAMG8wxgSiZBGZZxMu1DEHx44GfMVG7=GnZZj5PHT5U2KL3_uEA@mail.
> gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Mon, Jan 9, 2017 at 8:25 PM, <
> fir...@li...> wrote:
>
> > Send Firebird-net-provider mailing list submissions to
> >         fir...@li...
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> >         https://lists.sourceforge.net/lists/listinfo/firebird-net-
> provider
> > or, via email, send a message with subject or body 'help' to
> >         fir...@li...
> >
> > You can reach the person managing the list at
> >         fir...@li...
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of Firebird-net-provider digest..."
> >
> >
> >
> > Hi,
> >
> > I am creating an object of FbDataAdapter, passing the constructor an
> object
> > of FbCommand . The CommandText of this FbCommand object is a stored
> > procedure.
> >
> > This worked fine. Recently calling Fill method of FbDataAdapter reports
> > error [appended at the end of mail]. The copied CommandText, during
> debug,
> > runs fine in Flamerobin. Also when i change the code to restrict the
> number
> > of rows to say 50, it runs fine. Changed this in two ways (both ways it
> > worked):
> >
> > (1) In the querry used " SELECT first 50 ... "
> >
> > (2) Passed arguments to Fill method: da.*Fill*(ds, 0, 50, "Table");
> >
> >
> > Please help me to fetch all records using Fill method of FbDataAdapter.
> >
> >
> > THE ERROR reported:
> >
> > System.IO.IOException: I/O error occurred.
> >
> > at Byte[] FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(
> System.Int32
> > count)
> >
> > at Int32 FirebirdSql.Data.Client.Managed.XdrStream.ReadInt32()
> >
> > at Int32 FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()
> >
> > at Int32
> > FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.NextOperation()
> >
> > at Int32
> > FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.NextOperation()
> >
> > at DbValue[] FirebirdSql.Data.Client.Managed.Version10.
> > GdsStatement.Fetch()
> >
> > at DbValue[] FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()
> >
> > at Boolean FirebirdSql.Data.FirebirdClient.FbDataReader.Read()
> >
> > at Boolean System.Data.ProviderBase.DataReaderContainer.Read()
> >
> > at Int32
> > System.Data.Common.DataAdapter.FillLoadDataRow(System.Data.ProviderBase.
> > SchemaMapping
> > mapping)
> >
> > at Int32 System.Data.Common.DataAdapter.FillFromReader(
> System.Data.DataSet
> > dataset, System.Data.DataTable datatable, System.String srcTable,
> > System.Data.ProviderBase.DataReaderContainer dataReader, System.Int32
> > startRecord, System.Int32 maxRecords, System.Data.DataColumn
> > parentChapterColumn, System.Object parentChapterValue)
> >
> > at Int32 System.Data.Common.DataAdapter.Fill(System.Data.DataSet
> dataSet,
> > System.String srcTable, System.Data.IDataReader dataReader, System.Int32
> > startRecord, System.Int32 maxRecords)
> >
> > at Int32 System.Data.Common.DbDataAdapter.FillInternal(
> System.Data.DataSet
> > dataset, System.Data.DataTable[] datatables, System.Int32 startRecord,
> > System.Int32 maxRecords, System.String srcTable, System.Data.IDbCommand
> > command, System.Data.CommandBehavior behavior)
> >
> > at Int32 System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet
> > dataSet,
> > System.Int32 startRecord, System.Int32 maxRecords, System.String
> srcTable,
> > System.Data.IDbCommand command, System.Data.CommandBehavior behavior)
> >
> > at Int32 System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet
> > dataSet,
> > System.String srcTable)
> >
> > at static DataTable HMSLib.Ctrls.DtFromObjArray(System.Object arg)
> >
> > at static Object HMSLib.Ctrls.DgvDtFromObjArray(System.Object args)
> >
> > at static System.Void HMSLib.Ctrls.DgvDtProc(System.Object args)
> >
> > at static System.Void
> > System.Threading.ThreadHelper.ThreadStart_Context(System.Object state)
> >
> > at static System.Void
> > System.Threading.ExecutionContext.RunInternal(System.Threading.
> > ExecutionContext
> > executionContext, System.Threading.ContextCallback callback,
> System.Object
> > state, System.Boolean preserveSyncCtx)
> >
> > at static System.Void
> > System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext
> > executionContext, System.Threading.ContextCallback callback,
> System.Object
> > state, System.Boolean preserveSyncCtx)
> >
> > at static System.Void
> > System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext
> > executionContext, System.Threading.ContextCallback callback,
> System.Object
> > state)
> >
> > at System.Void System.Threading.ThreadHelper.ThreadStart(System.Object
> > obj)
> >
> >
> > Regards,
> >
> > Rajiv
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> >
> > ------------------------------
> >
> > Message: 5
> > Date: Mon, 09 Jan 2017 07:35:37 +0100
> > From: Ji?? ?in?ura <ji...@ci...>
> > Subject: Re: [Firebird-net-provider] Fill Method of FbDataAdapter
> >         fails
> > To: fir...@li...
> > Message-ID:
> >         <1483943737.3495828.841473649.44D5B429@webmail.
> messagingengine.com
> > >
> > Content-Type: text/plain; charset="utf-8"
> >
> > What's the inner exception?
> >
> > 1. InnerException:
> Error reading data from the connection.
>

I think I am running out of memory which leads to the connection being
terminated.
In such a case the Exception should be Out of Memory.
Possibly the Exception caught is incorrect.
Can this be confirmed please.

>
> 2. StackTrace:
>    at FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()
>    at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()
>
> 3. FillError event is not fired.
>
> > --
> > Mgr. Ji?? ?in?ura
> > Independent IT Specialist
> >
> >
> >
> >
> > ------------------------------
>

[Firebird-net-provider] Fill Method of FbDataAdapter fails

[LtColRDSChauhan <rds...@gm...>]

On Mon, Jan 9, 2017 at 8:25 PM, <
fir...@li...> wrote:

> Send Firebird-net-provider mailing list submissions to
>         fir...@li...
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> or, via email, send a message with subject or body 'help' to
>         fir...@li...
>
> You can reach the person managing the list at
>         fir...@li...
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Firebird-net-provider digest..."
>
>
> Today's Topics:
>
>    1. [FB-Tracker] Created: (DNET-729) Conflict with ionic zip
>       package (Eric Bole-Feysot (JIRA))
>    2. [FB-Tracker] Created: (DNET-730)
>       FirebirdSql.Data.Schema.FbMetaData.xml not in netstandard1.6
>       version (Jiri Cincura (JIRA))
>    3. [FB-Tracker] Created: (DNET-731) Issue with
>       FesBlob.GetSegment (Hennadii Zabula (JIRA))
>    4. Fill Method of FbDataAdapter fails (LtColRDSChauhan)
>    5. Re: Fill Method of FbDataAdapter fails (Ji?? ?in?ura)
>    6. Entity Framework 5 (Ji?? ?in?ura)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 30 Dec 2016 11:32:17 +0000 (UTC)
> From: "Eric Bole-Feysot (JIRA)" <tr...@fi...>
> Subject: [Firebird-net-provider] [FB-Tracker] Created: (DNET-729)
>         Conflict        with ionic zip package
> To: fir...@li...
> Message-ID:
>         <1495224156.15241483097537448.JavaMail.tomcat@tracker.
> firebirdsql.org>
> Content-Type: text/plain; charset=UTF-8
>
> Conflict with ionic zip package
> -------------------------------
>
>                  Key: DNET-729
>                  URL: http://tracker.firebirdsql.org/browse/DNET-729
>              Project: .NET Data provider
>           Issue Type: Improvement
>           Components: ADO.NET Provider
>     Affects Versions: 5.7.0.0
>          Environment: visual studio 2015
>             Reporter: Eric Bole-Feysot
>             Assignee: Jiri Cincura
>             Priority: Minor
>
>
> I use in my app dotnetzip package (ioniczip dll) and when I installed
> firebird ado.net provider, I got a conflict because of a duplicated
> reference. I had to use an alias on my dotnetzip reference to fix the
> problem.
> Could you set your dotnetzip as a nugget references instead of including
> it in the package ?
> Thanks
>
> --
> 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
>
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Thu, 5 Jan 2017 07:02:15 +0000 (UTC)
> From: "Jiri Cincura (JIRA)" <tr...@fi...>
> Subject: [Firebird-net-provider] [FB-Tracker] Created: (DNET-730)
>         FirebirdSql.Data.Schema.FbMetaData.xml not in netstandard1.6
> version
> To: fir...@li...
> Message-ID:
>         <1879954929.17731483599735073.JavaMail.tomcat@tracker.
> firebirdsql.org>
> Content-Type: text/plain; charset=UTF-8
>
> FirebirdSql.Data.Schema.FbMetaData.xml not in netstandard1.6 version
> --------------------------------------------------------------------
>
>                  Key: DNET-730
>                  URL: http://tracker.firebirdsql.org/browse/DNET-730
>              Project: .NET Data provider
>           Issue Type: Bug
>           Components: ADO.NET Provider
>     Affects Versions: 5.7.0.0
>             Reporter: Jiri Cincura
>             Assignee: Jiri Cincura
>
>
>
>
> --
> 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
>
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sun, 8 Jan 2017 09:40:17 +0000 (UTC)
> From: "Hennadii Zabula (JIRA)" <tr...@fi...>
> Subject: [Firebird-net-provider] [FB-Tracker] Created: (DNET-731)
>         Issue with      FesBlob.GetSegment
> To: fir...@li...
> Message-ID:
>         <556365640.19981483868417517.JavaMail.tomcat@tracker.
> firebirdsql.org>
> Content-Type: text/plain; charset=UTF-8
>
> Issue with FesBlob.GetSegment
> -----------------------------
>
>                  Key: DNET-731
>                  URL: http://tracker.firebirdsql.org/browse/DNET-731
>              Project: .NET Data provider
>           Issue Type: Bug
>           Components: ADO.NET Provider
>             Reporter: Hennadii Zabula
>             Assignee: Jiri Cincura
>
>
> For additional info see:
> https://github.com/cincuranet/FirebirdSql.Data.
> FirebirdClient/pull/63/files/e40822db87455eb2d30bb9038ecf9b
> d574de722b#diff-baa9635582d6046a02882cb1d4877249R145
>
> There could be a bug with segmentLength/requested.
> I suggest, that in case segmentLength bigger than requested, this code
> should re-run with extended tmp buffer to segmentLegth buffer.
>
> Or if the code is right, remove completely this condition.
>
> --
> 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
>
>
>
>
>
> ------------------------------
>
> Message: 4
> Date: Mon, 9 Jan 2017 11:17:12 +0530
> From: LtColRDSChauhan <rds...@gm...>
> Subject: [Firebird-net-provider] Fill Method of FbDataAdapter fails
> To: fir...@li...
> Message-ID:
>         <CAMG8wxhhTcbbP4nOE0dc1gOC_vzXHTJszS6ssKaht0onGhGVKA@
> mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi,
>
> I am creating an object of FbDataAdapter, passing the constructor an object
> of FbCommand . The CommandText of this FbCommand object is a stored
> procedure.
>
> This worked fine. Recently calling Fill method of FbDataAdapter reports
> error [appended at the end of mail]. The copied CommandText, during debug,
> runs fine in Flamerobin. Also when i change the code to restrict the number
> of rows to say 50, it runs fine. Changed this in two ways (both ways it
> worked):
>
> (1) In the querry used " SELECT first 50 ... "
>
> (2) Passed arguments to Fill method: da.*Fill*(ds, 0, 50, "Table");
>
>
> Please help me to fetch all records using Fill method of FbDataAdapter.
>
>
> THE ERROR reported:
>
> System.IO.IOException: I/O error occurred.
>
> at Byte[] FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(System.Int32
> count)
>
> at Int32 FirebirdSql.Data.Client.Managed.XdrStream.ReadInt32()
>
> at Int32 FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()
>
> at Int32
> FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.NextOperation()
>
> at Int32
> FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.NextOperation()
>
> at DbValue[] FirebirdSql.Data.Client.Managed.Version10.
> GdsStatement.Fetch()
>
> at DbValue[] FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()
>
> at Boolean FirebirdSql.Data.FirebirdClient.FbDataReader.Read()
>
> at Boolean System.Data.ProviderBase.DataReaderContainer.Read()
>
> at Int32
> System.Data.Common.DataAdapter.FillLoadDataRow(System.Data.ProviderBase.
> SchemaMapping
> mapping)
>
> at Int32 System.Data.Common.DataAdapter.FillFromReader(System.Data.DataSet
> dataset, System.Data.DataTable datatable, System.String srcTable,
> System.Data.ProviderBase.DataReaderContainer dataReader, System.Int32
> startRecord, System.Int32 maxRecords, System.Data.DataColumn
> parentChapterColumn, System.Object parentChapterValue)
>
> at Int32 System.Data.Common.DataAdapter.Fill(System.Data.DataSet dataSet,
> System.String srcTable, System.Data.IDataReader dataReader, System.Int32
> startRecord, System.Int32 maxRecords)
>
> at Int32 System.Data.Common.DbDataAdapter.FillInternal(System.Data.DataSet
> dataset, System.Data.DataTable[] datatables, System.Int32 startRecord,
> System.Int32 maxRecords, System.String srcTable, System.Data.IDbCommand
> command, System.Data.CommandBehavior behavior)
>
> at Int32 System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet
> dataSet,
> System.Int32 startRecord, System.Int32 maxRecords, System.String srcTable,
> System.Data.IDbCommand command, System.Data.CommandBehavior behavior)
>
> at Int32 System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet
> dataSet,
> System.String srcTable)
>
> at static DataTable HMSLib.Ctrls.DtFromObjArray(System.Object arg)
>
> at static Object HMSLib.Ctrls.DgvDtFromObjArray(System.Object args)
>
> at static System.Void HMSLib.Ctrls.DgvDtProc(System.Object args)
>
> at static System.Void
> System.Threading.ThreadHelper.ThreadStart_Context(System.Object state)
>
> at static System.Void
> System.Threading.ExecutionContext.RunInternal(System.Threading.
> ExecutionContext
> executionContext, System.Threading.ContextCallback callback, System.Object
> state, System.Boolean preserveSyncCtx)
>
> at static System.Void
> System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext
> executionContext, System.Threading.ContextCallback callback, System.Object
> state, System.Boolean preserveSyncCtx)
>
> at static System.Void
> System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext
> executionContext, System.Threading.ContextCallback callback, System.Object
> state)
>
> at System.Void System.Threading.ThreadHelper.ThreadStart(System.Object
> obj)
>
>
> Regards,
>
> Rajiv
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 5
> Date: Mon, 09 Jan 2017 07:35:37 +0100
> From: Ji?? ?in?ura <ji...@ci...>
> Subject: Re: [Firebird-net-provider] Fill Method of FbDataAdapter
>         fails
> To: fir...@li...
> Message-ID:
>         <148...@we...
> >
> Content-Type: text/plain; charset="utf-8"
>
> What's the inner exception?
>
> 1. InnerException:
Error reading data from the connection.

2. StackTrace:
   at FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()
   at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()

3. FillError event is not fired.

> --
> Mgr. Ji?? ?in?ura
> Independent IT Specialist
>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Mon, 09 Jan 2017 15:55:31 +0100
> From: Ji?? ?in?ura <ji...@ci...>
> Subject: [Firebird-net-provider] Entity Framework 5
> To: "For users & developers of the Firebird .NET providers"
>         <fir...@li...>
> Message-ID:
>         <148...@we...
> >
> Content-Type: text/plain; charset="utf-8"
>
> Hi *,
>
> anybody still using EF5 (or even EF4)? Or is everybody on EF6...
> Thinking about slimming the FirebirdSql.Data.FirebirdClient and removing
> the old EF support and keeping only EF6 (EntityFramework.Firebird).
>
> --
> Mgr. Ji?? ?in?ura
> Independent IT Specialist
>
>
>
> ------------------------------
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>
> ------------------------------
>
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> End of Firebird-net-provider Digest, Vol 129, Issue 1
> *****************************************************
>

[Firebird-net-provider] Entity Framework 5

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

Hi *,

anybody still using EF5 (or even EF4)? Or is everybody on EF6...
Thinking about slimming the FirebirdSql.Data.FirebirdClient and removing
the old EF support and keeping only EF6 (EntityFramework.Firebird).

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

Re: [Firebird-net-provider] Fill Method of FbDataAdapter fails

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

What's the inner exception?

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

[Firebird-net-provider] Fill Method of FbDataAdapter fails

[LtColRDSChauhan <rds...@gm...>]

Hi,

I am creating an object of FbDataAdapter, passing the constructor an object
of FbCommand . The CommandText of this FbCommand object is a stored
procedure.

This worked fine. Recently calling Fill method of FbDataAdapter reports
error [appended at the end of mail]. The copied CommandText, during debug,
runs fine in Flamerobin. Also when i change the code to restrict the number
of rows to say 50, it runs fine. Changed this in two ways (both ways it
worked):

(1) In the querry used " SELECT first 50 ... "

(2) Passed arguments to Fill method: da.*Fill*(ds, 0, 50, "Table");


Please help me to fetch all records using Fill method of FbDataAdapter.


THE ERROR reported:

System.IO.IOException: I/O error occurred.

at Byte[] FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(System.Int32
count)

at Int32 FirebirdSql.Data.Client.Managed.XdrStream.ReadInt32()

at Int32 FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()

at Int32
FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.NextOperation()

at Int32
FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.NextOperation()

at DbValue[] FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()

at DbValue[] FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()

at Boolean FirebirdSql.Data.FirebirdClient.FbDataReader.Read()

at Boolean System.Data.ProviderBase.DataReaderContainer.Read()

at Int32
System.Data.Common.DataAdapter.FillLoadDataRow(System.Data.ProviderBase.SchemaMapping
mapping)

at Int32 System.Data.Common.DataAdapter.FillFromReader(System.Data.DataSet
dataset, System.Data.DataTable datatable, System.String srcTable,
System.Data.ProviderBase.DataReaderContainer dataReader, System.Int32
startRecord, System.Int32 maxRecords, System.Data.DataColumn
parentChapterColumn, System.Object parentChapterValue)

at Int32 System.Data.Common.DataAdapter.Fill(System.Data.DataSet dataSet,
System.String srcTable, System.Data.IDataReader dataReader, System.Int32
startRecord, System.Int32 maxRecords)

at Int32 System.Data.Common.DbDataAdapter.FillInternal(System.Data.DataSet
dataset, System.Data.DataTable[] datatables, System.Int32 startRecord,
System.Int32 maxRecords, System.String srcTable, System.Data.IDbCommand
command, System.Data.CommandBehavior behavior)

at Int32 System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet dataSet,
System.Int32 startRecord, System.Int32 maxRecords, System.String srcTable,
System.Data.IDbCommand command, System.Data.CommandBehavior behavior)

at Int32 System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet dataSet,
System.String srcTable)

at static DataTable HMSLib.Ctrls.DtFromObjArray(System.Object arg)

at static Object HMSLib.Ctrls.DgvDtFromObjArray(System.Object args)

at static System.Void HMSLib.Ctrls.DgvDtProc(System.Object args)

at static System.Void
System.Threading.ThreadHelper.ThreadStart_Context(System.Object state)

at static System.Void
System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext
executionContext, System.Threading.ContextCallback callback, System.Object
state, System.Boolean preserveSyncCtx)

at static System.Void
System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext
executionContext, System.Threading.ContextCallback callback, System.Object
state, System.Boolean preserveSyncCtx)

at static System.Void
System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext
executionContext, System.Threading.ContextCallback callback, System.Object
state)

at System.Void System.Threading.ThreadHelper.ThreadStart(System.Object obj)


Regards,

Rajiv