美文网首页
MySQL org.springframework.jdbc.U

MySQL org.springframework.jdbc.U

作者: 是瑞瀛呀 | 来源:发表于2019-04-06 13:32 被阅读0次

    解决办法:
    ALTER TABLE RYAN.SYS_VISIT_LOG CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

    异常原因:

    org.springframework.jdbc.UncategorizedSQLException: 
    ### Error updating database.  Cause: java.sql.SQLException: Incorrect string value: '\xE8\xBF\x9B\xE5\x85\xA5...' for column 'USE_FUNC' at row 1
    ### The error may involve org.ryan.demo.dao.SysVisitLogMapper.insert-Inline
    ### The error occurred while setting parameters
    ### SQL: insert into SYS_VISIT_LOG (VISIST_LOG_ID, IP_ADDR, URI,        URL, USE_FUNC, USER_AGENT,        EQUIPMENT, AREA_CODE, MAC,        USER_ID, CREATE_AT)     values (?, ?, ?,        ?, ?, ?,        ?, ?, ?,        ?, ?)
    ### Cause: java.sql.SQLException: Incorrect string value: '\xE8\xBF\x9B\xE5\x85\xA5...' for column 'USE_FUNC' at row 1
    ; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE8\xBF\x9B\xE5\x85\xA5...' for column 'USE_FUNC' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE8\xBF\x9B\xE5\x85\xA5...' for column 'USE_FUNC' at row 1
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
        at com.sun.proxy.$Proxy97.insert(Unknown Source)
        at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
        at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58)
        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
        at com.sun.proxy.$Proxy98.insert(Unknown Source)
        at org.ryan.demo.config.aspet.LogAspet.before(LogAspet.java:88)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
    

    相关文章

      网友评论

          本文标题:MySQL org.springframework.jdbc.U

          本文链接:https://www.haomeiwen.com/subject/iujriqtx.html