【日常Exception】第九回：No enum constant com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.d

最新推荐文章于 2023-02-14 14:49:45 发布
最新推荐文章于 2023-02-14 14:49:45 发布
阅读量1.2w 收藏
点赞数
分类专栏： 异常记录 文章标签： oracle exception sql day
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yy339452689/article/details/103362466
版权

热门系列：

1.问题

今天调试bug时，sql语句如下：

and create_time >= sysdate - interval '30' day and  rownum <=400

查询报错：

org.springframework.jdbc.UncategorizedSQLException: 
### Error querying database.  Cause: java.sql.SQLException: sql injection violation, syntax error: No enum constant com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.day : SELECT count(0) FROM cs_credit WHERE 1 = 1 AND credit_model IN (?) AND status = ? AND CREDIT_TYPE IN (?) AND create_time >= sysdate - INTERVAL '30' day AND rownum <= 400
### The error may exist in file [D:\IdeaWorkPlace\giveuStore\giveu-cashLoan\giveu-cashLoan-service\target\classes\mapper\dafy\CsCreditMapper.xml]
### The error may involve com.dafycredit.cashLoan.mapper.dafy.CsCreditMapper.getEntryForConditional_COUNT
### The error occurred while executing a query
### SQL: SELECT count(0) FROM cs_credit WHERE 1 = 1 AND credit_model IN (?) AND status = ? AND CREDIT_TYPE IN (?) AND create_time >= sysdate - INTERVAL '30' day AND rownum <= 400
### Cause: java.sql.SQLException: sql injection violation, syntax error: No enum constant com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.day : SELECT count(0) FROM cs_credit WHERE 1 = 1 AND credit_model IN (?) AND status = ? AND CREDIT_TYPE IN (?) AND create_time >= sysdate - INTERVAL '30' day AND rownum <= 400
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection violation, syntax error: No enum constant com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.day : SELECT count(0) FROM cs_credit WHERE 1 = 1 AND credit_model IN (?) AND status = ? AND CREDIT_TYPE IN (?) AND create_time >= sysdate - INTERVAL '30' day AND rownum <= 400; nested exception is java.sql.SQLException: sql injection violation, syntax error: No enum constant com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.day : SELECT count(0) FROM cs_credit WHERE 1 = 1 AND credit_model IN (?) AND status = ? AND CREDIT_TYPE IN (?) AND create_time >= sysdate - INTERVAL '30' day AND rownum <= 400
	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.$Proxy124.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
	at com.baomidou.mybatisplus.core.override.PageMapperMethod.executeForMany(PageMapperMethod.java:173)
	at com.baomidou.mybatisplus.core.override.PageMapperMethod.execute(PageMapperMethod.java:86)
	at com.baomidou.mybatisplus.core.override.PageMapperProxy.invoke(PageMapperProxy.java:64)
	at com.sun.proxy.$Proxy147.getEntryForConditional(Unknown Source)
	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)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy148.getEntryForConditional(Unknown Source)
	at com.dafycredit.cashLoan.service.impl.CsCreditServiceImpl.getEntryForConditional(CsCreditServiceImpl.java:402)
	at com.dafycredit.cashLoan.service.impl.CsCreditServiceImpl$$FastClassBySpringCGLIB$$b666c0ca.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at com.dafycredit.log.aop.ServiceLogAspect.invoke(ServiceLogAspect.java:58)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
	at com.dafycredit.cashLoan.service.impl.CsCreditServiceImpl$$EnhancerBySpringCGLIB$$3113a4a1.getEntryForConditional(<generated>)
	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)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.cloud.sleuth.instrument.web.TraceFilter.doFilter(TraceFilter.java:166)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: sql injection violation, syntax error: No enum constant com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.day : SELECT count(0) FROM cs_credit WHERE 1 = 1 AND credit_model IN (?) AND status = ? AND CREDIT_TYPE IN (?) AND create_time >= sysdate - INTERVAL '30' day AND rownum <= 400
	at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:725)
	at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:253)
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)
	at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:928)
	at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122)
	at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)
	at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342)
	at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:346)
	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)
	at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:55)
	at com.sun.proxy.$Proxy284.prepareStatement(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:87)
	at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
	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)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor.intercept(PaginationInterceptor.java:166)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy283.prepare(Unknown Source)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:112)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy282.query(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
	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)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	... 100 common frames omitted
