Error in BLOBs of text type
---------------------------
Key: DNET-441
URL: http://tracker.firebirdsql.org/browse/DNET-441
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.6
Environment: It works fine with
FB.NET 2.5.2.0 but fails with the new 2.6.0.0
The connection string use an FbServerType.Embedded and the underlying
fbembed.dll
version is 2.1.3.18185.
Reporter: Jiri Cincura
Assignee: Jiri Cincura
//From mailing list.
Here is the code:
DbProviderFactory dbf =
DbProviderFactories.GetFactory("FirebirdSql.Data.FirebirdClient");
DbConnection conn = dbf.CreateConnection();
conn.ConnectionString = connstr;
conn.Open();
DbCommand comm = dbf.CreateCommand();
comm.Connection = conn;
comm.CommandText =
"INSERT INTO WITHBLOB ( ID, LONGTEXT ) VALUES ( 10, @LONGTEXT
)";
DbParameter p = dbf.CreateParameter();
p.ParameterName = "@LONGTEXT";
p.DbType = DbType.String;
p.Value = "Hello";
comm.Parameters.Add(p);
comm.ExecuteNonQuery();
conn.Close();
The table WITHBLOB is defined as:
CREATE TABLE WITHBLOB
(
ID integer,
LONGTEXT blob sub_type 1
);
The error was:
"BLOB and array data types are not supported for move operation"
--
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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
