最近写代码遇到的。
问题代码如下:
public Object dottCreateByTablename(Object vo,String tablename) throws Exception {
Session session = SessionUtils.currentSession(getDbFlag());
try {
session.save(tablename, (Object) vo);
session.flush();
} catch (HibernateException ex) {
/**
* 一般来说,Hibernate处理异常时都用HibernateException包装之后抛出,
* 这里尝试解开HibernateException的包装,出示真正的错误原因。
*/
if (ex.getCause() != null) {
throw new Exception(ex.getCause());
} else {
throw ex;
}
}finally{
session.close();
}
return vo;
}
就是这个session关闭了。导致出现的错误。为什么呢?具体我也不知道。具体场景如下:
首先记录入哪张表是不确定的,由传入的表名确定的。因为表结构一致,只是表名不一样,所以VO用了一个,对应的hibernate配置如下:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<class name="com.order.req.ReqVO" table="SP_ORDER_REQ" entity-name="SP_ORDER_REQ">
<id column="ORDERSEQ" length="20" name="id" type="java.lang.Long">
<generator class="sequence">
<param name="sequence">SP_ORDER_REQ_SEQ</param>
</generator>
</id>
<property column="ORIGDOMAIN" length="40" name="origdomain" type="java.lang.String" />
<property column="HOMEDOMAIN" length="40" name="homedomain" type="java.lang.String" />
<property column="BIPCODE" length="40" name="bipcode" type="java.lang.String" />
<property column="TRANSIDO" length="40" name="transido" type="java.lang.String" />
<property column="PROCESSTIME" length="7" name="processtime" type="java.util.Date" />
<property column="OPERID" length="32" name="operid" type="java.lang.String" />
<property column="AREACODE" length="10" name="areacode" type="java.lang.String" />
<property column="ORDERID" length="14" name="orderid" type="java.lang.Long" />
<property column="PRIORITY" length="4" name="priority" type="java.lang.Short" />
<property column="REQTYPE" length="4" name="reqtype" type="java.lang.Short" />
<property column="MSISDN" length="15" name="msisdn" type="java.lang.String" />
<property column="IMSI" length="40" name="imsi" type="java.lang.String" />
<property column="PRODID" length="32" name="prodid" type="java.lang.String" />
<property column="TRANSTIME" length="7" name="transtime" type="java.util.Date" />
<property column="DEALTIME" length="7" name="dealtime" type="java.util.Date" />
<property column="SERVNUM" length="5" name="servnum" type="java.lang.Integer" />
<property column="STATE" length="3" name="state" type="java.lang.Short" />
</class>
<class name="com.order.req.ReqVO" table="SP_ORDER_LOG" entity-name="SP_ORDER_LOG">
<id column="ORDERSEQ" length="20" name="id" type="java.lang.Long">
<generator class="sequence">
<param name="sequence">SP_ORDER_REQ_SEQ</param>
</generator>
</id>
<property column="ORIGDOMAIN" length="40" name="origdomain" type="java.lang.String" />
<property column="HOMEDOMAIN" length="40" name="homedomain" type="java.lang.String" />
<property column="BIPCODE" length="40" name="bipcode" type="java.lang.String" />
<property column="TRANSIDO" length="40" name="transido" type="java.lang.String" />
<property column="PROCESSTIME" length="7" name="processtime" type="java.util.Date" />
<property column="OPERID" length="32" name="operid" type="java.lang.String" />
<property column="AREACODE" length="10" name="areacode" type="java.lang.String" />
<property column="ORDERID" length="14" name="orderid" type="java.lang.Long" />
<property column="PRIORITY" length="4" name="priority" type="java.lang.Short" />
<property column="REQTYPE" length="4" name="reqtype" type="java.lang.Short" />
<property column="MSISDN" length="15" name="msisdn" type="java.lang.String" />
<property column="IMSI" length="40" name="imsi" type="java.lang.String" />
<property column="PRODID" length="32" name="prodid" type="java.lang.String" />
<property column="TRANSTIME" length="7" name="transtime" type="java.util.Date" />
<property column="DEALTIME" length="7" name="dealtime" type="java.util.Date" />
<property column="SERVNUM" length="5" name="servnum" type="java.lang.Integer" />
<property column="STATE" length="3" name="state" type="java.lang.Short" />
</class>
</hibernate-mapping>
然后当多笔记录入库就会有异常出现:
2013-07-11 09:13:52,615 132229 ERROR [org.springframework.transaction.support.TransactionSynchronizationUtils] (http-0.0.0.0-8080-1:) TransactionSynchronization.beforeCompletion threw exception
java.lang.IllegalStateException: No value for key [org.hibernate.impl.SessionFactoryImpl@af9ce7] bound to thread [http-0.0.0.0-8080-1]
at org.springframework.transaction.support.TransactionSynchronizationManager.unbindResource(TransactionSynchronizationManager.java:202)
at org.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCompletion(SpringSessionSynchronization.java:179)
at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCompletion(TransactionSynchronizationUtils.java:84)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCompletion(AbstractPlatformTransactionManager.java:918)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:716)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)