oracle.jdbc.driver.T4CConnection@1e1414ed is closed

topcong_1210 2011-08-05 08:25:14
数据库用的是Oracle9I,连接是在tomcat中配置的连接池。希望哪位高手给个解释。或者遇到相同错误的,把你解决的方法告诉我也行。下面是所有的报错信息:
[2011-08-04 04:20:00] [org.quartz.core.JobRunShell:run()] ERROR [Job tran_otherEmpInfo_group.tran_otherEmpInfo threw an unhandled Exception: ]
com.ait.core.exception.GlRuntimeException: transmit Emp Info Job Exception.
at com.ait.interf.dao.other.InterfaceOtherDAO.TransmitEmpInfoJob(InterfaceOtherDAO.java:64)
at com.ait.interf.business.InterfServices.TransmitEmpInfoJob(InterfServices.java:626)
at com.ait.mail.quartz.TransmitEmpInfoJob.execute(TransmitEmpInfoJob.java:15)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/ait/interf/sql/other/oracle_sql.xml.
--- The error occurred while executing query.
--- Check the SELECT HRE.PERSONID, HRE.CHINESENAME, HRE.KOREANNAME, HRE.DEPTID, HRD.DEPTNAME PART, HRE.POST_CODE, HRP.POST_NAME JOBT, HRE.DUTY_CODE, DUTY.CODE_NAME DUTY_NAME, HRE.STATUS_CODE, STAT.CODE_NAME STATUS_NAME, HRPI.OFFICE_PHONE, HRPI.EMAIL FROM HR_EMPLOYEE HRE, HR_DEPARTMENT HRD, HR_PERSONAL_INFO HRPI, HR_POST HRP, SY_CODE DUTY, SY_CODE STAT WHERE HRE.DEPTID = HRD.DEPTID(+) AND HRE.EMPID = HRPI.EMPID AND HRE.POST_CODE = HRP.POST_ID(+) AND HRE.DUTY_CODE = DUTY.CODE_ID(+) AND HRE.STATUS_CODE = STAT.CODE_ID(+) ORDER BY HRE.EMPID .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Connection oracle.jdbc.driver.T4CConnection@1e1414ed is closed.
Caused by: java.sql.SQLException: Connection oracle.jdbc.driver.T4CConnection@1e1414ed is closed.
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78)
at com.ait.sqlmap.core.CommonSQLMapAdapter.executeQueryForMulti(CommonSQLMapAdapter.java:134)
at com.ait.sqlmap.core.CommonSQLMapAdapter.executeQueryForMulti(CommonSQLMapAdapter.java:149)
at com.ait.interf.dao.other.InterfaceOtherDAO.TransmitEmpInfoJob(InterfaceOtherDAO.java:54)
... 4 more
Caused by: java.sql.SQLException: Connection oracle.jdbc.driver.T4CConnection@1e1414ed is closed.
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:354)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:246)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:167)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
... 12 more
...全文
860 4 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
linwaterbin 2012-11-13
  • 打赏
  • 举报
回复
加上这个包ojdbc12.jar
软件钢琴师 2012-11-13
  • 打赏
  • 举报
回复
把它拷贝到程序里 /WEB-INF/lib/
软件钢琴师 2012-11-13
  • 打赏
  • 举报
回复
使用专门支持jdk 6的驱动“ojdbc6.jar”,试一下
Kobayashi 2011-08-05
  • 打赏
  • 举报
回复
防火墙有没有关闭????

17,140

社区成员

发帖
与我相关
我的任务
社区描述
Oracle开发相关技术讨论
社区管理员
  • 开发
  • Lucifer三思而后行
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