Fill Method of FbDataAdapter fails

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Fill Method of FbDataAdapter fails

LtColRDSChauhan
   1. Fill Method of FbDataAdapter fails (LtColRDSChauhan)


----------------------------------------------------------------------

Message: 1
Date: Mon, 9 Jan 2017 22:30:21 +0530
From: LtColRDSChauhan <[hidden email]>
Subject: [Firebird-net-provider] Fill Method of FbDataAdapter fails
To: [hidden email]
Message-ID:
        <CAMG8wxgSiZBGZZxMu1DEHx44GfMVG7=[hidden email]>
Content-Type: text/plain; charset="utf-8"

On Mon, Jan 9, 2017 at 8:25 PM, <
[hidden email]> wrote:

> Send Firebird-net-provider mailing list submissions to
>         [hidden email]
>
> 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
>         [hidden email]
>
> You can reach the person managing the list at
>         [hidden email]
>
> 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 <[hidden email]>
> Subject: Re: [Firebird-net-provider] Fill Method of FbDataAdapter
>         fails
> To: [hidden email]
> Message-ID:
>         <[hidden email]
> >
> 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
>
>
>
>
> ------------------------------


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Fill Method of FbDataAdapter fails

Jiří Činčura-2
> 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

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider