iFeng/凤凰网 报错

最新推荐文章于 2022-11-11 10:18:10 发布
最新推荐文章于 2022-11-11 10:18:10 发布
阅读量230 收藏
点赞数
分类专栏： html 文章标签： Java iBATIS CMS Servlet Oracle

今天看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

jnh1983
关注
专栏目录
求解HTTP Status 500 – Internal Server Error
qq_41449899的博客
04-19 2307
HTTP Status 500 – Internal Server Error Type Exception Report Message Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncat...
python爬取凤凰新闻网_python3.6爬取凤凰网新闻-爬虫框架式思维
weixin_28954859的博客
02-04 1135
一、序言先前几篇爬虫的代码，是简单的脚本代码。在爬取小网页觉得挺简单、高效，但涉及复杂网页的时候，就要考虑成熟的爬虫框架与分布式。本篇博客作为无框架式爬虫和有框架式爬虫的一个过渡，介绍具有框架式思维的爬虫^_^。二、框架结构图通常爬虫分为五个部分，分别为：爬虫调度器、URL管理器、网页下载器、网页解析器与数据存储器。各部分的作用如下：爬虫框架模块作用说明模块名称作用爬虫调度器统筹调度其他四个模块之...
Oracle 问题记录
u010738038的专栏
11-11 690
Oracle 常见连接问题记录
mybatis access denied问题
万里晴空
01-25 2299
遇到如下错误： com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/arcsoft/web/adminconsolews/caas/model/OAuthUser.xml. --- The error occurred while executing query. --
ibatis源码学习(三)参数和结果的映射原理
答案是肯定的
11-22 2888
在ibatis整体设计和核心流程一文中，我们提到了ibatis框架中sql的执行过程，sql执行前后有两个重要步骤: 参数对象映射到sql执行参数，sql执行结果映射到结果对象。本文将深入分析ibatis框架中参数和结果的映射原理。 问题  在详细介绍ibatis参数和结果映射原理之前，让我们先来思考几个问题。  1. 为什么需要参数和结果的映射？  相对于全自动的orm，ibat
数据库连接池与com.mysql.jdbc.exceptions.jdbc4.CommunicationsException异常
热门推荐
登高必自卑 行远必自迩
05-04 2万+
数据库连接池与com.mysql.jdbc.exceptions.jdbc4.CommunicationsException异常解决
微信小程序demo：体育新闻；ifeng网API，htmltowxml，bluebird
03-15
3. **ifeng网API**：凤凰网（ifeng.com）提供了一套API服务，允许开发者获取其网站上的新闻数据。在这个项目中，开发者可能使用了这些API来获取体育新闻的数据，包括标题、内容、图片等，然后在微信小程序中展示。 ...
凤凰网相册特效
11-08
"凤凰网相册特效"是针对凤凰网（ifeng.com）相册功能的一套JavaScript特效实现，旨在通过动态效果增强用户在浏览照片时的沉浸感和互动性。 首先，我们要理解"特效"在这个语境中的含义。在网页开发中，特效通常指的...
爬取凤凰网新闻
weixin_40932639的博客
02-17 1675
import requests from bs4 import BeautifulSoup from lxml import etree from requests.exceptions import RequestException import re #设置请求头 url = 'https://news.ifeng.com/c/7u3cafzm3Ki' headers = {'Accept'...
validationQuery didn't return a row
骨哥博客
03-20 5111
弄了一个spring+ibatis的例子，在测试的时候报了下面的错误： Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; err
2017-7-10记录一个故障问题
Daniel的博客
07-10 1010
最近几天邮件客服时不时的报给我一个邮件不能回复的故障,查看了日志情况如下: --- The error occurred while applying a parameter map. --- Check the P_A_KEYWORD_abatorgenerated_selectKeywords-InlineParameterMap. --- Check the statement (
Caused by: java.sql.SQLException: Io 异常: The Network Adapter could not esta(2)
VipWangJian的博客
10-19 1220
本篇是接上篇的(1)而言的。 (1) 在找问题根源的时候，想到没有更改过applicationContext.xml，而且所以就没有向配置文件着手来做一直在坚持Java代码是否有误，在反复确定Java代码无误后，才抱着试一试的态度，取查看了applicationContext.xml，发现有关数据源的链接是发生改变了(其它人在用我的环境做测试，没有告知他改过该文件) 出现问题的配置如下： [...
DB2数据库使用C3P0连接数据库连接失败 Connections could not be acquired from the underlying database!
图图不糊涂的博客
11-13 1086
先放异常信息： org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in com/umpay/op...
python凤凰网爬虫
最新发布
12-20
根据提供的引用内容，我无法找到关于Python凤凰网爬虫的具体信息。但是，我可以为您提供一个一般的Python爬虫的示例代码，您可以根据这个示例代码进行修改以适应凤凰网的爬取需求。 ```python import requests from bs4 import BeautifulSoup # 发送HTTP请求获取网页内容 url = "https://www.ifeng.com/" response = requests.get(url) html_content = response.text # 使用BeautifulSoup解析网页内容 soup = BeautifulSoup(html_content, "html.parser") # 提取需要的数据 # 例如，提取新闻标题 news_titles = soup.find_all("a", class_="newsLink") for title in news_titles: print(title.text) # 提取其他数据... ``` 请注意，这只是一个简单的示例代码，您可能需要根据凤凰网的具体网页结构和需求进行适当的修改。另外，爬取网页时请遵守相关法律法规和网站的使用规定。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值