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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-813) Unify the usage of isc_network_error/isc_net_write_err/isc_net_read_err

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

Unify the usage of isc_network_error/isc_net_write_err/isc_net_read_err
-----------------------------------------------------------------------

                 Key: DNET-813
                 URL: http://tracker.firebirdsql.org/browse/DNET-813
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider
            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-812) Support for Firebird 4

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

Support for Firebird 4
----------------------

                 Key: DNET-812
                 URL: http://tracker.firebirdsql.org/browse/DNET-812
             Project: .NET Data provider
          Issue Type: New Feature
            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-811) Can't use new created columns in SQL - Statement in Up() Migration

[Andreas P. (JIRA) <tr...@fi...>]

Can't use new created columns in SQL - Statement in Up() Migration
------------------------------------------------------------------

                 Key: DNET-811
                 URL: http://tracker.firebirdsql.org/browse/DNET-811
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework
    Affects Versions: 5.9.1.0
            Reporter: Andreas Patock
            Assignee: Jiri Cincura


If I have the following migration:

   public partial class AddDeviceType : DbMigration
    {
        public override void Up()
        {
            CreateTable(
                "dbo.DeviceType",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(nullable: false, maxLength: 128),
                        ManufacturerId = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Manufacturer", t => t.ManufacturerId, cascadeDelete: true)
                .Index(t => t.ManufacturerId);
            
            AddColumn("dbo.Device", "TempDeviceTypeId", c => c.Int());
            AddColumn("dbo.Device", "DeviceTypeId", c => c.Int(nullable: false));
            CreateIndex("dbo.Device", "DeviceTypeId");
            AddForeignKey("dbo.Device", "DeviceTypeId", "dbo.DeviceType", "Id", cascadeDelete: true);

            Sql("UPDATE \"Device\" d SET d.\"DeviceTypeId\" = (SELECT t.\"Id\" from \"DeviceType\" t where t.\"ManufacturerId\" = d.\"ManufacturerId\" ORDER BY t.\"Id\" ROWS 1)");
        }

I can a Column unknown "DeviceTypeId" exception when running the migration. This can found on many examples in the internet and is working with mssql.

I had the idea to do this in two migrations, but the "DeviceTypeId" is a not null field and so the first migration throws an exception also.

-- 
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-810) Support for DECFLOAT in FB4

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

Support for DECFLOAT in FB4
---------------------------

                 Key: DNET-810
                 URL: http://tracker.firebirdsql.org/browse/DNET-810
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
            Reporter: fish
            Assignee: Jiri Cincura


For reference the initial implementation in Jaybird: https://github.com/FirebirdSQL/jaybird/commit/567d93a988194f545659b90feccfa9a40dba811c

-- 
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-808) Add support for Thai charset TIS620

[Phubase T. (JIRA) <tr...@fi...>]

Add support for Thai charset TIS620
-----------------------------------

                 Key: DNET-808
                 URL: http://tracker.firebirdsql.org/browse/DNET-808
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 5.12.1.0
            Reporter: Phubase Tiewthanom
            Assignee: Jiri Cincura
            Priority: Minor


Add support for Thai charset TIS620 which is available since Firebird 2.1 

-- 
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-807) Exception: The socket has been shut down.

[Pascal D. (JIRA) <tr...@fi...>]

Exception: The socket has been shut down.
-----------------------------------------

                 Key: DNET-807
                 URL: http://tracker.firebirdsql.org/browse/DNET-807
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.5.0.0
         Environment: Ubuntu 16.04 lts
Mono 5.2.0.215
Pooling active (default )
            Reporter: Pascal D.
            Assignee: Jiri Cincura


We use the Firebird driver to communicate with the Firebird database and our web service. Sometimes there is an error that can only be corrected by restarting the process. The following exception is thrown here:

{
	"ClassName": "FirebirdSql.Data.FirebirdClient.FbException",
	"Message": "Error reading data from the connection.",
	"Data": null,
	"InnerException": {
		"ClassName": "FirebirdSql.Data.Common.IscException",
		"Message": "Unable to write data to the transport connection: The socket has been shut down.",
		"Data": null,
		"InnerException": {
			"ClassName": "System.IO.IOException",
			"Message": "Unable to write data to the transport connection: The socket has been shut down.",
			"Data": null,
			"InnerException": {
				"NativeErrorCode": 10058,
				"ClassName": "System.Net.Sockets.SocketException",
				"Message": "The socket has been shut down",
				"Data": null,
				"InnerException": null,
				"HelpURL": null,
				"StackTraceString": "  at System.Net.Sockets.Socket.Send (System.Byte[] buffer, System.Int32 offset, System.Int32 size, System.Net.Sockets.SocketFlags socketFlags) [0x00016] in <d2c057d9d34d4e029e580897bd60340c>:0 \n  at System.Net.Sockets.NetworkStream.Write (System.Byte[] buffer, System.Int32 offset, System.Int32 size) [0x0009b] in <d2c057d9d34d4e029e580897bd60340c>:0 ",
				"RemoteStackTraceString": null,
				"RemoteStackIndex": 0,
				"ExceptionMethod": null,
				"HResult": -2147467259,
				"Source": "System"
			},
			"HelpURL": null,
			"StackTraceString": "  at System.Net.Sockets.NetworkStream.Write (System.Byte[] buffer, System.Int32 offset, System.Int32 size) [0x000e2] in <d2c057d9d34d4e029e580897bd60340c>:0 \n  at FirebirdSql.Data.Client.Managed.XdrStream.Flush () [0x000d3] in <5e7529d7713a478ca878b28774fda053>:0 \n  at FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction (FirebirdSql.Data.Common.TransactionParameterBuffer tpb) [0x00085] in <5e7529d7713a478ca878b28774fda053>:0 ",
			"RemoteStackTraceString": null,
			"RemoteStackIndex": 0,
			"ExceptionMethod": null,
			"HResult": -2146232800,
			"Source": "System"
		},
		"HelpURL": null,
		"StackTraceString": "  at FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction (FirebirdSql.Data.Common.TransactionParameterBuffer tpb) [0x000dd] in <5e7529d7713a478ca878b28774fda053>:0 \n  at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.BeginTransaction (FirebirdSql.Data.Common.TransactionParameterBuffer tpb) [0x00006] in <5e7529d7713a478ca878b28774fda053>:0 \n  at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction () [0x00023] in <5e7529d7713a478ca878b28774fda053>:0 ",
		"RemoteStackTraceString": null,
		"RemoteStackIndex": 0,
		"ExceptionMethod": null,
		"HResult": -2146233088,
		"Source": "FirebirdSql.Data.FirebirdClient",
		"errors": [{
			"Message": null,
			"ErrorCode": 335544726,
			"StrParam": "",
			"Type": 1,
			"IsArgument": false,
			"IsWarning": false
		}, {
			"Message": "Error reading data from the connection.",
			"ErrorCode": 335544726,
			"StrParam": "",
			"Type": 0,
			"IsArgument": false,
			"IsWarning": false
		}],
		"errorCode": 335544726
	},
	"HelpURL": null,
	"StackTraceString": "  at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction () [0x0003c] in <5e7529d7713a478ca878b28774fda053>:0 \n  at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbTransaction:BeginTransaction ()\n  at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare (System.Boolean returnsSet) [0x00058] in <5e7529d7713a478ca878b28774fda053>:0 \n  at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand (System.Data.CommandBehavior behavior, System.Boolean returnsSet) [0x00000] in <5e7529d7713a478ca878b28774fda053>:0 \n  at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00037] in <5e7529d7713a478ca878b28774fda053>:0 \n  at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader () [0x00000] in <5e7529d7713a478ca878b28774fda053>:0 \n  at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbCommand:ExecuteReader ()\n  at FirebirdTest.Program.Select (FirebirdSql.Data.FirebirdClient.FbConnection 
	"RemoteStackTraceString": null,
	"RemoteStackIndex": 0,
	"ExceptionMethod": null,
	"HResult": -2147467259,
	"Source": "FirebirdSql.Data.FirebirdClient",
	"errors": [{
		"Class": 0,
		"LineNumber": 0,
		"Message": null,
		"Number": 335544726
	}, {
		"Class": 0,
		"LineNumber": 0,
		"Message": "Error reading data from the connection.",
		"Number": 335544726
	}]
}

