Spring+Hibernate环境下CLOB字段值的处理
<bean id="nativeJdbcExtractor" lazy-init="true"><property name="nativeJdbcExtractor"><ref local="nativeJdbcExtractor"/></property></bean><!-- 如果是Oracle 10g，则可以直接用 --><!-- <bean id="oracleLobHandle" lazy-init="true" ref="dataSource" /><property name="hibernateProperties"><props><prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop><prop key="hibernate.show_sql">false</prop><prop key="hibernate.format_sql">true</prop><prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop><prop key="hibernate.cache.use_query_cache">false</prop></props></property><property name="lobHandler" ref="oracleLobHandle" /></bean>

????? 在SessionFactory bean中增加lobHandler属性的使用。

?

实体类的用法：

@Entity@Table(name = "ASY_TEST" )public class TestInfo extends BaseDomain {private String title;private String contents;@Column(name = "TITLE")   public String getTitle() {return title;}public void setTitle(String title) {this.title = title;}@Column(name = "CONTENTS")       @Type(type="org.springframework.orm.hibernate3.support.ClobStringType")   public String getContents() {return contents;}public void setContents(String contents) {this.contents = contents;}}

? 数据库字段类型是CLOB

???? java属性类型是String，需要用org.springframework.orm.hibernate3.support.ClobStringType指定

?

字段值的存储跟一般字段类型一样。