急啊，在线,高手指点 java.sql.SQLException: Already closed

[ivwidtlt]

2009-11-11 18:09:27 - cn.yicha.marketing.charge.exception.AbsCustomException -441873 [TP-Processor4] ERROR cn.yicha.marketing.charge.exception.AbsCustomException -----------异常记录 2009-11-11 18:09:27-----------
友好提示信息： Failed to insert Url:http://statcharge.yicha.cn/marketingcharge/zlzx02a
异常业务信息： Error ending SQL Map transaction. Cause: java.sql.SQLException: Already closed.
异常触发时间： 2009-11-11 18:09:27
异 常 类 型： CustomException 通用自定义异常类型
异常LocalizedMessage： Error ending SQL Map transaction. Cause: java.sql.SQLException: Already closed.
异常getMessage： Error ending SQL Map transaction. Cause: java.sql.SQLException: Already closed.
异常Track：
at com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransaction.rollback(SqlMapDaoTransaction.java:51)
at com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransactionManager.rollbackTransaction(SqlMapDaoTransactionManager.java:85)
at com.ibatis.dao.engine.impl.DaoContext.endTransaction(DaoContext.java:112)
at com.ibatis.dao.engine.impl.StandardDaoManager.endTransaction(StandardDaoManager.java:98)
at cn.yicha.marketing.charge.impl.ChargeLogImpl.insertChargeLog(ChargeLogImpl.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
at $Proxy0.insertChargeLog(Unknown Source)
at cn.yicha.marketing.charge.services.ChargeLogService.insertChargeLog(ChargeLogService.java:32)
at cn.yicha.marketing.charge.business.abstracts.AChargeLog.saveData(AChargeLog.java:111)
at cn.yicha.marketing.charge.business.ChargeLogDataFormat.saveData(ChargeLogDataFormat.java:140)
at cn.yicha.marketing.charge.servlet.DataFormater.doGet(DataFormater.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

环境信息：java版本 1.5.0_08 java供应商 BEA Systems, Inc. java虚拟机版本 R27.1.0-109-73164-1.5.0_08-20061129-1415-linux-x86_64 java虚拟机供应商 BEA Systems, Inc.

[ivwidtlt]

[Quote=引用 3 楼 warison2008 的回复:]
确认下
DAOConfigure.getDaoManager().startTransaction();
//执行sql
DAOConfigure.getDaoManager().commitTransaction();
//finally
DAOConfigure.getDaoManager().endTransaction();
是否正确
[/Quote]

加了也报

[ivwidtlt]

版本:ibatis-2.3.2.715.jar

[ouyangxiaokang6]

[Quote=引用 2 楼 ivwidtlt 的回复:]
是ibatis出了问题，还是数据库的问题，数据库mysql
现在无法准确定位
[/Quote]
都不是，是你写的代码有问题，应该是你的数据库连接关闭之后，你还有用这个实例操作数据库的地方。
仔细检查一下你的代码。

[closewbq]

在以回滚之前，你的connection已经关闭了！

[ivwidtlt]

是ibatis出了问题，还是数据库的问题，数据库mysql
现在无法准确定位

[道光2008]

确认下
DAOConfigure.getDaoManager().startTransaction();
//执行sql
DAOConfigure.getDaoManager().commitTransaction();
//finally
DAOConfigure.getDaoManager().endTransaction();
是否正确

[骑单车看夕阳]

就是没有取到数据库连接.