1、在 applicationContext.xml 文件中增加如下配置:
<!-- 处理Clob大字段 -->
<
bean
id
=
"nativeJdbcExtractor"
class
=
"org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor"
lazy-init
=
"true"
></
bean
>
<
bean
id
=
"lobHandler"
class
=
"org.springframework.jdbc.support.lob.OracleLobHandler"
lazy-init
=
"true"
>
<
property
name
=
"nativeJdbcExtractor"
ref
=
"nativeJdbcExtractor"
/>
</
bean
>
|
2、在
sessionFactory 中增加如下红色字的配置:
<
bean
id
=
"sessionFactory"
class
=
"org.springframework.orm.hibernate3.LocalSessionFactoryBean"
>
<
property
name
=
"dataSource"
ref
=
"dataSource"
/>
<!-- 处理Clob大字段 -->
<property name="lobHandler" ref="lobHandler"/>
<
property
name
=
"mappingResources"
>
<
list
>
<
value
>
com/test/model/Announcement.hbm.xml
</
value
>
</
list
>
</
property
>
<
property
name
=
"hibernateProperties"
>
<
props
>
<
prop
key
=
"hibernate.dialect"
>
$[hibernate.dialect]
</
prop
>
<
prop
key
=
"hibernate.cache.provider_class"
>
org.hibernate.cache.EhCacheProvider
</
prop
>
<
prop
key
=
"hibernate.cache.use_query_cache"
>
true
</
prop
>
<
prop
key
=
"hibernate.show_sql"
>
true
</
prop
>
<
prop
key
=
"hibernate.bytecode.use_reflection_optimizer"
>
true
</
prop
>
<
prop
key
=
"hibernate.hbm2ddl.auto"
>
$[hibernate.hbm2ddl.auto]
</
prop
>
</
props
>
</
property
>
</
bean
>
|
3、Clob字段处理, *.hbm.xml 文件配置如下:
<
property
name
=
"content"
type
=
"org.springframework.orm.hibernate3.support.ClobStringType"
>
<
column
name
=
"CONTENT"
/>
</
property
>
|
4、对应的实体类中相关的字段用String 接受
5、Blob字段处理,*.hbm.xml 文件配置如下:
<
property
name
=
"content"
type
=
"org.springframework.orm.hibernate3.support.BlobByteArrayType"
>
<
column
name
=
"CONTENT"
/>
</
property
>
|
6、对应的实体类中相关的字段用 byte[] 数组接受