lazy initilization of large string (ntext) columns

hkazmi · **Posted:** Wed Sep 14, 2005 11:16 am

Hi Folks, I have inherited a database that was originally being used from a vb application.

We are now moving to java/hibernate. The database schema is not bad, but isn't perfect either.

Whats causing me problems is that a lot of tables have ntext columns that can be as large as 100kb. Further there are BLOBS holding binary data and so forth.

Is there a way to tell hibernate to do lazy initilize on property fields, I couldn't find a way to do lazy initialization on property decleration ???

Is there a worksround I could use. I have been looking into mapping documentation but havn't had much success. A nudge in the right direction will be greatly appreciated.

Hibernate version: 2.0

Mapping documents:
<property
name="notes"
type="java.lang.String"
update="true"
insert="true"
access="property"
column="Notes"
length="1073741823"
/>

Name and version of the database: MSSQL 2000

Jason Zhicheng Li · **Joined:** Tue Aug 16, 2005 11:06 pm **Posts:** 46

H3 supports the lazy fetching of properties.

Quote:

Please note that this is mostly a marketing feature, as in practice, optimizing row reads is much more important than optimization of column reads. However, only loading some properties of a class might be
useful in extreme cases, when legacy tables have hundreds of columns and the data model can not be improved.

Hope it is useful.