Spring和Hibernate整合实现Oracle的大数据类型Clob的操作

来源：互联网发布：php安装教程 windows 编辑：程序博客网时间：2024/05/21 07:09

Spring配置：

添加：

<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor" />     <bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler" >     <property name="nativeJdbcExtractor">          <ref bean="nativeJdbcExtractor" />     </property> </bean> <bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true" />

<!-- 封装SessionFactory --><bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="lobHandler" ref="lobHandler"/><property name="dataSource" ref="dataSource" /><property name="mappingResources"><list><value>com/xxx/abc.hbm.xml</value></list></property><!-- Hibernates配置 --><property name="hibernateProperties"><props><prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect </prop><prop key="hibernate.show_sql">true</prop><prop key="hibernate.jdbc.batch_size">0</prop>    </props></property></bean>

实体对象

public class NovaAbout implements java.io.Serializable{private long id;private String aboutName;private String aboutKeyword;private String aboutDiscription;private Date aboutData;private Long aboutType;private String aboutImg;private String aboutContent;}

aboutContent：还是用String

实体对象hibernate的映射文件XML

 <property name="aboutContent" type="org.springframework.orm.hibernate3.support.ClobStringType">    <column name="ABOUT_CONTENT" /> </property>