oracle.jdbc.driver.T4CConnection@1e1414ed is closed
数据库用的是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