hibernate动态映射表处理oracle的clob类型

package com.hokoexp.BSOL.OLQ; import java.util.List; import java.util.Map; import org.apache.log4j.Logger; import org.apache.log4j.PropertyConfigurator; import org.hibernate.HibernateException; import org.hibernate.Session; import org.hibernate.Transaction; import org.springframework.context.support.FileSystemXmlApplicationContext; import com.hokoexp.BSOL.OLQ.Source.NamingStrategy; import com.hokoexp.BSOL.OLQ.Source.SourceClob; import com.hokoexp.BSOL.OLQ.Source.SourceClobDAO; import com.hokoexp.BSOL.OLQ.Target.TargetClob; import com.hokoexp.BSOL.OLQ.Target.TargetClobDAO; /** * import clobs of source table into clobs of target table * @author wenbin * */ public class OLQMain { public static void main(String[] args) { System.out.println("import starting..."); run(); System.out.println("import ended,congratulation^_^"); } private static void run() { //initialize String[] locations = {"applicationContext.xml", "applicationContext_1.xml"}; FileSystemXmlApplicationContext appContext = new FileSystemXmlApplicationContext( locations); ConstantUtils constants = (ConstantUtils)appContext.getBean("constantUtils"); Map<String, String> constantmap = constants.getConstants(); PropertyConfigurator.configure(constantmap.get("log4j").toString()); Logger logger = Logger.getLogger(OLQMain.class); //starting... logger.warn("import starting..."); //read clobs from source SourceClobDAO sourceDAO = (SourceClobDAO)appContext.getBean("sourceDAO"); NamingStrategy sourceStrategy = (NamingStrategy)appContext.getBean("namingStrategySource"); List list = sourceDAO.query(sourceStrategy.getTablename()); int lines = list.size(); if (lines <= 0) { logger.warn(" no lines imported!"); return; } //save clobs into target TargetClobDAO tagetDAO = (TargetClobDAO)appContext.getBean("tagetDAO"); Session session = tagetDAO.getSessionFactory().openSession(); Transaction transaction = session.beginTransaction(); for (int index = 0; index < lines; index++) { SourceClob sourceclob = (SourceClob)list.get(index); TargetClob clob = new TargetClob(); clob.setNAME_CN(sourceclob.getNAME_CN()); clob.setPATH(sourceclob.getPATH()); clob.setYMDHMS(sourceclob.getYMDHMS()); clob.setCONTENT(sourceclob.getCONTENT()); session.save(clob); } //commit try { transaction.commit(); logger.warn(Integer.toString(lines) + " lines import success!"); } catch (HibernateException e) { logger.error(e.toString()); transaction.rollback(); } finally { session.close(); } //ended list = null; logger.warn("import ended,congratulation!"); } }