在本地的Tomcat服务器跑没问题；以下是发布到云服务器上的tomcat执行报的错

Question

This application has no explicit mapping for /error, so you are seeing this as a fallback.
Thu Apr 04 12:14:56 CST 2019
There was an unexpected error (type=Internal Server Error, status=500).

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000 ### The error may exist in com/hunca/mapper/UserDeviceMapper.xml ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT count(*) FROM (SELECT ca.cityName, ca.cityDevNum, d.devType, COUNT(1) AS deviceNum FROM (SELECT DISTINCT c.cityCode, c.cityName, COUNT(1) AS cityDevNum FROM userdevice u JOIN city c ON u.cityCode = c.cityCode WHERE 1 = 1 GROUP BY c.areaCode) AS ca JOIN userdevice d ON ca.cityCode = d.cityCode GROUP BY d.cityCode, d.devType) table_count ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000

Answer 1

设置查询DB的参数的时候，导致了语法的问题