1.建表
create table tablename (
id number(10),
content clob
) CONSTRAINT "PK_ID" PRIMARY KEY ("id");
2.spring xml文件配置
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="hibernateProperties">
<props>
<prop key="hibernate.connection.SetBigStringTryClob">true</prop>
</props>
</property>
<property name="lobHandler" ref="oracleLobHandler" />
</bean>
<bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler"
lazy-init="true">
<property name="nativeJdbcExtractor">
<ref local="nativeJdbcExtractor" />
</property>
</bean>
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.WebLogicNativeJdbcExtractor"
lazy-init="true" />
3.TableTest.hbm.xml文件
<class name="MyTableTest" table="T_Table_Test">
<id name="id" type="java.lang.Long">
<column name="ID" />
<generator class="sequence">
<param name="sequence">SEQ_Table_Test</param>
</generator>
</id>
<property name="content" type="org.springframework.orm.hibernate3.support.ClobStringType">
<column name="CONTENT">
<comment>内容</comment>
</column>
</property>
</class>
4.TableTest.java文件
public class TableTest {
private Long id;
private String content;
// getter setter
}
create table tablename (
id number(10),
content clob
) CONSTRAINT "PK_ID" PRIMARY KEY ("id");
2.spring xml文件配置
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="hibernateProperties">
<props>
<prop key="hibernate.connection.SetBigStringTryClob">true</prop>
</props>
</property>
<property name="lobHandler" ref="oracleLobHandler" />
</bean>
<bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler"
lazy-init="true">
<property name="nativeJdbcExtractor">
<ref local="nativeJdbcExtractor" />
</property>
</bean>
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.WebLogicNativeJdbcExtractor"
lazy-init="true" />
3.TableTest.hbm.xml文件
<class name="MyTableTest" table="T_Table_Test">
<id name="id" type="java.lang.Long">
<column name="ID" />
<generator class="sequence">
<param name="sequence">SEQ_Table_Test</param>
</generator>
</id>
<property name="content" type="org.springframework.orm.hibernate3.support.ClobStringType">
<column name="CONTENT">
<comment>内容</comment>
</column>
</property>
</class>
4.TableTest.java文件
public class TableTest {
private Long id;
private String content;
// getter setter
}