### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: INSERT command denied to user 'kj'@'im.chbjt.com' for table 'BLOOD_SUGAR'
### The error may involve com.kj.mybatis.mapper.BloodSugarMapper.insertUserBloodSugar-Inline
### The error occurred while setting parameters
### SQL: insert into BLOOD_SUGAR( LOCAL_DATE, USER_PHONE, BL_SUGAR_VAL, EVAL_RESULT, RESULT_FLAG) values( ?, ?, ?, ?, ?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: INSERT command denied to user 'kj'@'im.chbjt.com' for table 'BLOOD_SUGAR'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: INSERT command denied to user 'kj'@'im.chbjt.com' for table 'BLOOD_SUGAR'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:365)
at $Proxy9.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:237)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:79)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
at $Proxy12.insertUserBloodSugar(Unknown Source)
at com.kj.dao.DataDao.sugarSave(DataDao.java:36)
### The error may involve com.kj.mybatis.mapper.BloodSugarMapper.insertUserBloodSugar-Inline
### The error occurred while setting parameters
### SQL: insert into BLOOD_SUGAR( LOCAL_DATE, USER_PHONE, BL_SUGAR_VAL, EVAL_RESULT, RESULT_FLAG) values( ?, ?, ?, ?, ?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: INSERT command denied to user 'kj'@'im.chbjt.com' for table 'BLOOD_SUGAR'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: INSERT command denied to user 'kj'@'im.chbjt.com' for table 'BLOOD_SUGAR'
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:365)
at $Proxy9.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:237)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:79)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
at $Proxy12.insertUserBloodSugar(Unknown Source)
at com.kj.dao.DataDao.sugarSave(DataDao.java:36)
at com.kj.dao.thread.BloodSugarDaoThread.run(BloodSugarThread.java:46)
解决:web服务器上的应用程序连接本机的redis,IP地址不能设置为127.0.0.1,要设置为实际IP