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

2017-01-10 Thread Jiří Činčura 
> 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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

2017-01-09 Thread LtColRDSChauhan 
>
>1. Fill Method of FbDataAdapter fails (LtColRDSChauhan)
>
>
> --
>
> Message: 1
> Date: Mon, 9 Jan 2017 22:30:21 +0530
> From: LtColRDSChauhan 
> Subject: [Firebird-net-provider] Fill Method of FbDataAdapter fails
> To: firebird-net-provider@lists.sourceforge.net
> Message-ID:
>  gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Mon, Jan 9, 2017 at 8:25 PM, <
> firebird-net-provider-requ...@lists.sourceforge.net> wrote:
>
> > Send Firebird-net-provider mailing list submissions to
> > firebird-net-provider@lists.sourceforge.net
> >
> > 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
> > firebird-net-provider-requ...@lists.sourceforge.net
> >
> > You can reach the person managing the list at
> > firebird-net-provider-ow...@lists.sourceforge.net
> >
> > 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.O

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

2017-01-09 Thread LtColRDSChauhan 
gment
> -
>
>  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 
> Subject: [Firebird-net-provider] Fill Method of FbDataAdapter fails
> To: firebird-net-provider@lists.sourceforge.net
> Message-ID:
>  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 cal

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

2017-01-08 Thread Jiří Činčura 
What's the inner exception?

-- 
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

2017-01-08 Thread LtColRDSChauhan 
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
--
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider