问题描述:
Written [{"code":-900,"data":"","desc":"org.springframework.jdbc.BadSqlGrammarException: \r\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束\n\r\n### The error may exist in file [E:\\JAVA\\Work\\Server\\Tomcat\\Tomcat7.0\\apache-tomcat-7.0.40\\webapps\\yl_myyd\\WEB-INF\\classes\\com\\yinlian\\wssc\\web\\mapper\\xml\\SmsBlackListMapper.xml]\r\n### The error may involve com.yinlian.wssc.web.mapper.SmsBlackListMapper.selectIsBlack-Inline\r\n### The error occurred while setting parameters\r\n### SQL: SELECT nvl(COUNT(1),0) (1) AS c FROM SMS_BLACK_LIST where phone= ?) and IS_BLACK = 1\r\n### Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束\n\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束\n","startTime":"2018-09-10 21:58:04","token":""}] as "text/html;charset=UTF-8" using [org.springframework.http.converter.StringHttpMessageConverter@725d9aa7]
解决方法:xml文件中 因为好多方法是类似的,大部分程序员是直接拷贝 粘贴,晚上加班的时候精神不是特别好,
#{ip,jdbcType=TIMESTAMP},这个拷贝时多了一个“)”