Hibernate集成spring读写oracle clob.docxVIP

Hibernate集成spring读写oracle clob完全版?前言Hibernate操作oracle clob字段是个大难题，网上的很多范例不详。Hibernate与spring集成后操作又有区别，学习者不知从何下手。本文讲解了读写oracle clob大对象的实现，并且带有完整的可运行范例下载。希望对学习者有所帮助。本文的内容如下1.????????? 数据库的脚本2.????????? spring与hibernate的集成配置3.????????? 实体类的配置4.????????? DAO层和BO层的实现5.????????? 测试代码6.????????? 错误代码以及原因??一、???????????? 数据库脚本表建在scott模式下，密码tigercreatetable demo(id number(10) primarykey,content clob)/测试在过程中的content字段是否写入select * from demo;//或者更专业的测试DECLARE clob_var CLOB; amount INTEGER; offset INTEGER; output_var VARCHAR2(300);BEGINSELECT content INTO clob_var FROM demoWHERE id=3; amount := 150; -- 要读取的字符数 offset := 1; -- 起始位置 DBMS_LOB.READ(clob_var,amount,offset,output_var); DBMS_OUTPUT.PUT_LINE(output_var);END;?spring与hibernate的集成配置?xml version=1.0 encoding=UTF-8?beans xmlns=/schema/beansxmlns:xsi=/2001/XMLSchema-instancexsi:schemaLocation=/schema/beans /schema/beans/spring-beans-2.0.xsd!-- 连接池与会话工厂 --bean id=ds class=mons.dbcp.BasicDataSourceproperty name=driverClassNamevalue=oracle.jdbc.driver.OracleDriver/propertyproperty name=urlvalue=jdbc:oracle:thin:@:1521:ZBACCP/propertyproperty name=username value=scott/propertyproperty name=password value=tiger/property/beanbean id=sessionFactoryclass=org.springframework.orm.hibernate3.LocalSessionFactoryBeanproperty name=dataSourceref bean=ds/ref/propertyproperty name=hibernatePropertiespropsprop key=hibernate.dialectorg.hibernate.dialect.Oracle9Dialect/prop!-- 本处设置非常重要 --prop key=hibernate.jdbc.batch_size0/prop/props/propertyproperty name=mappingResourceslistvaluecom/demo/to/DemoTO.hbm.xml/value/list/property/bean!-- BO层必须使用事务管理 --bean id=TransactionManagerclass=org.springframework.orm.hibernate3.HibernateTransactionManagerabstract=false lazy-init=default autowire=defaultdependency-check=defaultproperty name=sessionFactoryref bean=sessionFactory //property/beanbean id=TransactionInterceptorclass=erceptor.TransactionInterceptorabstract=false lazy-init=default autowire=defaultdependency-check=defaultproperty n