Caused by: java.lang.IllegalArgumentException: No enum constant com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.day
	at java.lang.Enum.valueOf(Enum.java:238)
	at com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.valueOf(OracleIntervalType.java:18)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleExprParser.parseInterval(OracleExprParser.java:878)
	at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:567)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleExprParser.primary(OracleExprParser.java:465)
	at com.alibaba.druid.sql.parser.SQLExprParser.bitXor(SQLExprParser.java:111)
	at com.alibaba.druid.sql.parser.SQLExprParser.multiplicative(SQLExprParser.java:163)
	at com.alibaba.druid.sql.parser.SQLExprParser.additiveRest(SQLExprParser.java:1374)
	at com.alibaba.druid.sql.parser.SQLExprParser.additive(SQLExprParser.java:1357)
	at com.alibaba.druid.sql.parser.SQLExprParser.shift(SQLExprParser.java:1384)
	at com.alibaba.druid.sql.parser.SQLExprParser.bitAnd(SQLExprParser.java:1262)
	at com.alibaba.druid.sql.parser.SQLExprParser.bitOr(SQLExprParser.java:1276)
	at com.alibaba.druid.sql.parser.SQLExprParser.relationalRest(SQLExprParser.java:1510)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleExprParser.relationalRest(OracleExprParser.java:943)
	at com.alibaba.druid.sql.parser.SQLExprParser.relational(SQLExprParser.java:1465)
	at com.alibaba.druid.sql.parser.SQLExprParser.andRest(SQLExprParser.java:1421)
	at com.alibaba.druid.sql.parser.SQLExprParser.exprRest(SQLExprParser.java:104)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleExprParser.exprRest(OracleExprParser.java:1073)
	at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:91)
	at com.alibaba.druid.sql.parser.SQLSelectParser.expr(SQLSelectParser.java:540)
	at com.alibaba.druid.sql.parser.SQLSelectParser.parseWhere(SQLSelectParser.java:260)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleSelectParser.query(OracleSelectParser.java:274)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleSelectParser.select(OracleSelectParser.java:81)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseStatementList(OracleStatementParser.java:131)
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:79)
	at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:620)
	at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:574)
	at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:712)
	... 138 common frames omitted

2.原因

低版本druid的bug

3.解决办法

<!--添加新版本依赖-->
<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid</artifactId>
  <version>1.0.29</version>
</dependency>

语句调整：

and create_time &gt;= sysdate - interval '30' DAY and  rownum &lt;=400

将day改成大写DAY，即可解决。

 

本博客皆为学习、分享、探讨为本，欢迎各位朋友评论、点赞、收藏、关注，一起加油！

参考链接：https://blog.csdn.net/qq_42931757/article/details/89330581

