316 Star 2.7K Fork 1.5K

panll / wvp-GB28181-pro

 / 详情

WEB端登陆失败,记录登陆日志数据库时抛异常。

已完成
创建于  
2023-07-12 18:40
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6e974ecb] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@784101264 wrapping com.mysql.cj.jdbc.ConnectionImpl@87c5147] will not be managed by Spring
==>  Preparing: select u.*, r.id as role_id, r.name as role_name, r.authority as role_authority , r.create_time as role_create_time , r.update_time as role_update_time from wvp_user u, wvp_user_role r WHERE u.role_id=r.id and u.username=?
==> Parameters: admin(String)
<==    Columns: id, username, password, role_id, create_time, update_time, push_key, role_id, role_name, role_authority, role_create_time, role_update_time
<==        Row: 1, admin, 21232f297a57a5a743894a0e4a801fc3, 1, 2021-04-13 14:14:57, 2021-04-13 14:14:57, 3e80d1762a324d5b0ff636e0bd16f1e3, 1, admin, 0, 2021-04-13 14:14:57, 2021-04-13 14:14:57
<==      Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6e974ecb]
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@20daf75d] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@230152633 wrapping com.mysql.cj.jdbc.ConnectionImpl@87c5147] will not be managed by Spring
==>  Preparing: insert into wvp_log ( name,type,uri,address,result,timing,username,create_time) values (?, ?, ?, ?, ?, ?, ?, ?)
==> Parameters: 登录(String), GET(String), /api/user/login(String), 192.168.1.66(String), 200 OK(String), 138(Long), admin(String), 2023-07-12 18:38:44(String)
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@20daf75d]
2023-07-12 18:38:44.635 ERROR --- [dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception

org.springframework.jdbc.UncategorizedSQLException: 
### Error updating database.  Cause: java.sql.SQLException: Incorrect string value: '\xE7\x99\xBB\xE5\xBD\x95' for column 'name' at row 1
### The error may exist in com/genersoft/iot/vmp/storager/dao/LogMapper.java (best guess)
### The error may involve com.genersoft.iot.vmp.storager.dao.LogMapper.add-Inline
### The error occurred while setting parameters
### SQL: insert into wvp_log ( name,type,uri,address,result,timing,username,create_time) values (?, ?, ?, ?, ?, ?, ?, ?)
### Cause: java.sql.SQLException: Incorrect string value: '\xE7\x99\xBB\xE5\xBD\x95' for column 'name' at row 1
; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE7\x99\xBB\xE5\xBD\x95' for column 'name' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE7\x99\xBB\xE5\xBD\x95' for column 'name' at row 1
        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
        at com.sun.proxy.$Proxy84.insert(Unknown Source)
        at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
        at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
        at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
        at com.sun.proxy.$Proxy99.add(Unknown Source)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
        at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocati

评论 (1)

xujiaming303 创建了任务
xujiaming303 修改了描述
展开全部操作日志

修改 wvp-GB28181-pro\sql\初始化.sql中创建日志表使用默认UTF-8编码

create table wvp_log (
                         id serial primary key ,
                         name character varying(50),
                         type character varying(50),
                         uri character varying(200),
                         address character varying(50),
                         result character varying(50),
                         timing bigint,
                         username character varying(50),
                         create_time character varying(50)
) DEFAULT CHARSET=utf8;
xujiaming303 任务状态待办的 修改为已完成

登录 后才可以发表评论

状态
负责人
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
参与者(1)
Java
1
https://gitee.com/pan648540858/wvp-GB28181-pro.git
git@gitee.com:pan648540858/wvp-GB28181-pro.git
pan648540858
wvp-GB28181-pro
wvp-GB28181-pro

搜索帮助

344bd9b3 5694891 D2dac590 5694891