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

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

查看全部
weixin_39709335
小面包CC
2019/04/04 15:57
  • tomcat
  • maven
  • 点赞
  • 收藏
  • 回答
    私信

2个回复