善良勤劳勇敢而又聪明的老杨
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
Filter_Enum.rar_enum.filter
09-24
用于枚举DShow过滤器，并且获取各个过滤器的详细信息；不同于标准教程介绍的方法，这个软件包采用【直接解析】方法，能够获取最全面的类型细节信息；
java 枚举 sql,Oracle枚举类型不完善，导致基本SQL执行报错！！！
weixin_30346649的博客
03-14 468
com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType 类中枚举类型不完善，导致基础SQL执行直接报错，具体执行SQL如下：SELECT to_char(sysdate-interval '1' hour,'hh24:mi:ss') as num FROM DUAL;报错信息如下：Caused by: java.sql.SQ...
Druid 之 java.sql.SQLException: sql injection violation
热门推荐
不积跬步 无以至千里
07-08 2万+
当我们在项目中使用了druid连接池进行数据源的管理，并且配置了如下监控spring.datasource.filters: stat,wall,log4j在执行程序拼接的SQL时，xml中使用的是${sql}进行执行的，这种方式会报如下错误:2018-07-08 15:09:04.826 [http-nio-7073-exec-1] ERROR o.a.c.c.C.[.[localhost].[...
使用淘宝连接池Druid出现的BUG解决
qq784515681的博客
09-11 1643
问题描述： 项目使用了淘宝连接池Druid，结果运行报错，报错情况如下： DruidDataSourceStatManager:211 - unregister mbean error javax.management.InstanceNotFoundException: com.alibaba.druid:type=DruidDataSourceStat at com.sun.jmx.i...
Mycat子查询问题
张晓天的专栏
07-30 2328
通过连接Mycat中间件访问数据库，如果要进行子查询的话，必须给子查询的结果集起一个别名，例如 select id from (select id from B) A。但是如果想对最后的结果集进行分组的话，分组字段不要加这个别名，会报错： [Err] 1064 - com.alibaba.druid.sql.ast.expr.SQLPropertyExpr cannot be cast to c...
使用Druid解析SQL小试
杨建荣的学习笔记
01-17 528
这是学习笔记的第1862篇文章Druid在行业内是一个很流行的开源工具，在很多开发项目里的数据源选型都是它，按照官方的参考数据，Druid的性能非常好，都是纳秒级别。G...
小米平板5 pro5G版【ENUMA】13.0.6稳定版一键获取完整root资源与详细步骤
06-28
小米平板5 pro5G版【ENUMA】13.0.6稳定版一键获取完整root资源与详细步骤 资源内带一键刷写脚本 只需要进入fast模式运行脚本即可完美刷入自动重启系统 带详细步骤说明 按步骤操作即可获取完整root权限 需要的友友...
moc.exe 解决moc过程中不支持处理enum包含#include头文件的语法。
06-19
问题1 The moc process failed to compile "SRC:/..............." into "Src:/................................." command -------- path/to/path ...tbb/tbb_profiling.:28: Parse error at "{
驰骋工作流引擎重要数据查询大全.sql
12-14
SELECT * FROM Sys_Enum WHERE EnumKey=’WFState’ — 查询已经完成的流程 SELECT * FROM WF_GenerWorkFlow WHERE WFState=3;   — 查询我参与的已经完成的流程 SELECT * FROM WF_GenerWorkFlow WHERE WFState=3 ...
mybatis使用like 模糊查询druid报异常 com.alibaba.druid.sql.parser.ParserException:
moerduo0的博客
06-13 536
mybatis使用like 模糊查询druid报异常 com.alibaba.druid.sql.parser.ParserException:
Java异常处理设计（二）
aduzz62084的博客
11-19 246
考虑对JDK的底层堆栈信息进行处理，一种是重写JDK的Throwable，另一种是在原错误堆栈信息上进行“二次加工”。目前这两种方式我都实现了，效果非常好。 这篇文章主要记录对错误堆栈进行“二次加工”的实现过程。 从大量的实际错误日志分析出发： 首先，追根溯源，找到错误是从哪个地方new出来的。 例如com.jfinal.plugin.activerecord....
结合MyBatis插件和Durid实现sql表动态修改
u012294039的专栏
06-28 1208
结合MyBatis插件和Durid实现sql表动态修改
com.alibaba.druid.sql.parser.ParserException: syntax error
deefin的博客
07-26 1万+
简单记一个灰常SB的错。 sql.append("select" +"a.MEMBER_NAME, b.ACTION_NAME" +"from CLUB_MEMBER a,CLUB c, MEMBER_ACTION_RECORD d"); sql.append("WHERE a.CLUB_MEMBER_ID = d.CLUB_MEMBER_ID" + "AND a.CLUB_ID = b....
【JAVA开发报错分析】Spring Boot com.alibaba.druid.pool.DruidDataSource 数据库连接失效
后端研发工程师Marion的博客
05-10 7874
一、问题描述 本来正常运行的Spring Boot项目突然报错 2020-05-10 11:57:10.054 [http-nio-8095-exec-3] ERROR com.alibaba.druid.pool.DruidPooledStatement - CommunicationsException, druid version 1.1.12, jdbcUrl : jdbc:mysql://dev001:3306/video_chat?useUnicode=true&character
异常：com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:sqlserver://
扒鸡斯坦
10-26 1万+
异常提示 2021-10-26 15:46:20.137 INFO 6656 --- [ main] e.d.AndroidJavaSqlserverApplicationTests : Starting AndroidJavaSqlserverApplicationTests using Java 1.8.0_312 on SH5003147002 with PID 6656 (started by chaotian in C:\workspaces\IDEA\android-j
com.alibaba.druid.filter.stat.StatFilter:148 - merge sql error, dbType mysql
nkshuangyuan2012的博客
11-24 1万+
出错的sql代码段： UPDATE `agent` SET `name`=#{name}, `areacode`=#{areacode}, `address`=#{address}, `linkman`=#{linkman}, `tel`=#{tel}, `staff_type`=${staffType}, `station_ids`=#{stationIds}, `username`=#{username}, `account_bl.
枚举报错 No enum constant XX 处理方法
花易折的博客
03-17 1万+
枚举报错 No enum constant XX 处理方法
com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.day
Java小白的学习日常
04-16 1913
sql： select to_char(SYSDATE - interval '1' day,'yyyyMMdd') from dual 错误信息： Caused by: java.lang.IllegalArgumentException: No enum constant com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleInterva...
【springboot】mysql连接求助
weixin_47222436的博客
02-14 169
mysql连接求助
java.lang.IllegalArgumentException: No enum constant java.sql.JDBCType.[B@2AE79113是什么，怎么办
最新发布
05-12
这个异常通常发生在使用JDBCType枚举类时，调用了不存在的枚举常量。 请检查你的代码中是否有以下情景： 1. 执行JDBC操作时，使用了不支持的JDBCType。 2. 将JDBCType的值转换为String或其他类型时，出现了错误。...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

善良勤劳勇敢而又聪明的老杨

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值