java - mybatis，調(diào)用存儲(chǔ)過程，“setselect”附近有語法錯(cuò)誤。
問題描述
mybatis，調(diào)用存儲(chǔ)過程，“setselect”附近有語法錯(cuò)誤。
<select resultMap='BaseResultMap' parameterType='com.unisits.zngkpt.framework.highwayreport.pojo.ReportType' statementType='CALLABLE'> {call Get_TrafficData_Report ( #{reportTimeType,mode=IN,jdbcType=VARCHAR},#{reportFunction,mode=IN,jdbcType=VARCHAR},#{year,mode=IN,jdbcType=INTEGER},#{month,mode=IN,jdbcType=INTEGER},#{day,mode=IN,jdbcType=INTEGER},#{tunnelId,mode=IN,jdbcType=INTEGER} )}</select>
把參數(shù)直接改成 ’Day’, ’JTLL’, 2015, 06, 15, 0就沒有問題。
完整log
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: ### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “setselect”附近有語法錯(cuò)誤。### The error may exist in file [D:zngkptcodezngkptoutartifactshighway_war_explodedWEB-INFclassesmappersqlserverTrafficReportStatic.xml]### The error may involve com.unisits.zngkpt.framework.highwayreport.mapper.TrafficReportDao.getTrafficReportData-Inline### The error occurred while setting parameters### SQL: {call Get_TrafficData_Report ( ?, ?, ?, ?, ?, ? )}### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “setselect”附近有語法錯(cuò)誤。
問題解答
回答1：存儲(chǔ)過程報(bào)錯(cuò)，直接把報(bào)錯(cuò)的參數(shù)用來調(diào)試存儲(chǔ)過程就知道什么問題了
相關(guān)文章：
1. java - MyBatis動(dòng)態(tài)SQL實(shí)現(xiàn)ORDER BY和LIMIT的控制？2. java - mybatis mapper文件中如何實(shí)現(xiàn)group by having？3. java - Mybatis 一對多怎么映射4. java - Mybatis映射問題5. java - Mybatis 參數(shù)類型問題,應(yīng)該是Map,結(jié)果報(bào)錯(cuò).6. java - mybatis mysql 如何實(shí)現(xiàn)upsert功能？7. java - mybatis會(huì)自己緩存自己生成過的prestatement嗎8. java - Mybatis插入mysql數(shù)據(jù)庫返回自增主鍵的問題？9. java - mybatis 插入數(shù)據(jù)到oracle，id無法用selectkey獲取到數(shù)據(jù)10. java - Mybatis:Mybatis能否直接返回一個(gè)二維數(shù)組(表)
網(wǎng)公網(wǎng)安備