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