代码拉取完成,页面将自动刷新
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
修改 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;
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。
登录 后才可以发表评论