Spring + Hibernate + Oracle9i中使用Clob

项目中如题 框架。

oracle9i 对clob 操作 有些问题。 现在改 用的是 两个jar文件可以去 http://download.csdn.net/source/2528945  这里下载 网上别的用户csdn 也有资源。

 

po类：

 

public class KnowledgContent implements Serializable { private String id; private String content; // Constructors /** default constructor */ public KnowledgContent() { } /** minimal constructor */ public KnowledgContent(String id) { this.id = id; } public String getId() { return id; } public void setId(String id) { this.id = id; } public String getContent() { return content; } public void setContent(String content) { this.content = content; } /** full constructor */ public KnowledgContent(String id, String content) { this.id = id; this.content = content; } }

hbm文件

<?xml version="1.0" encoding="utf-8"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN""http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><!-- Mapping file autogenerated by MyEclipse Persistence Tools--><hibernate-mapping> <class name="com.m.m.po.zyzl.KnowledgContent" table="T_KNOWLEDGE_CONTENT" schema="CDCRIP"> <id name="id" type="java.lang.String"> <column name="ID" length="32" /> <generator class="assigned" /> </id> <property name="content" type="java.lang.String"> <column name="CONTENT" /> </property> </class></hibernate-mapping>

serviceImple   添加内容的操作没什么格式转换的地方 dao直接session.save(kc)。便可。不上代码了。

public String saveKnowledges(KnowledgeForm kf) { KnowledgContent kc = new KnowledgContent(); kc.setContent(kf.getContent()); return knowledgeDao.saveKnowledges(ka, kc); }

applicationContext.xml 中 的配置如下 里边有两个注意的地方。

<!--配置数据库会话工厂--> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource"> <ref bean="cdcrip" /> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.cglib.use_reflection_optimizer">true</prop> <prop key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop> </props> </property> <!--注意这块 --> <property name="lobHandler" ref="lobHandler"/> <property name="mappingDirectoryLocations"> <list> <value>classpath*:/com/m/up/hbm</value> </list> </property> </bean> <!--注意这块 --> <bean id="lobHandler" lazy-init="true" class="org.springframework.jdbc.support.lob.DefaultLobHandler"/>

 

好了 。问题解决 有问题的 给我留言。