67,550
社区成员
发帖
与我相关
我的任务
分享mariadb问题
最近将数据库驱动修改为mariadb，系统能跑起来，但是无法登录，框架是ssm
修改驱动
jdbc.driverClassName=org.mariadb.jdbc.Driver
jdbc.url=jdbc:mariadb:aurora://**********?useAffectedRows=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
引入依赖
报错信息
修改驱动
jdbc.driverClassName=org.mariadb.jdbc.Driver
jdbc.url=jdbc:mariadb:aurora://**********?useAffectedRows=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
引入依赖
<dependency>
<groupId>org.mariadb.jdbc</groupId>
<artifactId>mariadb-java-client</artifactId>
<version>2.6.2</version>
</dependency>
报错信息
2020-09-25 15:20:02.410 [http-bio-7080-exec-1] ERROR com.daxia.system.web.controller.PortalController - 登录异常
java.lang.RuntimeException: org.springframework.jdbc.UncategorizedSQLException:
### Error updating database. Cause: java.sql.SQLException: org.mariadb.jdbc.Driver
### Cause: java.sql.SQLException: org.mariadb.jdbc.Driver
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; org.mariadb.jdbc.Driver; nested exception is java.sql.SQLException: org.mariadb.jdbc.Driver
at com.daxia.sharding.sqlSession.DBSqlSessionTemplate.executeInConcurrency(DBSqlSessionTemplate.java:530) ~[framework-sharding-1.1.7.jar:?]
at com.daxia.sharding.sqlSession.DBSqlSessionTemplate.executeInConcurrency(DBSqlSessionTemplate.java:452) ~[framework-sharding-1.1.7.jar:?]
at com.daxia.sharding.sqlSession.DBSqlSessionTemplate.executeInConcurrency(DBSqlSessionTemplate.java:539) ~[framework-sharding-1.1.7.jar:?]
at com.daxia.sharding.sqlSession.DBSqlSessionTemplate.insert(DBSqlSessionTemplate.java:329) ~[framework-sharding-1.1.7.jar:?]
at com.daxia.framework.dao.DaoProxy.execute(DaoProxy.java:75) ~[framework-dao-1.1.7.jar:?]
at com.daxia.framework.dao.DaoProxy.invoke(DaoProxy.java:47) ~[framework-dao-1.1.7.jar:?]
at com.daxia.system.user.$Proxy119.insertLoginLog(Unknown Source) ~[?:?]
at com.daxia.system.user.UserServiceImpl.login(UserServiceImpl.java:116) ~[system-core-1.1.7-SNAPSHOT.jar:?]
at com.daxia.system.user.UserServiceImpl$$FastClassByCGLIB$$91d0e11e.invoke(<generated>) ~[spring-core-3.2.0.RELEASE.jar:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698) ~[spring-aop-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) ~[spring-aop-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) ~[spring-aop-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) ~[spring-aop-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631) ~[spring-aop-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at com.daxia.system.user.UserServiceImpl$$EnhancerByCGLIB$$411cf276.login(<generated>) ~[spring-core-3.2.0.RELEASE.jar:?]
at com.daxia.system.web.controller.PortalController.doLogin(PortalController.java:169) [system-web-1.1.7-SNAPSHOT-classes.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_80]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_80]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_80]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_80]
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219) [spring-web-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) [spring-web-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:746) [spring-webmvc-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:687) [spring-webmvc-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) [spring-webmvc-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925) [spring-webmvc-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856) [spring-webmvc-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:915) [spring-webmvc-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:822) [spring-webmvc-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) [servlet-api.jar:?]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:796) [spring-webmvc-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) [servlet-api.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) [catalina.jar:7.0.94]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.94]
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77) [spring-web-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.94]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.94]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat7-websocket.jar:7.0.94]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.94]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.94]
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:195) [javamelody-core-1.59.0_tianji.jar:1.59.0_tianji]
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:172) [javamelody-core-1.59.0_tianji.jar:1.59.0_tianji]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.94]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.94]
at com.daxia.framework.web.filter.DaxiaRequestFilter.doFilter(DaxiaRequestFilter.java:22) [framework-web-1.1.7.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.94]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.94]
at com.daxia.framework.session.DistributeSessionFilter.doFilter(DistributeSessionFilter.java:63) [framework-session-1.1.7.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.94]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.94]
at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.1.jar:2.1]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.94]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.94]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) [spring-web-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-3.2.0.RELEASE.jar:3.2.0.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.94]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.94]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) [catalina.jar:7.0.94]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) [catalina.jar:7.0.94]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) [catalina.jar:7.0.94]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) [catalina.jar:7.0.94]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) [catalina.jar:7.0.94]
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) [catalina.jar:7.0.94]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) [catalina.jar:7.0.94]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) [catalina.jar:7.0.94]
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137) [tomcat-coyote.jar:7.0.94]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) [tomcat-coyote.jar:7.0.94]
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:317) [tomcat-coyote.jar:7.0.94]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
...全文
请发表友善的回复…
发表回复
蓝莓之恋9527 2020-10-26
- 打赏
- 举报
在此统一回复，由于jdk用的7，mariadb版本只能用1.6.1，谢谢各位！
八爻老骥 2020-10-10
- 打赏
- 举报
SQL语句为空，检查一下你的DAO怎么写的。
vcshcn 2020-10-10
- 打赏
- 举报
UncategorizedSQLException 说sql 语法错误， 把sql改成 select 0试试
明白畅达 2020-09-27
- 打赏
- 举报
换成什么呢，求指教[/quote]一般来说用的都是com.mysql.jdbc.Driver，你应该也是这个，但是我上次也用过一个别的驱动，当时idea有提示，我忘了是什么[/quote]
我现在就是要用org.mariadb.jdbc.Driver[/quote]你就用mysql的驱动啊，你pom里导mysql的包，然后驱动填com.mysql.jdbc.Driver，配置里连接你的mariadb，你用org.mariadb.jdbc.Driver我是不知道，我只用数据库用mariadb，驱动还是mysql的，mariadb是MySQL
的分支
蓝莓之恋9527 2020-09-25
- 打赏
- 举报
换成什么呢，求指教[/quote]一般来说用的都是com.mysql.jdbc.Driver，你应该也是这个，但是我上次也用过一个别的驱动，当时idea有提示，我忘了是什么[/quote]
我现在就是要用org.mariadb.jdbc.Driver
明白畅达 2020-09-25
- 打赏
- 举报
换成什么呢，求指教[/quote]一般来说用的都是com.mysql.jdbc.Driver，你应该也是这个，但是我上次也用过一个别的驱动，当时idea有提示，我忘了是什么
蓝莓之恋9527 2020-09-25
- 打赏
- 举报
换成什么呢，求指教
明白畅达 2020-09-25
- 打赏
- 举报
看样子应该是数据库驱动错了，换一下试试
Conmi的正确答案——mariadb问题：“Specified key was too long； max key length is 767 bytes”与“Index column si...”