Couldn't the driver automatically delete the connection from the pool? 

-- 
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-806) .NET provider should explicitly call fb_shutdown() on application exit when using Firebird Embedded

[Mark R. (JIRA) <tr...@fi...>]

.NET provider should explicitly call fb_shutdown() on application exit when using Firebird Embedded
---------------------------------------------------------------------------------------------------

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


If the apllication exits and there are still connections open using Firebird Embedded, then the exit may produce an access violation (0xc0000005 error). The root cause is that the fbembed.dll/fbclient.dll will call fb_shutdown() itself, but one of the other libraries (eg fbintl.dll) may already have been unloaded.

To prevent this, on exit the .NET provider should explicitly call fb_shutdown for any of the native libries loaded (but especially for embedded).

See also "Crash Firebird 2.5.8 Embedded with Firebird Ado.net provider." on Firebird-devel.

Related: DNET-802 (cleaning up the connection pool on exit will also prevent the access violation).

-- 
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-805) Reading blobs with packet size of short.MaxValue causes exception

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

Reading blobs with packet size of short.MaxValue causes exception
-----------------------------------------------------------------

                 Key: DNET-805
                 URL: http://tracker.firebirdsql.org/browse/DNET-805
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.12.1.0
            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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-804) Connection lost to database with embed connection

[Zeki G. (J. <tr...@fi...>]

Connection lost to database with embed connection
-------------------------------------------------

                 Key: DNET-804
                 URL: http://tracker.firebirdsql.org/browse/DNET-804
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
            Reporter: Zeki Gürsoy
            Assignee: Jiri Cincura


Firebird 3.0.2 64 bit, application 64 bit, Provider 5.12.1.0

When I conneccting to database with embed connection, I get error message 'connection lost to database'

My connection and code below:

Dim cn As String

      cn = "ServerType=1;User=SYSDBA;" &
      "Database=C:\Program Files\Firebird\Firebird_3_0\examples\empbuild\EMPLOYEE.FDB;" &
      "ClientLibrary=D:\PROGRAMLAR\fbembed.dll"

      Dim x As New FirebirdSql.Data.FirebirdClient.FbConnection(cn)

      x.Open()
      x.Close()

-- 
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-803) XdrStream Pad and Fill possible race condition

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

XdrStream Pad and Fill possible race condition
----------------------------------------------

                 Key: DNET-803
                 URL: http://tracker.firebirdsql.org/browse/DNET-803
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 5.12.1.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor


Pad and Fill are used for reading and also writing (though same data) and that *might* cause some race conditions.

-- 
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-802) Pool cleanup on process/domain exit

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

Pool cleanup on process/domain exit
-----------------------------------

                 Key: DNET-802
                 URL: http://tracker.firebirdsql.org/browse/DNET-802
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 6.0.0.0
            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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-801) Migration Problem

[Andreas P. (JIRA) <tr...@fi...>]

Migration Problem
-----------------

                 Key: DNET-801
                 URL: http://tracker.firebirdsql.org/browse/DNET-801
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.9.1.0
         Environment: Firebird 2.5
            Reporter: Andreas Patock
            Assignee: Jiri Cincura


Hi Jiri,
you wanted to post me this to the issue tracker - here it is.


I have a problem add a new column via migration to a codefirst database.

This is the code for the migration:

    public partial class StreamingModuleAddAddress2 : DbMigration
    {
        public override void Up()
        {
            AddColumn("dbo.StreamingModule", "Address1", c => c.String(nullable: false, maxLength: 23));
            AddColumn("dbo.StreamingModule", "Address2", c => c.String(nullable: false, maxLength: 23));
            AddColumn("dbo.StreamingModule", "Port1", c => c.Int(nullable: false));
            AddColumn("dbo.StreamingModule", "Port2", c => c.Int(nullable: false));
            DropColumn("dbo.StreamingModule", "Address");
            DropColumn("dbo.StreamingModule", "Port");
        }
        
        public override void Down()
        {
            AddColumn("dbo.StreamingModule", "Port", c => c.Int(nullable: false));
            AddColumn("dbo.StreamingModule", "Address", c => c.String(nullable: false, maxLength: 23));
            DropColumn("dbo.StreamingModule", "Port2");
            DropColumn("dbo.StreamingModule", "Port1");
            DropColumn("dbo.StreamingModule", "Address2");
            DropColumn("dbo.StreamingModule", "Address1");
        }
    }

But when running entityframework creates the following sql:

ALTER TABLE "StreamingModule" ADD "Address1" VARCHAR(23) DEFAULT CAST(_UTF8'' AS VARCHAR(0)) NOT NULL

I think firebird doesn't allow the CAST in a DEFAULT statement!

And this causes the following exception:

FirebirdSql.Data.FirebirdClient.FbException was unhandled
  ErrorCode=335544569
  HResult=-2147467259
  Message=Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 66
