Hi,
im using hbm2java to generate classes and mappings from an existing Firebird 2.5 database.
After generation I've tried to auto generate tables etc. into an empty database directly via hibernate (Hbm2ddl Auto = update)
That wasn't successfull because i use few fields als "BLOB SUB_TYPE 1" (aka BLOB SUB_TYPE_TEXT) that is for large strings.
the generated mapping sais "string" for thats not correct because the genereated sql results in varchar(0) an that is wrong - the table failed to create.
Looking at the FirebirdDialect class (that extended from InterbaseDialect) the right type for BLOB SUB_TYPE 1 would be CLOB.
so I've changed from
Quote:
<property generated="never" lazy="false" name="description" type="string">
<column length="0" name="DESCRIPTION">
</column>
</property>
to
Quote:
<property generated="never" lazy="false" name="description" type="clob">
<column length="0" name="DESCRIPTION">
</column>
</property>
and it succeeded to create the table.
Is there a speacial reason for that or can i set it in the configuration before generating classes and mappings from db?
Thanks.