iFeng/凤凰网 报错

今天看ifeng遇着个错，可以帮助我们多了解它：

Java/Spring/Tomcat 6.0/Oracle

 

http://ifeng.itcpn.net/more/51193/cms_a_flwlist-1/1/

 

-----------------------------------------------------------------------------------------

HTTP Status 500 -

---

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: SqlMapClient operation; SQL [];   
--- The error occurred in com/yesky/cpn/cms/publisher/dao/publish.xml.  
--- The error occurred while executing query.  
--- Check the          select rfid, code, name, nvl(display_name,name) displayName, nvl(num,0) num, type, app_type appType, cooperate_Flag cooperateFlag, css_xsl_code cssXslCode, publish_type publishType, digest_length digestLength             from cpn_block where rfid=? and code=?     .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/yesky/cpn/cms/publisher/dao/publish.xml.  
--- The error occurred while executing query.  
--- Check the          select rfid, code, name, nvl(display_name,name) displayName, nvl(num,0) num, type, app_type appType, cooperate_Flag cooperateFlag, css_xsl_code cssXslCode, publish_type publishType, digest_length digestLength             from cpn_block where rfid=? and code=?     .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:583)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

 

root cause

org.springframework.dao.DataAccessResourceFailureException: SqlMapClient operation; SQL [];   
--- The error occurred in com/yesky/cpn/cms/publisher/dao/publish.xml.  
--- The error occurred while executing query.  
--- Check the          select rfid, code, name, nvl(display_name,name) displayName, nvl(num,0) num, type, app_type appType, cooperate_Flag cooperateFlag, css_xsl_code cssXslCode, publish_type publishType, digest_length digestLength             from cpn_block where rfid=? and code=?     .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/yesky/cpn/cms/publisher/dao/publish.xml.  
--- The error occurred while executing query.  
--- Check the          select rfid, code, name, nvl(display_name,name) displayName, nvl(num,0) num, type, app_type appType, cooperate_Flag cooperateFlag, css_xsl_code cssXslCode, publish_type publishType, digest_length digestLength             from cpn_block where rfid=? and code=?     .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
	org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:284)
	org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
	org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
	com.yesky.cpn.cms.publisher.dao.PublishDaoImpl.getBlock(PublishDaoImpl.java:111)
	com.yesky.cpn.cms.publisher.service.PublishServiceImpl.getBlock(PublishServiceImpl.java:118)
	com.yesky.cpn.cms.publisher.service.ListPagePublishServiceImpl.getListHtml(ListPagePublishServiceImpl.java:123)
	com.yesky.cpn.cms.manager.controller.CpnController.getListHtml(CpnController.java:44)
	sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:413)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:134)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:310)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:297)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

 

root cause

com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/yesky/cpn/cms/publisher/dao/publish.xml.  
--- The error occurred while executing query.  
--- Check the          select rfid, code, name, nvl(display_name,name) displayName, nvl(num,0) num, type, app_type appType, cooperate_Flag cooperateFlag, css_xsl_code cssXslCode, publish_type publishType, digest_length digestLength             from cpn_block where rfid=? and code=?     .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
	com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
	com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:566)
	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:541)
	com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
	org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:273)
	org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
	org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
	com.yesky.cpn.cms.publisher.dao.PublishDaoImpl.getBlock(PublishDaoImpl.java:111)
	com.yesky.cpn.cms.publisher.service.PublishServiceImpl.getBlock(PublishServiceImpl.java:118)
	com.yesky.cpn.cms.publisher.service.ListPagePublishServiceImpl.getListHtml(ListPagePublishServiceImpl.java:123)
	com.yesky.cpn.cms.manager.controller.CpnController.getListHtml(CpnController.java:44)
	sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:413)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:134)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:310)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:297)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

 

root cause

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
	oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
	oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
	oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
	oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
	oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
	oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
	oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
	org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
	org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
	org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
	org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
	org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
	$Proxy11.prepareStatement(Unknown Source)
	sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:53)
	$Proxy12.prepareStatement(Unknown Source)
	com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:494)
	com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176)
	com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
	com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
	com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:566)
	com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:541)
	com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
	org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:273)
	org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
	org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
	com.yesky.cpn.cms.publisher.dao.PublishDaoImpl.getBlock(PublishDaoImpl.java:111)
	com.yesky.cpn.cms.publisher.service.PublishServiceImpl.getBlock(PublishServiceImpl.java:118)
	com.yesky.cpn.cms.publisher.service.ListPagePublishServiceImpl.getListHtml(ListPagePublishServiceImpl.java:123)
	com.yesky.cpn.cms.manager.controller.CpnController.getListHtml(CpnController.java:44)
	sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:413)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:134)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:310)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:297)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

 

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.

---

Apache Tomcat/6.0.16