CAST
  SQLSTATE=42000
  Source=FirebirdSql.Data.FirebirdClient
  StackTrace:
       bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
       bei System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c)
       bei System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
       bei System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext)
       bei System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery()
       bei System.Data.Entity.Migrations.DbMigrator.ExecuteSql(MigrationStatement migrationStatement, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext)
       bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext)
       bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinTransaction(IEnumerable`1 migrationStatements, DbTransaction transaction, DbInterceptionContext interceptionContext)
       bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinNewTransaction(IEnumerable`1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext)
       bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext)
       bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection)
       bei System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClass30.<ExecuteStatements>b__2e()
       bei System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute(Action operation)
       bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable`1 migrationStatements, DbTransaction existingTransaction)
       bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable`1 migrationStatements)
       bei System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, VersionedModel targetModel, IEnumerable`1 operations, IEnumerable`1 systemOperations, Boolean downgrading, Boolean auto)
       bei System.Data.Entity.Migrations.DbMigrator.ApplyMigration(DbMigration migration, DbMigration lastMigration)
       bei System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
       bei System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration)
       bei System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClassc.<Update>b__b()
       bei System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
       bei System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)
       bei System.Data.Entity.MigrateDatabaseToLatestVersion`2.InitializeDatabase(TContext context)
       bei System.Data.Entity.Internal.InternalContext.<>c__DisplayClassf`1.<CreateInitializationAction>b__e()
       bei System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)
       bei System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization()
       bei System.Data.Entity.Internal.LazyInternalContext.<InitializeDatabase>b__4(InternalContext c)
       bei System.Data.Entity.Internal.RetryAction`1.PerformAction(TInput input)
       bei System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action`1 action)
       bei System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase()
       bei System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
       bei System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
       bei System.Data.Entity.Internal.Linq.InternalSet`1.GetEnumerator()
       bei System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator()
       bei System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       bei System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       bei ConsoleTester.Program.Main(String[] args) in C:\WorkDir_Trunk\Win\Bfe\KscSilknet\Database\ConsoleTester\Program.cs:Zeile 22.
       bei System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
       bei System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
       bei Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       bei System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       bei System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       bei System.Threading.ThreadHelper.ThreadStart()
  InnerException: 
       ErrorCode=335544569
       HResult=-2146233088
       IsWarning=false
       Message=Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 66
CAST
       SQLSTATE=42000
       Source=FirebirdSql.Data.FirebirdClient
       StackTrace:
            bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response)
            bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()
            bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()
            bei FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText)
            bei FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
            bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
            bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
       InnerException:

Do you have any Idea how to fix that?

Kind regards,
Andreas



-- 
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-800) Support for SupportsParameterOptimizationInSchemaQueries

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

Support for SupportsParameterOptimizationInSchemaQueries
--------------------------------------------------------

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-799) Wrong computation of IsAlive in connection pool

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

Wrong computation of IsAlive in connection pool
-----------------------------------------------

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


https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/75

-- 
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] Clear All COnnection Pools

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

Hi,
How can I clear all connection pools.
Regards,
Rajiv

[Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 9

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

On Thu, Nov 23, 2017 at 10:54 AM, <
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. Error reading data from the connection Re:
>       Firebird-net-provider Digest, Vol 139, Issue 7 (LtColRDSChauhan)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 23 Nov 2017 10:54:48 +0530
> From: LtColRDSChauhan <rds...@gm...>
> To: fir...@li...
> Subject: [Firebird-net-provider] Error reading data from the
>         connection Re: Firebird-net-provider Digest, Vol 139, Issue 7
> Message-ID:
>         <CAMG8wxgcL1RM2EWhX3pf46Kcmr+Tya=Yb7ef8gPjN0yJcRnhAg@mail.
> gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Sat, Nov 18, 2017 at 7:31 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. Error reading data from the connection Re:
> >       Firebird-net-provider Digest, Vol 139, Issue 6 (LtColRDSChauhan)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Sat, 18 Nov 2017 19:31:44 +0530
> > From: LtColRDSChauhan <rds...@gm...>
> > To: fir...@li...
> > Subject: [Firebird-net-provider] Error reading data from the
> >         connection Re: Firebird-net-provider Digest, Vol 139, Issue 6
> > Message-ID:
> >         <CAMG8wxj8BvBGE88rEvN=2zhg7-W9u-VSZPU_wtCJkok1WKrXgg@mail.
> > gmail.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > On Sat, Nov 18, 2017 at 5:46 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. Re: Error reading data from the connection Re:
> > >       Firebird-net-provider Digest, Vol 139, Issue 3 (Ji?? ?in?ura)
> > >
> > >
> > > ----------------------------------------------------------------------
> > >
> > > Message: 1
> > > Date: Sat, 18 Nov 2017 09:07:35 +0100
> > > From: Ji?? ?in?ura <ji...@ci...>
> > > To: fir...@li...
> > > Subject: Re: [Firebird-net-provider] Error reading data from the
> > >         connection Re: Firebird-net-provider Digest, Vol 139, Issue 3
> > > Message-ID:
> > >         <1510992455.1577004.1176679856.4C4DB47A@webmail.
> > > messagingengine.com>
> > > Content-Type: text/plain; charset="utf-8"
> > >
> > > I would check inner exception to see what happened.
> > >
> > >
> > Thanks for responding, Jiri.
> > The details of exception are as under please. Let me know if more details
> > are required.
> >
> >
> > -                             ex           {"Error reading data from the
> > connection."}               FirebirdSql.Data.FirebirdClient.FbException
> >
> > +                            Data
> > {System.Collections.ListDictionaryInternal}
> > System.Collections.IDictionary
> > {System.Collections.ListDictionaryInternal}
> >
> >                               ErrorCode           335544726          int
> >
> > +                            Errors
> > {FirebirdSql.Data.FirebirdClient.FbErrorCollection}
> > FirebirdSql.Data.FirebirdClient.FbErrorCollection
> >
> >                               HResult -2147467259      int
> >
> >                               HelpLink               null         string
> >
> > -                             InnerException   {"Error reading data from
> > the connection."}               System.Exception
> > {FirebirdSql.Data.Common.IscException}
> >
> > +                            Data
> > {System.Collections.ListDictionaryInternal}
> > System.Collections.IDictionary
> > {System.Collections.ListDictionaryInternal}
> >
> >                               ErrorCode           335544726          int
> >
> > +                            Errors    Count = 2
> > System.Collections.Generic.List<FirebirdSql.Data.Common.IscError>
> >
> >                               HResult -2146233088      int
> >
> >                               HelpLink               null         string
> >
> > -                             InnerException   {"I/O error occurred."}
> >    System.Exception
> > {System.IO.IOException}
> >
> > +                            Data
> > {System.Collections.ListDictionaryInternal}
> > System.Collections.IDictionary
> > {System.Collections.ListDictionaryInternal}
> >
> >                               HResult -2146232800      int
> >
> >                               HelpLink               null         string
> >
> > -                             InnerException   null
> >  System.Exception
> >
> > +                            Static members
> >
> >                               Message              "I/O error occurred."
> > string
> >
> >                               Source
> > "FirebirdSql.Data.FirebirdClient"
> > string
> >
> >                               StackTrace          "   at
> > FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(Int32 count)\r\n
>  at
> > FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()\r\n   at
> > FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.
> NextOperation()\r\n
> >  at
> > FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()"
> > string
> >
> > +                            TargetSite           {Byte[]
> > ReadBytes(Int32)}
> > System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo}
> >
> > +                            Static members
> >
> > +                            Non-Public members
> >
> >                               IsWarning            false      bool
> >
> >                               Message              "Error reading data
> from
> > the connection."            string
> >
> >                               SQLSTATE            "08006"
> > string
> >
> >                               Source
> > "FirebirdSql.Data.FirebirdClient"
> > string
> >
> >                               StackTrace          "   at
> > FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()\r\n   at
> > FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()"         string
> >
> > +                            TargetSite
> > {FirebirdSql.Data.Common.DbValue[]
> > Fetch()}               System.Reflection.MethodBase
> > {System.Reflection.RuntimeMethodInfo}
> >
> > +                            Static members
> >
> > +                            Non-Public members
> >
> >                               Message              "Error reading data
> from
> > the connection."            string
> >
> >                               SQLSTATE            "08006"
> > string
> >
> >                               Source
> > "FirebirdSql.Data.FirebirdClient"
> > string
> >
> >                               StackTrace          "   at
> > FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()\r\n   at
> > FirebirdSql.Data.FirebirdClient.FbDataReader.Read()\r\n   at
> > System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping
> > mapping)\r\n   at
> > System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
> > datatable, String srcTable, DataReaderContainer dataReader, Int32
> > startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
> > parentChapterValue)\r\n   at System.Data.Common.DataAdapter.Fill(DataSet
> > dataSet, String srcTable, IDataReader dataReader, Int32 startRecord,
> Int32
> > maxRecords)\r\n   at System.Data.Common.DbDataAdapter.FillInternal(
> DataSet
> > dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords,
> > String srcTable, IDbCommand command, CommandBehavior behavior)\r\n   at
> > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
> startRecord,
> > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
> > behavior)\r\n   at System.Data.Common.DbDataAdapter.Fill(DataSet
> dataSet,
> > String srcTable)\r\n   at HMSMaster.FHMSMaster.TableS_N_ROWS_Fill(String
> > tableS, Int64 nRows, Int64 iSkip, String strOrderBy) in
> > D:\\HMS\\AppHMS\\SolnHMS\\HMSMaster\\FHMSMaster.cs:line 1294"
> > string
> >
> > +                            TargetSite
> > {FirebirdSql.Data.Common.DbValue[]
> > Fetch()}               System.Reflection.MethodBase
> > {System.Reflection.RuntimeMethodInfo}
> >
> > +                            Static members
> >
> > +                            Non-Public members
> >
> >
> Additional inputs:
>
> I observed that while copying 13,26,000 records from source in batches of
> 50,000 each, exception was raised after copying 12,50,000.
> So from the source I deleted the already copied 12,50,000 records and
> resumed to copy the remaining 76,000.
> This also failed.
> Attempted versions: 6 Alpha 2, 5.12.0.0, 5.11.0.0 and 4.5.2.0.
> However, I could manually insert the 76,000 records using flamerobin.
>
> Now to copy this particular table of the database I am using
> FbCommand's ExecuteNonQuery to run a stored procedure which copies record
> using Execute Statement On External database.
> This works fine and faster.
>
> For the time being, I appear to have manoeuvred out of dead end.
>
>
>
Inputs from firebird-support helped me pinpoint the issue in my case: Use
of default isolation level in FbTransaction.
Changing to the under mentioned resolved my issue :

     tx = con.BeginTransaction(
      new FbTransactionOptions() {
       TransactionBehavior = FbTransactionBehavior.Concurrency |
FbTransactionBehavior.NoWait
      }
     );

>
> > > --
> > > Mgr. Ji?? ?in?ura
> > > https://www.tabsoverspaces.com/
> > >
> > >
> > >
> > >
> > > ------------------------------
> > >
> > > ------------------------------------------------------------
> > > ------------------
> > > Check out the vibrant tech community on one of the world's most
> > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> > >
> > > ------------------------------
> > >
> > > Subject: Digest Footer
> > >
> > > _______________________________________________
> > > Firebird-net-provider mailing list
> > > Fir...@li...
> > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> > >
> > >
> > > ------------------------------
> > >
> > > End of Firebird-net-provider Digest, Vol 139, Issue 6
> > > *****************************************************
> > >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> >
> > ------------------------------
> >
> > ------------------------------------------------------------
> > ------------------
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> >
> > ------------------------------
> >
> > Subject: Digest Footer
> >
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> >
> > ------------------------------
> >
> > End of Firebird-net-provider Digest, Vol 139, Issue 7
> > *****************************************************
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------
>
> End of Firebird-net-provider Digest, Vol 139, Issue 9
> *****************************************************
>

[Firebird-net-provider] [FB-Tracker] Created: (DNET-797) EF Core Migrations support

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

EF Core Migrations support
--------------------------

                 Key: DNET-797
                 URL: http://tracker.firebirdsql.org/browse/DNET-797
             Project: .NET Data provider
          Issue Type: Sub-task
          Components: Entity Framework Core
            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-798) EF Core scaffolding support

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

EF Core scaffolding support
---------------------------

                 Key: DNET-798
                 URL: http://tracker.firebirdsql.org/browse/DNET-798
             Project: .NET Data provider
          Issue Type: Sub-task
          Components: Entity Framework Core
            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] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 7

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

On Sat, Nov 18, 2017 at 7:31 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. Error reading data from the connection Re:
>       Firebird-net-provider Digest, Vol 139, Issue 6 (LtColRDSChauhan)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 18 Nov 2017 19:31:44 +0530
> From: LtColRDSChauhan <rds...@gm...>
> To: fir...@li...
> Subject: [Firebird-net-provider] Error reading data from the
>         connection Re: Firebird-net-provider Digest, Vol 139, Issue 6
> Message-ID:
>         <CAMG8wxj8BvBGE88rEvN=2zhg7-W9u-VSZPU_wtCJkok1WKrXgg@mail.
> gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Sat, Nov 18, 2017 at 5:46 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. Re: Error reading data from the connection Re:
> >       Firebird-net-provider Digest, Vol 139, Issue 3 (Ji?? ?in?ura)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Sat, 18 Nov 2017 09:07:35 +0100
> > From: Ji?? ?in?ura <ji...@ci...>
> > To: fir...@li...
> > Subject: Re: [Firebird-net-provider] Error reading data from the
> >         connection Re: Firebird-net-provider Digest, Vol 139, Issue 3
> > Message-ID:
> >         <1510992455.1577004.1176679856.4C4DB47A@webmail.
> > messagingengine.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > I would check inner exception to see what happened.
> >
> >
> Thanks for responding, Jiri.
> The details of exception are as under please. Let me know if more details
> are required.
>
>
> -                             ex           {"Error reading data from the
> connection."}               FirebirdSql.Data.FirebirdClient.FbException
>
> +                            Data
> {System.Collections.ListDictionaryInternal}
> System.Collections.IDictionary
> {System.Collections.ListDictionaryInternal}
>
>                               ErrorCode           335544726          int
>
> +                            Errors
> {FirebirdSql.Data.FirebirdClient.FbErrorCollection}
> FirebirdSql.Data.FirebirdClient.FbErrorCollection
>
>                               HResult -2147467259      int
>
>                               HelpLink               null         string
>
> -                             InnerException   {"Error reading data from
> the connection."}               System.Exception
> {FirebirdSql.Data.Common.IscException}
>
> +                            Data
> {System.Collections.ListDictionaryInternal}
> System.Collections.IDictionary
> {System.Collections.ListDictionaryInternal}
>
>                               ErrorCode           335544726          int
>
> +                            Errors    Count = 2
> System.Collections.Generic.List<FirebirdSql.Data.Common.IscError>
>
>                               HResult -2146233088      int
>
>                               HelpLink               null         string
>
> -                             InnerException   {"I/O error occurred."}
>    System.Exception
> {System.IO.IOException}
>
> +                            Data
> {System.Collections.ListDictionaryInternal}
> System.Collections.IDictionary
> {System.Collections.ListDictionaryInternal}
>
>                               HResult -2146232800      int
>
>                               HelpLink               null         string
>
> -                             InnerException   null
>  System.Exception
>
> +                            Static members
>
>                               Message              "I/O error occurred."
> string
>
>                               Source
> "FirebirdSql.Data.FirebirdClient"
> string
>
>                               StackTrace          "   at
> FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(Int32 count)\r\n   at
> FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()\r\n   at
> FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.NextOperation()\r\n
>  at
> FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()"
> string
>
> +                            TargetSite           {Byte[]
> ReadBytes(Int32)}
> System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo}
>
> +                            Static members
>
> +                            Non-Public members
>
>                               IsWarning            false      bool
>
>                               Message              "Error reading data from
> the connection."            string
>
>                               SQLSTATE            "08006"
> string
>
>                               Source
> "FirebirdSql.Data.FirebirdClient"
> string
>
>                               StackTrace          "   at
> FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()\r\n   at
> FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()"         string
>
> +                            TargetSite
> {FirebirdSql.Data.Common.DbValue[]
> Fetch()}               System.Reflection.MethodBase
> {System.Reflection.RuntimeMethodInfo}
>
> +                            Static members
>
> +                            Non-Public members
>
>                               Message              "Error reading data from
> the connection."            string
>
>                               SQLSTATE            "08006"
> string
>
>                               Source
> "FirebirdSql.Data.FirebirdClient"
> string
>
>                               StackTrace          "   at
> FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()\r\n   at
> FirebirdSql.Data.FirebirdClient.FbDataReader.Read()\r\n   at
> System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping
> mapping)\r\n   at
> System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
> datatable, String srcTable, DataReaderContainer dataReader, Int32
> startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
> parentChapterValue)\r\n   at System.Data.Common.DataAdapter.Fill(DataSet
> dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32
> maxRecords)\r\n   at System.Data.Common.DbDataAdapter.FillInternal(DataSet
> dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords,
> String srcTable, IDbCommand command, CommandBehavior behavior)\r\n   at
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
> Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
> behavior)\r\n   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet,
> String srcTable)\r\n   at HMSMaster.FHMSMaster.TableS_N_ROWS_Fill(String
> tableS, Int64 nRows, Int64 iSkip, String strOrderBy) in
> D:\\HMS\\AppHMS\\SolnHMS\\HMSMaster\\FHMSMaster.cs:line 1294"
> string
>
> +                            TargetSite
> {FirebirdSql.Data.Common.DbValue[]
> Fetch()}               System.Reflection.MethodBase
> {System.Reflection.RuntimeMethodInfo}
>
> +                            Static members
>
> +                            Non-Public members
>
>
Additional inputs:

I observed that while copying 13,26,000 records from source in batches of
50,000 each, exception was raised after copying 12,50,000.
So from the source I deleted the already copied 12,50,000 records and
resumed to copy the remaining 76,000.
This also failed.
Attempted versions: 6 Alpha 2, 5.12.0.0, 5.11.0.0 and 4.5.2.0.
However, I could manually insert the 76,000 records using flamerobin.

Now to copy this particular table of the database I am using
FbCommand's ExecuteNonQuery to run a stored procedure which copies record
using Execute Statement On External database.
This works fine and faster.

For the time being, I appear to have manoeuvred out of dead end.


>
> > --
> > Mgr. Ji?? ?in?ura
> > https://www.tabsoverspaces.com/
> >
> >
> >
> >
> > ------------------------------
> >
> > ------------------------------------------------------------
> > ------------------
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> >
> > ------------------------------
> >
> > Subject: Digest Footer
> >
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> >
> > ------------------------------
> >
> > End of Firebird-net-provider Digest, Vol 139, Issue 6
> > *****************************************************
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------
>
> End of Firebird-net-provider Digest, Vol 139, Issue 7
> *****************************************************
>

[Firebird-net-provider] [FB-Tracker] Created: (DNET-796) Mapping numeric types in the same configurable way you can do in Oracle

[Roberto C. da S. (JIRA) <tr...@fi...>]

Mapping numeric types in the same configurable way you can do in Oracle
-----------------------------------------------------------------------

                 Key: DNET-796
                 URL: http://tracker.firebirdsql.org/browse/DNET-796
             Project: .NET Data provider
          Issue Type: New Feature
    Affects Versions: 5.vNext, 6.0.0.0
         Environment: ADO.NET framework, entity Framework
            Reporter: Roberto Carlos da Silva
            Assignee: Jiri Cincura


It would be great if in the Firebird .NET Drive there was a way to map the same numeric types you can do in the Oracle Driver.
It would solve various system and framework migration incompatibility issues and make it easier to choose firebird as a database for the .NET platform. I think it would be very easy to do that.

https://docs.oracle.com/database/121/ODPNT/entityDataTypeMapping.htm#ODPNT8300

-- 
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] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 6

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

On Sat, Nov 18, 2017 at 5:46 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. Re: Error reading data from the connection Re:
>       Firebird-net-provider Digest, Vol 139, Issue 3 (Ji?? ?in?ura)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 18 Nov 2017 09:07:35 +0100
> From: Ji?? ?in?ura <ji...@ci...>
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] Error reading data from the
>         connection Re: Firebird-net-provider Digest, Vol 139, Issue 3
> Message-ID:
>         <1510992455.1577004.1176679856.4C4DB47A@webmail.
> messagingengine.com>
> Content-Type: text/plain; charset="utf-8"
>
> I would check inner exception to see what happened.
>
>
Thanks for responding, Jiri.
The details of exception are as under please. Let me know if more details
are required.


-                             ex           {"Error reading data from the
connection."}               FirebirdSql.Data.FirebirdClient.FbException

+                            Data
{System.Collections.ListDictionaryInternal}
System.Collections.IDictionary
{System.Collections.ListDictionaryInternal}

                              ErrorCode           335544726          int

+                            Errors
{FirebirdSql.Data.FirebirdClient.FbErrorCollection}
FirebirdSql.Data.FirebirdClient.FbErrorCollection

                              HResult -2147467259      int

                              HelpLink               null         string

-                             InnerException   {"Error reading data from
the connection."}               System.Exception
{FirebirdSql.Data.Common.IscException}

+                            Data
{System.Collections.ListDictionaryInternal}
System.Collections.IDictionary
{System.Collections.ListDictionaryInternal}

                              ErrorCode           335544726          int

+                            Errors    Count = 2
System.Collections.Generic.List<FirebirdSql.Data.Common.IscError>

                              HResult -2146233088      int

                              HelpLink               null         string

-                             InnerException   {"I/O error occurred."}
   System.Exception
{System.IO.IOException}

+                            Data
{System.Collections.ListDictionaryInternal}
System.Collections.IDictionary
{System.Collections.ListDictionaryInternal}

                              HResult -2146232800      int

                              HelpLink               null         string

-                             InnerException   null         System.Exception

+                            Static members

                              Message              "I/O error occurred."
string

                              Source
"FirebirdSql.Data.FirebirdClient"
string

                              StackTrace          "   at
FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(Int32 count)\r\n   at
FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()\r\n   at
FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.NextOperation()\r\n   at
FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()"
string

+                            TargetSite           {Byte[]
ReadBytes(Int32)}
System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo}

+                            Static members

+                            Non-Public members

                              IsWarning            false      bool

                              Message              "Error reading data from
the connection."            string

                              SQLSTATE            "08006"
string

                              Source
"FirebirdSql.Data.FirebirdClient"
string

                              StackTrace          "   at
FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()\r\n   at
FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()"         string

+                            TargetSite
{FirebirdSql.Data.Common.DbValue[]
Fetch()}               System.Reflection.MethodBase
{System.Reflection.RuntimeMethodInfo}

+                            Static members

+                            Non-Public members

                              Message              "Error reading data from
the connection."            string

                              SQLSTATE            "08006"
string

                              Source
"FirebirdSql.Data.FirebirdClient"
string

                              StackTrace          "   at
FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()\r\n   at
FirebirdSql.Data.FirebirdClient.FbDataReader.Read()\r\n   at
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)\r\n   at
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue)\r\n   at System.Data.Common.DataAdapter.Fill(DataSet
dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32
maxRecords)\r\n   at System.Data.Common.DbDataAdapter.FillInternal(DataSet
dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords,
String srcTable, IDbCommand command, CommandBehavior behavior)\r\n   at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)\r\n   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet,
String srcTable)\r\n   at HMSMaster.FHMSMaster.TableS_N_ROWS_Fill(String
tableS, Int64 nRows, Int64 iSkip, String strOrderBy) in
D:\\HMS\\AppHMS\\SolnHMS\\HMSMaster\\FHMSMaster.cs:line 1294"
string

+                            TargetSite
{FirebirdSql.Data.Common.DbValue[]
Fetch()}               System.Reflection.MethodBase
{System.Reflection.RuntimeMethodInfo}

+                            Static members

+                            Non-Public members


> --
> Mgr. Ji?? ?in?ura
> https://www.tabsoverspaces.com/
>
>
>
>
> ------------------------------
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------
>
> End of Firebird-net-provider Digest, Vol 139, Issue 6
> *****************************************************
>

Re: [Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 3

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

I would check inner exception to see what happened.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

Re: [Firebird-net-provider] Firebird-net-provider Digest, Vol 139, Issue 4

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

On Sat, Nov 18, 2017 at 6:25 AM, <
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. Error reading data from the connection Re:
>       Firebird-net-provider Digest, Vol 139, Issue 3 (LtColRDSChauhan)
>    2. Re: Error reading data from the connection Re:
>       Firebird-net-provider Digest, Vol 139, Issue 3 (LtColRDSChauhan)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 17 Nov 2017 19:19:07 +0530
> From: LtColRDSChauhan <rds...@gm...>
> To: fir...@li...
> Subject: [Firebird-net-provider] Error reading data from the
>         connection Re: Firebird-net-provider Digest, Vol 139, Issue 3
> Message-ID:
>         <CAM...@ma...ail.
> com>
> Content-Type: text/plain; charset="utf-8"
>
> On Fri, Nov 17, 2017 at 5:38 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. Error reading data from the connection (LtColRDSChauhan)
> >    2. Re: Error reading data from the connection (Gerdus van Zyl)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Thu, 16 Nov 2017 20:03:05 +0530
> > From: LtColRDSChauhan <rds...@gm...>
> > To: fir...@li...
> > Subject: [Firebird-net-provider] Error reading data from the
> >         connection
> > Message-ID:
> >         <CAMG8wxjv-2MEg9j4cxO4bAjXpDGB6-nLVBQiVdSwVr63RqCT8g@mail.
> > gmail.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > Hello,
> >
> > 1. I need to frequently copy a table from one database to another. This
> has
> > started to fail now, apparently due to increase in number of records.
> > Attempting to copy about 13,26,000 records fails reporting ?Error reading
> > data from the connection?. Number of records that I can still successful
> > copy is about 13,24,510.
> >
> > 3. I copy the in batches of 50,000 records (variable) each. For each
> batch,
> > i open and close connection. I have tried setting connection pooling true
> > and false both. Also varied the batch size to 5000, 100000 etc.
> >
> > 2. My database and client are on the same machine. Other details:
> >
> > RAM 16 GB
> >
> > Client application 64 Bit
> >
> > OS Windows 10 64 Bit
> >
> > Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0
> >
> > Firebird 3.0.2.32703_0_Win64
> >
> > 3. Please suggest possible solutions.
> >
> > Regards,
> >
> > Rajiv
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> >
> > ------------------------------
> >
> > Message: 2
> > Date: Thu, 16 Nov 2017 16:51:38 +0200
> > From: Gerdus van Zyl <ger...@gm...>
> > To: "For users and developers of the Firebird .NET providers"
> >         <fir...@li...>
> > Subject: Re: [Firebird-net-provider] Error reading data from the
> >         connection
> > Message-ID:
> >         <CALvycTnBNwJVQVsgV3tgEkdP-MOwRGCcUJX6G7sF1dqLYmXH3g@
> > mail.gmail.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > You can just catch the exception, rollback the batch transaction if
> > possible, reconnect and retry that batch again.
> > Having retry logic is the only way to ensure reliability.
> >
>
> I am using try-catch and roll back.
> Also retrying again and again after roll back for last 48hrs.
> The result is consistently the same ie copying about 13,26,000 records
> fails reporting Error reading data from the connection,
> while copying  about 13,24,510 record always succeeds.
> The issue here is more then just ensuring reliability.
> May be I am missing out settings.
> Please suggest possible solutions.
>
>
>
> > On 16 November 2017 at 16:33, LtColRDSChauhan <rds...@gm...>
> wrote:
> >
> > > Hello,
> > >
> > > 1. I need to frequently copy a table from one database to another. This
> > > has started to fail now, apparently due to increase in number of
> records.
> > > Attempting to copy about 13,26,000 records fails reporting ?Error
> reading
> > > data from the connection?. Number of records that I can still
> successful
> > > copy is about 13,24,510.
> > >
> > > 3. I copy the in batches of 50,000 records (variable) each. For each
> > > batch, i open and close connection. I have tried setting connection
> > pooling
> > > true and false both. Also varied the batch size to 5000, 100000 etc.
> > >
> > > 2. My database and client are on the same machine. Other details:
> > >
> > > RAM 16 GB
> > >
> > > Client application 64 Bit
> > >
> > > OS Windows 10 64 Bit
> > >
> > > Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0
> > >
> > > Firebird 3.0.2.32703_0_Win64
> > >
> > > 3. Please suggest possible solutions.
> > >
> > > 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
> > > Fir...@li...
> > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> > >
> > >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> >
> > ------------------------------
> >
> > ------------------------------------------------------------
> > ------------------
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> >
> > ------------------------------
> >
> > Subject: Digest Footer
> >
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> >
> > ------------------------------
> >
> > End of Firebird-net-provider Digest, Vol 139, Issue 3
> > *****************************************************
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 2
> Date: Sat, 18 Nov 2017 06:25:47 +0530
> From: LtColRDSChauhan <rds...@gm...>
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] Error reading data from the
>         connection Re: Firebird-net-provider Digest, Vol 139, Issue 3
> Message-ID:
>         <CAMG8wxjSMZiWbsWcVxAxdAeqryPNn7R4w+a8JZRpAKx7QsOQ4w@mail.
> gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On Fri, Nov 17, 2017 at 7:19 PM, LtColRDSChauhan <rds...@gm...>
> wrote:
>
> >
> >
> > On Fri, Nov 17, 2017 at 5:38 PM, <firebird-net-provider-
> > re...@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-pr
> >> ovider
> >> 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. Error reading data from the connection (LtColRDSChauhan)
> >>    2. Re: Error reading data from the connection (Gerdus van Zyl)
> >>
> >>
> >> ----------------------------------------------------------------------
> >>
> >> Message: 1
> >> Date: Thu, 16 Nov 2017 20:03:05 +0530
> >> From: LtColRDSChauhan <rds...@gm...>
> >> To: fir...@li...
> >> Subject: [Firebird-net-provider] Error reading data from the
> >>         connection
> >> Message-ID:
> >>         <CAM...@ma...
> >> ail.com>
> >> Content-Type: text/plain; charset="utf-8"
> >>
> >> Hello,
> >>
> >> 1. I need to frequently copy a table from one database to another. This
> >> has
> >> started to fail now, apparently due to increase in number of records.
> >> Attempting to copy about 13,26,000 records fails reporting ?Error
> reading
> >> data from the connection?. Number of records that I can still successful
> >> copy is about 13,24,510.
> >>
> >> 3. I copy the in batches of 50,000 records (variable) each. For each
> >> batch,
> >> i open and close connection. I have tried setting connection pooling
> true
> >> and false both. Also varied the batch size to 5000, 100000 etc.
> >>
> >> 2. My database and client are on the same machine. Other details:
> >>
> >> RAM 16 GB
> >>
> >> Client application 64 Bit
> >>
> >> OS Windows 10 64 Bit
> >>
> >> Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0
> >>
> >> Firebird 3.0.2.32703_0_Win64
> >>
> >> 3. Please suggest possible solutions.
> >>
> >> Regards,
> >>
> >> Rajiv
> >> -------------- next part --------------
> >> An HTML attachment was scrubbed...
> >>
> >> ------------------------------
> >>
> >> Message: 2
> >> Date: Thu, 16 Nov 2017 16:51:38 +0200
> >> From: Gerdus van Zyl <ger...@gm...>
> >> To: "For users and developers of the Firebird .NET providers"
> >>         <fir...@li...>
> >> Subject: Re: [Firebird-net-provider] Error reading data from the
> >>         connection
> >> Message-ID:
> >>         <CALvycTnBNwJVQVsgV3tgEkdP-MOwRGCcUJX6G7sF1dqLYmXH3g@mail.
> >> gmail.com>
> >> Content-Type: text/plain; charset="utf-8"
> >>
> >> You can just catch the exception, rollback the batch transaction if
> >> possible, reconnect and retry that batch again.
> >> Having retry logic is the only way to ensure reliability.
> >>
> >
> > I am using try-catch and roll back.
> > Also retrying again and again after roll back for last 48hrs.
> > The result is consistently the same ie copying about 13,26,000 records
> > fails reporting Error reading data from the connection,
> > while copying  about 13,24,510 record always succeeds.
> > The issue here is more then just ensuring reliability.
> >
> I could pin point the issue in my case.
>
> With the select command text for FbDataAdapter set as:
>
> SELECT first 50000 SKIP 1260000 * FROM PATIENT_BILL order by REGDID, SER
>
> Calling Fill raises the exception Error reading data from the connection
> immediately on a freshly created single connection with no pooling.
>
> Am I missing some setting for FbDataAdapter?
>

1. I have tried all combinations of connection string settings for:

Connection Timeout, Connection lifetime, Pooling

2. For the DataSet tried FbDataAdapter and FbDataReader both.

3. Still the above issue surfaces consistently.

4. The issue appears to be: By time the records are fetched, connection is
broken / closed.

5. Any possible solutions on this?


>
>
> > May be I am missing out settings.
> > Please suggest possible solutions.
> >
> >
> >
> >> On 16 November 2017 at 16:33, LtColRDSChauhan <rds...@gm...>
> wrote:
> >>
> >> > Hello,
> >> >
> >> > 1. I need to frequently copy a table from one database to another.
> This
> >> > has started to fail now, apparently due to increase in number of
> >> records.
> >> > Attempting to copy about 13,26,000 records fails reporting ?Error
> >> reading
> >> > data from the connection?. Number of records that I can still
> successful
> >> > copy is about 13,24,510.
> >> >
> >> > 3. I copy the in batches of 50,000 records (variable) each. For each
> >> > batch, i open and close connection. I have tried setting connection
> >> pooling
> >> > true and false both. Also varied the batch size to 5000, 100000 etc.
> >> >
> >> > 2. My database and client are on the same machine. Other details:
> >> >
> >> > RAM 16 GB
> >> >
> >> > Client application 64 Bit
> >> >
> >> > OS Windows 10 64 Bit
> >> >
> >> > Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0
> >> >
> >> > Firebird 3.0.2.32703_0_Win64
> >> >
> >> > 3. Please suggest possible solutions.
> >> >
> >> > 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
> >> > Fir...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >> >
> >> >
> >> -------------- next part --------------
> >> An HTML attachment was scrubbed...
> >>
> >> ------------------------------
> >>
> >> ------------------------------------------------------------
> >> ------------------
> >> Check out the vibrant tech community on one of the world's most
> >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> >>
> >> ------------------------------
> >>
> >> Subject: Digest Footer
> >>
> >> _______________________________________________
> >> Firebird-net-provider mailing list
> >> Fir...@li...
> >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >>
> >>
> >> ------------------------------
> >>
> >> End of Firebird-net-provider Digest, Vol 139, Issue 3
> >> *****************************************************
> >>
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------
>
> End of Firebird-net-provider Digest, Vol 139, Issue 4
> *****************************************************
>

Re: [Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 3

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

On Fri, Nov 17, 2017 at 7:19 PM, LtColRDSChauhan <rds...@gm...> wrote:

>
>
> On Fri, Nov 17, 2017 at 5:38 PM, <firebird-net-provider-
> re...@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-pr
>> ovider
>> 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. Error reading data from the connection (LtColRDSChauhan)
>>    2. Re: Error reading data from the connection (Gerdus van Zyl)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Thu, 16 Nov 2017 20:03:05 +0530
>> From: LtColRDSChauhan <rds...@gm...>
>> To: fir...@li...
>> Subject: [Firebird-net-provider] Error reading data from the
>>         connection
>> Message-ID:
>>         <CAM...@ma...
>> ail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> Hello,
>>
>> 1. I need to frequently copy a table from one database to another. This
>> has
>> started to fail now, apparently due to increase in number of records.
>> Attempting to copy about 13,26,000 records fails reporting ?Error reading
>> data from the connection?. Number of records that I can still successful
>> copy is about 13,24,510.
>>
>> 3. I copy the in batches of 50,000 records (variable) each. For each
>> batch,
>> i open and close connection. I have tried setting connection pooling true
>> and false both. Also varied the batch size to 5000, 100000 etc.
>>
>> 2. My database and client are on the same machine. Other details:
>>
>> RAM 16 GB
>>
>> Client application 64 Bit
>>
>> OS Windows 10 64 Bit
>>
>> Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0
>>
>> Firebird 3.0.2.32703_0_Win64
>>
>> 3. Please suggest possible solutions.
>>
>> Regards,
>>
>> Rajiv
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Thu, 16 Nov 2017 16:51:38 +0200
>> From: Gerdus van Zyl <ger...@gm...>
>> To: "For users and developers of the Firebird .NET providers"
>>         <fir...@li...>
>> Subject: Re: [Firebird-net-provider] Error reading data from the
>>         connection
>> Message-ID:
>>         <CALvycTnBNwJVQVsgV3tgEkdP-MOwRGCcUJX6G7sF1dqLYmXH3g@mail.
>> gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> You can just catch the exception, rollback the batch transaction if
>> possible, reconnect and retry that batch again.
>> Having retry logic is the only way to ensure reliability.
>>
>
> I am using try-catch and roll back.
> Also retrying again and again after roll back for last 48hrs.
> The result is consistently the same ie copying about 13,26,000 records
> fails reporting Error reading data from the connection,
> while copying  about 13,24,510 record always succeeds.
> The issue here is more then just ensuring reliability.
>
I could pin point the issue in my case.

With the select command text for FbDataAdapter set as:

SELECT first 50000 SKIP 1260000 * FROM PATIENT_BILL order by REGDID, SER

Calling Fill raises the exception Error reading data from the connection
immediately on a freshly created single connection with no pooling.

Am I missing some setting for FbDataAdapter?


> May be I am missing out settings.
> Please suggest possible solutions.
>
>
>
>> On 16 November 2017 at 16:33, LtColRDSChauhan <rds...@gm...> wrote:
>>
>> > Hello,
>> >
>> > 1. I need to frequently copy a table from one database to another. This
>> > has started to fail now, apparently due to increase in number of
>> records.
>> > Attempting to copy about 13,26,000 records fails reporting ?Error
>> reading
>> > data from the connection?. Number of records that I can still successful
>> > copy is about 13,24,510.
>> >
>> > 3. I copy the in batches of 50,000 records (variable) each. For each
>> > batch, i open and close connection. I have tried setting connection
>> pooling
>> > true and false both. Also varied the batch size to 5000, 100000 etc.
>> >
>> > 2. My database and client are on the same machine. Other details:
>> >
>> > RAM 16 GB
>> >
>> > Client application 64 Bit
>> >
>> > OS Windows 10 64 Bit
>> >
>> > Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0
>> >
>> > Firebird 3.0.2.32703_0_Win64
>> >
>> > 3. Please suggest possible solutions.
>> >
>> > 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
>> > Fir...@li...
>> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>> >
>> >
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>>
>> ------------------------------
>>
>> ------------------------------------------------------------
>> ------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>
>> ------------------------------
>>
>> Subject: Digest Footer
>>
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>>
>> ------------------------------
>>
>> End of Firebird-net-provider Digest, Vol 139, Issue 3
>> *****************************************************
>>
>
>

[Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 3

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

On Fri, Nov 17, 2017 at 5:38 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. Error reading data from the connection (LtColRDSChauhan)
>    2. Re: Error reading data from the connection (Gerdus van Zyl)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 16 Nov 2017 20:03:05 +0530
> From: LtColRDSChauhan <rds...@gm...>
> To: fir...@li...
> Subject: [Firebird-net-provider] Error reading data from the
>         connection
> Message-ID:
>         <CAMG8wxjv-2MEg9j4cxO4bAjXpDGB6-nLVBQiVdSwVr63RqCT8g@mail.
> gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hello,
>
> 1. I need to frequently copy a table from one database to another. This has
> started to fail now, apparently due to increase in number of records.
> Attempting to copy about 13,26,000 records fails reporting ?Error reading
> data from the connection?. Number of records that I can still successful
> copy is about 13,24,510.
>
> 3. I copy the in batches of 50,000 records (variable) each. For each batch,
> i open and close connection. I have tried setting connection pooling true
> and false both. Also varied the batch size to 5000, 100000 etc.
>
> 2. My database and client are on the same machine. Other details:
>
> RAM 16 GB
>
> Client application 64 Bit
>
> OS Windows 10 64 Bit
>
> Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0
>
> Firebird 3.0.2.32703_0_Win64
>
> 3. Please suggest possible solutions.
>
> Regards,
>
> Rajiv
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 2
> Date: Thu, 16 Nov 2017 16:51:38 +0200
> From: Gerdus van Zyl <ger...@gm...>
> To: "For users and developers of the Firebird .NET providers"
>         <fir...@li...>
> Subject: Re: [Firebird-net-provider] Error reading data from the
>         connection
> Message-ID:
>         <CALvycTnBNwJVQVsgV3tgEkdP-MOwRGCcUJX6G7sF1dqLYmXH3g@
> mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> You can just catch the exception, rollback the batch transaction if
> possible, reconnect and retry that batch again.
> Having retry logic is the only way to ensure reliability.
>

I am using try-catch and roll back.
Also retrying again and again after roll back for last 48hrs.
The result is consistently the same ie copying about 13,26,000 records
fails reporting Error reading data from the connection,
while copying  about 13,24,510 record always succeeds.
The issue here is more then just ensuring reliability.
May be I am missing out settings.
Please suggest possible solutions.



> On 16 November 2017 at 16:33, LtColRDSChauhan <rds...@gm...> wrote:
>
> > Hello,
> >
> > 1. I need to frequently copy a table from one database to another. This
> > has started to fail now, apparently due to increase in number of records.
> > Attempting to copy about 13,26,000 records fails reporting ?Error reading
> > data from the connection?. Number of records that I can still successful
> > copy is about 13,24,510.
> >
> > 3. I copy the in batches of 50,000 records (variable) each. For each
> > batch, i open and close connection. I have tried setting connection
> pooling
> > true and false both. Also varied the batch size to 5000, 100000 etc.
> >
> > 2. My database and client are on the same machine. Other details:
> >
> > RAM 16 GB
> >
> > Client application 64 Bit
> >
> > OS Windows 10 64 Bit
> >
> > Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0
> >
> > Firebird 3.0.2.32703_0_Win64
> >
> > 3. Please suggest possible solutions.
> >
> > 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
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------
>
> End of Firebird-net-provider Digest, Vol 139, Issue 3
> *****************************************************
>