Quantcast

Fill Method of FbDataAdapter fails

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Fill Method of FbDataAdapter fails

LtColRDSChauhan


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


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)" <[hidden email]>
Subject: [Firebird-net-provider] [FB-Tracker] Created: (DNET-729)
        Conflict        with ionic zip package
To: [hidden email]
Message-ID:
        <[hidden email]>
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)" <[hidden email]>
Subject: [Firebird-net-provider] [FB-Tracker] Created: (DNET-730)
        FirebirdSql.Data.Schema.FbMetaData.xml not in netstandard1.6 version
To: [hidden email]
Message-ID:
        <[hidden email]>
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)" <[hidden email]>
Subject: [Firebird-net-provider] [FB-Tracker] Created: (DNET-731)
        Issue with      FesBlob.GetSegment
To: [hidden email]
Message-ID:
        <[hidden email]>
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/e40822db87455eb2d30bb9038ecf9bd574de722b#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 <[hidden email]>
Subject: [Firebird-net-provider] Fill Method of FbDataAdapter fails
To: [hidden email]
Message-ID:
        <[hidden email]>
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 <[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.

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 <[hidden email]>
Subject: [Firebird-net-provider] Entity Framework 5
To: "For users & developers of the Firebird .NET providers"
        <[hidden email]>
Message-ID:
        <[hidden email]>
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


End of Firebird-net-provider Digest, Vol 129, Issue 1
*****************************************************


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