Hi Masters

Blob Text Questions... :roll:

I'm using NHibernate Version 0.99.2.0, Firebird .NET driver version: 1.7.1-RC1 and the code above:

.HBM.XML

<property name="Obs" column="Obs" type="StringClob" not-null="true" />


Code.CS
...
private string _Obs;
public string Obs
{
get{ return _Obs; }
set{ _Obs = value; }
}
...



At the Firebird DDL schema:


OBSGERAIS BLOB SUB_TYPE 1 SEGMENT SIZE 1024






I get the above Exception when I use Save on Inserting (or Updating) data:


{NHibernate.ADOException}
See the next post...






What I need to fix this exception?



Best Regards
Leandro
From Brazil!!

Sorry,

The correct exception is that:

2005-10-03 12:22:21,217 [3160] ERROR NHibernate.Impl.SessionImpl [(null)] &lt;(null)&gt; - could not synchronize database state with session
NHibernate.ADOException: could not update: [App.BO.PessoaFisica#691] ---> FirebirdSql.Data.Firebird.FbException:
No message for error code 335544569 found. (dynamic sql error)
No message for error code 335544436 found. (Sql Cod Error=)
No message for error code 335544378 found. (Feature Is Not Supported)
No message for error code 335544414 found. (BLOB and array data types are not
supported for <string> operation)

at FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery()
at NHibernate.Impl.BatcherImpl.ExecuteNonQuery(IDbCommand cmd)
at NHibernate.Persister.EntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Boolean[] includeProperty, Object oldVersion, Object obj, SqlString sqlUpdateString, ISessionImplementor session)
--- Fim do rastreamento de pilha de exce

I think the problem is in your mapping

you said:



Reading docs from firebird dataprovider, i found:

FbDbType:
Text = Variable length character data. Maximum length is data source

Bingo!!!!!!


I fixed this problem changing the FirebirdSql.Data.Firebird.dll version (for back) to 1.7.0.22450 (or 1.7b3)...!!!! 8)

Other problem with FirebirdSql.Data.Firebird.dll.Net (1.7.1-RC1 ) is an arithmetic exception caused by use of Bidirectional <many-to-one> clauses.


But now, All right!!! Uffffff......... :roll:


Best Regards....
From Brazil