Hello everyone,

thanks for this beautifull project.

Since Jaybird 6.0.1, and deferred blob open evol, inserting multiples lines in batch (FBStatement.executeBatch), causes an error when we set
an empty string ("") in a blob field :
"Dynamic SQL Error; SQL error code = -104; Repeated blob id 0:0 in registerBlob() [SQLState:22000, ISC error code:335545190]"

Table structure :
CREATE TABLE SYS_HORODATAGE ( ID_SYS_HORO bigint NOT NULL, CODE_RESS_SYS_HORO varchar(200) NOT NULL COLLATE UNICODE_CI_AI, ID_RESS_SYS_HORO bigint NOT NULL, REF_UTILISATEUR bigint NOT NULL, DT_MODIF_SYS_HORO timestamp, TYPE_MODIF_SYS_HORO varchar(1) COLLATE UNICODE_CI_AI, CODE_RESS_PARENT_SYS_HORO varchar(200) COLLATE UNICODE_CI_AI, ID_RESS_PARENT_SYS_HORO bigint, REF_ENTITE bigint NOT NULL, USERDIVERS_SYS_HORO varchar(200), MODIFICATION_SYS_HORO blob sub_type 1, CONSTRAINT PK_SYS_HORODATAGE PRIMARY KEY (ID_SYS_HORO) ); CREATE INDEX IDX_SYS_HORODATAGE_CODE_PARENT ON SYS_HORODATAGE (CODE_RESS_PARENT_SYS_HORO); CREATE INDEX IDX_SYS_HORODATAGE_CODE_RESS ON SYS_HORODATAGE (CODE_RESS_SYS_HORO); CREATE INDEX IDX_SYS_HORODATAGE_ID_PARENT ON SYS_HORODATAGE (ID_RESS_PARENT_SYS_HORO); CREATE INDEX IDX_SYS_HORODATAGE_ID_RESS ON SYS_HORODATAGE (ID_RESS_SYS_HORO);

The problem appairs when we are inserting multiple lines with "" in MODIFICATION_SYS_HORO field using executeBatch method on FBStatement (so one transaction).

In v6.0.0, it works well.

Thanks for all,