java - mybatis,调用存储过程,“setselect”附近有语法错误。
天蓬老师
天蓬老师 2017-04-18 10:54:52
0
1
726

mybatis,调用存储过程,“setselect”附近有语法错误。

把参数直接改成'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”附近有语法错误。 ### The error may exist in file [D:\zngkpt\code\zngkpt\out\artifacts\highway_war_exploded\WEB-INF\classes\mapper\sqlserver\TrafficReportStatic.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”附近有语法错误。
天蓬老师
天蓬老师

欢迎选择我的课程,让我们一起见证您的进步~~

reply all (1)
PHPzhong

The stored procedure reports an error. Use the error parameters directly to debug the stored procedure and you will know what the problem is

    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template
    About us Disclaimer Sitemap
    php.cn:Public welfare online PHP training,Help PHP learners grow quickly!