org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient operation): encountered SQLException [
--- The error occurred in com/ewallpartner/partner/apps/dao/sqlmap/WaibaoNews.xml.
--- The error occurred while applying a result map.
--- Check the getNewsList-AutoResultMap.
--- Check the result mapping for the 'newsType' property.
--- Cause: java.sql.SQLException: 无法转换为内部表示]; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/ewallpartner/partner/apps/dao/sqlmap/WaibaoNews.xml.
--- The error occurred while applying a result map.
--- Check the getNewsList-AutoResultMap.
--- Check the result mapping for the 'newsType' property.
--- Cause: java.sql.SQLException: 无法转换为内部表示
--- The error occurred in com/ewallpartner/partner/apps/dao/sqlmap/WaibaoNews.xml.
--- The error occurred while applying a result map.
--- Check the getNewsList-AutoResultMap.
--- Check the result mapping for the 'newsType' property.
--- Cause: java.sql.SQLException: 无法转换为内部表示]; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/ewallpartner/partner/apps/dao/sqlmap/WaibaoNews.xml.
--- The error occurred while applying a result map.
--- Check the getNewsList-AutoResultMap.
--- Check the result mapping for the 'newsType' property.
--- Cause: java.sql.SQLException: 无法转换为内部表示
SELECT
B.NEWSID,
B.SUBJECT,
B.CONTENTS,
B.NEWSIMAGE,
B.BROWSECNT,
B.REFCNT,
B.ARRANGEYN,
B.TOPYN,
B.USEYN,
decode(B.NEWSTYPE,'1','行业新闻','2','企业动态','3','外包政策','') as NEWSTYPE
FROM (
SELECT
A.NEWSID,
A.SUBJECT,
A.CONTENTS,
A.NEWSIMAGE,
A.BROWSECNT,
A.REFCNT,
A.ARRANGEYN,
A.TOPYN,
A.USEYN,
A.NEWSTYPE,
ROWNUM RN FROM (
select
t1.NEWS_ID as NEWSID,
t1.SUBJECT as SUBJECT,
t1.CONTENTS as CONTENTS,
t1.NEWS_IMAGE as NEWSIMAGE,
t1.BROWSE_CNT as BROWSECNT,
t1.REF_CNT as REFCNT,
t1.ARRANGE_YN as ARRANGEYN,
t1.TOP_YN as TOPYN,
t1.USE_YN as USEYN,
t1.NEWS_TYPE as NEWSTYPE
from WAIBAO_NEWS t1
where 1=1
<isEqual property="isRange" compareValue="0">
<isNotNull property="webId">
and t1.WEB_ID = #webId#
</isNotNull>
</isEqual>
<isNotNull property="topYn">
and t1.TOP_YN = #topYn#
</isNotNull>
<isNotNull property="arrangeYn">
and t1.ARRANGE_YN = #arrangeYn#
</isNotNull>
<isNotNull property="useYn">
and t1.USE_YN = #useYn#
</isNotNull>
<isNotNull property="subject">
and t1.SUBJECT like '$subject$%'
</isNotNull>
<isNotNull property="newsType">
and t1.NEWS_TYPE = #newsType#
</isNotNull>
<isNotNull property="beginDate">
<isNotNull property="endDate">
and t1.INSERT_DATE BETWEEN #beginDate# AND #endDate#
</isNotNull>
</isNotNull>
<isNotNull property="orderValue">
$orderValue$
</isNotNull>
<![CDATA[
) A WHERE ROWNUM < $endRow$
) B WHERE RN >= $startRow$
]]>
</select>
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.conversionPattern=[%5p] %d{mm:ss}\
(%F:%M:%L)%n%m%n%nlog4j.logger.com.ibatis=debug
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=debug
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=debug
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=debug
log4j.logger.java.sql.Connection=debug
log4j.logger.java.sql.Statement=debug
log4j.logger.java.sql.PreparedStatement=debug,stdout
Cause: java.sql.SQLException: 无法转换为内部表示]; nested exception is com.ibatis.common.jdbc.exception 该错误, 我暂时估计是sql语句有问题。
PreparedStatement - {pstm-100004} Parameters: [1001, 1, 1, 1, 1]
PreparedStatement - {pstm-100004} Types: [java.lang.String, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer]