select SUM(decode(t1.channel_name,'凤凰网热播电影',count,0))HH0 , SUM(decode(t1.channel_name,'凤凰网中国',count,0))HH1 , SUM(decode(t1.channel_name,'车市资讯',count,0))HH2 , SUM(decode(t1.channel_name,'车市首页',count,0))HH3 , SUM(decode(t1.channel_name,'凤凰网服饰',count,0))HH4 , SUM(decode(t1.channel_name,'瑞丽护肤',count,0))HH5 , SUM(decode(t1.channel_name,'瑞丽美体课堂',count,0))HH6 , SUM(decode(t1.channel_name,'车市品牌',count,0))HH7 , SUM(decode(t1.channel_name,'凤凰网外汇',count,0))HH8 , SUM(decode(t1.channel_name,'凤凰网体育专题',count,0))HH9 , SUM(decode(t1.channel_name,'瑞丽化妆品',count,0))HH10 , SUM(decode(t1.channel_name,'其他',count,0))HH11 , SUM(decode(t1.channel_name,'门户体育首页',count,0))HH12 , SUM(decode(t1.channel_name,'门户优惠',count,0))HH13 , SUM(decode(t1.channel_name,'凤凰网培训',count,0))HH14 , SUM(decode(t1.channel_name,'瑞丽运势',count,0))HH15 , SUM(decode(t1.channel_name,'人民网人民日报',count,0))HH16 , SUM(decode(t1.channel_name,'凤凰网海外',count,0))HH17 , SUM(decode(t1.channel_name,'凤凰网视角',count,0))HH18 , SUM(decode(t1.channel_name,'人民网农村',count,0))HH19 , SUM(decode(t1.channel_name,'瑞丽街拍',count,0))HH20 , SUM(decode(t1.channel_name,'凤凰网曝光台',count,0))HH21 , SUM(decode(t1.channel_name,'凤凰网财经专题',count,0))HH22 , SUM(decode(t1.channel_name,'瑞丽彩妆',count,0))HH23 , SUM(decode(t1.channel_name,'凤凰网热播电视剧',count,0))HH24 , SUM(decode(t1.channel_name,'人民网大陆',count,0))HH25 , SUM(decode(t1.channel_name,'凤凰网美食',count,0))HH26 , SUM(decode(t1.channel_name,'凤凰网银行',count,0))HH27 , SUM(decode(t1.channel_name,'凤凰网留学',count,0))HH28 , SUM(decode(t1.channel_name,'凤凰网职场',count,0))HH29 , SUM(decode(t1.channel_name,'瑞丽明星',count,0))HH30 , SUM(decode(t1.channel_name,'瑞丽时装秀',count,0))HH31 , SUM(decode(t1.channel_name,'瑞丽风水',count,0))HH32 , SUM(decode(t1.channel_name,'门户时尚',count,0))HH33 , SUM(decode(t1.channel_name,'门户娱乐',count,0))HH34 , SUM(decode(t1.channel_name,'凤凰网娱乐专题',count,0))HH35 , SUM(decode(t1.channel_name,'人民网国内',count,0))HH36 , SUM(decode(t1.channel_name,'人民网时评',count,0))HH37 , SUM(decode(t1.channel_name,'凤凰网养生',count,0))HH38 , SUM(decode(t1.channel_name,'凤凰网基金',count,0))HH39 , SUM(decode(t1.channel_name,'凤凰网股指',count,0))HH40 , SUM(decode(t1.channel_name,'凤凰网非常道',count,0))HH41 , SUM(decode(t1.channel_name,'人民网人民生命时报',count,0))HH42 , SUM(decode(t1.channel_name,'凤凰网创业版',count,0))HH43 , SUM(decode(t1.channel_name,'凤凰网新股',count,0))HH44 , SUM(decode(t1.channel_name,'凤凰网疾病',count,0))HH45 , SUM(decode(t1.channel_name,'凤凰网新闻',count,0))HH46 , SUM(decode(t1.channel_name,'瑞丽发型',count,0))HH47 , SUM(decode(t1.channel_name,'凤凰网综合',count,0))HH48 , SUM(decode(t1.channel_name,'门户生活',count,0))HH49 , SUM(decode(t1.channel_name,'人民网人民环球时报',count,0))HH50 , SUM(decode(t1.channel_name,'人民网部委',count,0))HH51 , SUM(decode(t1.channel_name,'凤凰网心理',count,0))HH52 , SUM(decode(t1.channel_name,'瑞丽搭配',count,0))HH53 , SUM(decode(t1.channel_name,'人民网社会',count,0))HH54 , SUM(decode(t1.channel_name,'瑞丽单品',count,0))HH55 , SUM(decode(t1.channel_name,'凤凰网滚动',count,0))HH56 , SUM(decode(t1.channel_name,'凤凰网理财',count,0))HH57 , SUM(decode(t1.channel_name,'凤凰网花絮',count,0))HH58 , SUM(decode(t1.channel_name,'瑞丽减肥瘦身',count,0))HH59 , SUM(decode(t1.channel_name,'凤凰网外语',count,0))HH60 , SUM(decode(t1.channel_name,'瑞丽香水',count,0))HH61 , SUM(decode(t1.channel_name,'21cn读书天地',count,0))HH62 , SUM(decode(t1.channel_name,'金融界财经',count,0))HH63 , SUM(decode(t1.channel_name,'人民网强国论坛',count,0))HH64 , SUM(decode(t1.channel_name,'凤凰网NBA',count,0))HH65 , SUM(decode(t1.channel_name,'金融界财经专题',count,0))HH66 , SUM(decode(t1.channel_name,'瑞丽男性',count,0))HH67 , SUM(decode(t1.channel_name,'凤凰网校花',count,0))HH68 , SUM(decode(t1.channel_name,'门户专题',count,0))HH69 , SUM(decode(t1.channel_name,'凤凰网环球',count,0))HH70 , SUM(decode(t1.channel_name,'凤凰网国际',count,0))HH71 , SUM(decode(t1.channel_name,'瑞丽瑞模',count,0))HH72 , SUM(decode(t1.channel_name,'凤凰网港澳',count,0))HH73 , SUM(decode(t1.channel_name,'凤凰网台湾',count,0))HH74 , SUM(decode(t1.channel_name,'人民网新政',count,0))HH75 , SUM(decode(t1.channel_name,'凤凰网奇闻',count,0))HH76 , SUM(decode(t1.channel_name,'凤凰网新闻专题',count,0))HH77 , SUM(decode(t1.channel_name,'凤凰网评论',count,0))HH78 , SUM(decode(t1.channel_name,'门户财经',count,0))HH79 , SUM(decode(t1.channel_name,'门户下载首页',count,0))HH80 , SUM(decode(t1.channel_name,'瑞丽享瘦美食',count,0))HH81 , SUM(decode(t1.channel_name,'瑞丽爱情',count,0))HH82 , SUM(decode(t1.channel_name,'瑞丽时尚',count,0))HH83 FROM TJ_P_F_CHANNEL_DAY T1 where T1.TYPE = ? and T1.ACCESS_TIME >= TO_DATE(?,'yyyy-MM-dd hh24:mi:ss') and T1.ACCESS_TIME <= TO_DATE(?,'yyyy-MM-dd hh24:mi:ss') and t1.location_id = '全国'
19:06:55,857 DEBUG PreparedStatement:27 - {pstm-100823} Parameters: [uv, 2011-09-20 00:00:00, 2011-09-20 23:00:00]
19:06:55,857 DEBUG PreparedStatement:27 - {pstm-100823} Parameters: [uv, 2011-09-20 00:00:00, 2011-09-20 23:00:00]
19:06:55,858 DEBUG PreparedStatement:27 - {pstm-100823} Types: [java.lang.String, java.lang.String, java.lang.String]
19:06:55,858 DEBUG PreparedStatement:27 - {pstm-100823} Types: [java.lang.String, java.lang.String, java.lang.String]
19:06:55,864 DEBUG ResultSet:27 - {rset-100824} ResultSet
[19:06:55.866] org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
[19:06:55.866] --- The error occurred in com/_21cn/generalwap/sqlmap/GENERALWAP_DAY_SqlMap.xml.
[19:06:55.866] --- The error occurred while applying a result map.
[19:06:55.866] --- Check the GENERALWAP_DAY.getColumnCount_pfchannel-AutoResultMap.
[19:06:55.866] --- Check the result mapping for the 'HH84' property.
[19:06:55.866] --- Cause: java.sql.SQLException: Invalid column name
[19:06:55.866] Caused by: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
[19:06:55.866] --- The error occurred in com/_21cn/generalwap/sqlmap/GENERALWAP_DAY_SqlMap.xml.
[19:06:55.866] --- The error occurred while applying a result map.
[19:06:55.866] --- Check the GENERALWAP_DAY.getColumnCount_pfchannel-AutoResultMap.
[19:06:55.866] --- Check the result mapping for the 'HH84' property.
[19:06:55.866] --- Cause: java.sql.SQLException: Invalid column name
[19:06:55.866] Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
[19:06:55.866] --- The error occurred in com/_21cn/generalwap/sqlmap/GENERALWAP_DAY_SqlMap.xml.
[19:06:55.866] --- The error occurred while applying a result map.
[19:06:55.866] --- Check the GENERALWAP_DAY.getColumnCount_pfchannel-AutoResultMap.
[19:06:55.866] --- Check the result mapping for the 'HH84' property.
[19:06:55.866] --- Cause: java.sql.SQLException: Invalid column name
[19:06:55.866] at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
[19:06:55.866] at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
[19:06:55.866] at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
[19:06:55.866] at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
[19:06:55.866] at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
[19:06:55.866] at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:269)
[19:06:55.866] at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194)
[19:06:55.866] at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:220)
[19:06:55.866] at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:267)
[19:06:55.866] at com._21cn.generalwap.idao.ProvinceFriendChannelIDao.getColumnCount(ProvinceFriendChannelIDao.java:30)
[19:06:55.866] at com._21cn.generalwap.iservice.ProvinceFriendChannelIService.getColumnCount(ProvinceFriendChannelIService.java:31)
[19:06:55.866] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[19:06:55.866] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[19:06:55.866] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[19:06:55.866] at java.lang.reflect.Method.invoke(Method.java:597)
[19:06:55.866] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
[19:06:55.866] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
[19:06:55.866] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
[19:06:55.866] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
[19:06:55.866] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
[19:06:55.866] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
[19:06:55.866] at $Proxy15.getColumnCount(Unknown Source)
[19:06:55.866] at com._21cn.generalwap.controller.ProvinceFriendChannelUVController.getUV(ProvinceFriendChannelUVController.java:116)
[19:06:55.866] at com._21cn.generalwap.controller.ProvinceFriendChannelUVController.provinceFriendChannelUV(ProvinceFriendChannelUVController.java:47)
[19:06:55.866] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[19:06:55.866] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[19:06:55.866] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
19:06:55,857 DEBUG PreparedStatement:27 - {pstm-100823} Parameters: [uv, 2011-09-20 00:00:00, 2011-09-20 23:00:00]
19:06:55,857 DEBUG PreparedStatement:27 - {pstm-100823} Parameters: [uv, 2011-09-20 00:00:00, 2011-09-20 23:00:00]
19:06:55,858 DEBUG PreparedStatement:27 - {pstm-100823} Types: [java.lang.String, java.lang.String, java.lang.String]
19:06:55,858 DEBUG PreparedStatement:27 - {pstm-100823} Types: [java.lang.String, java.lang.String, java.lang.String]
19:06:55,864 DEBUG ResultSet:27 - {rset-100824} ResultSet
[19:06:55.866] org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
[19:06:55.866] --- The error occurred in com/_21cn/generalwap/sqlmap/GENERALWAP_DAY_SqlMap.xml.
[19:06:55.866] --- The error occurred while applying a result map.
[19:06:55.866] --- Check the GENERALWAP_DAY.getColumnCount_pfchannel-AutoResultMap.
[19:06:55.866] --- Check the result mapping for the 'HH84' property.
[19:06:55.866] --- Cause: java.sql.SQLException: Invalid column name
[19:06:55.866] Caused by: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
[19:06:55.866] --- The error occurred in com/_21cn/generalwap/sqlmap/GENERALWAP_DAY_SqlMap.xml.
[19:06:55.866] --- The error occurred while applying a result map.
[19:06:55.866] --- Check the GENERALWAP_DAY.getColumnCount_pfchannel-AutoResultMap.
[19:06:55.866] --- Check the result mapping for the 'HH84' property.
[19:06:55.866] --- Cause: java.sql.SQLException: Invalid column name
[19:06:55.866] Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
[19:06:55.866] --- The error occurred in com/_21cn/generalwap/sqlmap/GENERALWAP_DAY_SqlMap.xml.
[19:06:55.866] --- The error occurred while applying a result map.
[19:06:55.866] --- Check the GENERALWAP_DAY.getColumnCount_pfchannel-AutoResultMap.
[19:06:55.866] --- Check the result mapping for the 'HH84' property.
[19:06:55.866] --- Cause: java.sql.SQLException: Invalid column name
[19:06:55.866] at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
[19:06:55.866] at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
[19:06:55.866] at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
[19:06:55.866] at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
[19:06:55.866] at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
[19:06:55.866] at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:269)
[19:06:55.866] at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194)
[19:06:55.866] at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:220)
[19:06:55.866] at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:267)
[19:06:55.866] at com._21cn.generalwap.idao.ProvinceFriendChannelIDao.getColumnCount(ProvinceFriendChannelIDao.java:30)
[19:06:55.866] at com._21cn.generalwap.iservice.ProvinceFriendChannelIService.getColumnCount(ProvinceFriendChannelIService.java:31)
[19:06:55.866] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[19:06:55.866] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[19:06:55.866] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[19:06:55.866] at java.lang.reflect.Method.invoke(Method.java:597)
[19:06:55.866] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
[19:06:55.866] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
[19:06:55.866] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
[19:06:55.866] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
[19:06:55.866] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
[19:06:55.866] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
[19:06:55.866] at $Proxy15.getColumnCount(Unknown Source)
[19:06:55.866] at com._21cn.generalwap.controller.ProvinceFriendChannelUVController.getUV(ProvinceFriendChannelUVController.java:116)
[19:06:55.866] at com._21cn.generalwap.controller.ProvinceFriendChannelUVController.provinceFriendChannelUV(ProvinceFriendChannelUVController.java:47)
[19:06:55.866] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[19:06:55.866] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[19:06:55.866] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货