druid mysql 版本_使用Mybatis和druid连接池报错 merge sql error, dbType mysql, sql

最新推荐文章于 2024-04-25 14:03:43 发布
最新推荐文章于 2024-04-25 14:03:43 发布
阅读量7.6k 收藏
点赞数
文章标签： druid mysql 版本
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_35260153/article/details/113382910
版权

在项目中用mybatis查询的时候遇到一个这样的问题，抛错详情如下：merge sql error, dbType mysql, sql :

select r.id from role r inner join role_function rf on r.id = rf.role_id inner join function f on rf.function_id = f.id where r.id != 1 and f.code IN ( ? )

com.alibaba.druid.sql.parser.ParserException: ERROR. token : FUNCTION, pos : 92at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:567)

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.primary(MySqlExprParser.java:166)

at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:121)

at com.alibaba.druid.sql.parser.SQLSelectParser.expr(SQLSelectParser.java:461)

at com.alibaba.druid.sql.parser.SQLSelectParser.parseTableSourceQueryTableExpr(SQLSelectParser.java:365)

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.parseTableSource(MySqlSelectParser.java:211)

at com.alibaba.druid.sql.parser.SQLSelectParser.parseTableSourceRest(SQLSelectParser.java:438)

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.parseTableSourceRest(MySqlSelectParser.java:392)

at com.alibaba.druid.sql.parser.SQLSelectParser.parseTableSourceRest(SQLSelectParser.java:454)

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.parseTableSourceRest(MySqlSelectParser.java:392)

at com.alibaba.druid.sql.parser.SQLSelectParser.parseTableSourceRest(SQLSelectParser.java:375)

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.parseTableSourceRest(MySqlSelectParser.java:392)

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.parseTableSource(MySqlSelectParser.java:213)

at com.alibaba.druid.sql.parser.SQLSelectParser.parseFrom(SQLSelectParser.java:314)

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.query(MySqlSelectParser.java:139)

at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:60)

at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseSelect(MySqlStatementParser.java:215)

at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:180)

at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:145)

at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:140)

at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:53)

at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:145)

at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:630)

at com.alibaba.druid.filter.stat.StatFilter.statementPrepareAfter(StatFilter.java:305)

at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:146)

at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:471)

at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:941)

at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:143)

at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:471)

at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:375)

at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:361)

at sun.reflect.GeneratedMethodAccessor218.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:483)

at com.github.mybatis.spring.LazyConnection.invoke(LazyConnection.java:113)

at com.sun.proxy.$Proxy226.prepareStatement(Unknown Source)

at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:77)

at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)

at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:58)

at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:76)

at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:61)

at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)

at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)

at sun.reflect.GeneratedMethodAccessor217.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:483)

at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)

at com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:404)

at com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:377)

at com.github.pagehelper.PageHelper.intercept(PageHelper.java:227)

at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)

at com.sun.proxy.$Proxy225.query(Unknown Source)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)

at sun.reflect.GeneratedMethodAccessor216.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:483)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)

at com.sun.proxy.$Proxy28.selectList(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:205)

at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:122)

at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:64)

at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)

at com.sun.proxy.$Proxy60.getOldRoleIdsByFunctionCode(Unknown Source)

at com.facishare.ibss.data.mda.impl.AncientRoleServiceImpl.getOldRoleIdsByNewOne(AncientRoleServiceImpl.java:57)

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:483)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:58)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)

at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:97)

at com.github.trace.aop.ServiceProfiler.profile(ServiceProfiler.java:35)

at sun.reflect.GeneratedMethodAccessor215.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:483)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)

at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)

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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

at com.sun.proxy.$Proxy70.getOldRoleIdsByNewOne(Unknown Source)

at com.facishare.ibss.data.mda.impl.AccountRoleRelServiceImpl.insertOneAccountManyRole(AccountRoleRelServiceImpl.java:68)

at com.facishare.ibss.data.mda.impl.AccountRoleRelServiceImpl.updateOneAccountManyRole(AccountRoleRelServiceImpl.java:114)

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:483)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:58)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:97)

at com.github.trace.aop.ServiceProfiler.profile(ServiceProfiler.java:35)

at sun.reflect.GeneratedMethodAccessor215.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:483)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)

at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)

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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

at com.sun.proxy.$Proxy71.updateOneAccountManyRole(Unknown Source)

at com.facishare.ibss.data.mda.impl.EmployeeServiceImpl.updateEmployeeAll(EmployeeServiceImpl.java:226)

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:483)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:58)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:97)

at com.github.trace.aop.ServiceProfiler.profile(ServiceProfiler.java:35)

at sun.reflect.GeneratedMethodAccessor215.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:483)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)

at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)

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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)

at com.sun.proxy.$Proxy88.updateEmployeeAll(Unknown Source)

at com.alibaba.dubbo.common.bytecode.Wrapper1.invokeMethod(Wrapper1.java)

at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:46)

at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:72)

at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:53)

at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:64)

at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)

at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75)

at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)

at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:42)

at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)

at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78)

at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)

at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:60)

at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)

at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:112)

at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)

at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38)

at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)

at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:38)

at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)

at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:108)

at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:84)

at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:170)

at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52)

at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:82)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

代码调用如下：@Lang( MyBatisInDriver.class )

@Select( {

"select r.id from role r inner join role_function rf on r.id = rf.role_id",

"inner join function f on rf.function_id = f.id",

"where r.id != 1 and f.code IN (#{functionList})"

})

@Results( {

@Result( column="id", property="id", jdbcType= JdbcType.INTEGER, id=true)

})

List< Integer > getOldRoleIdsByFunctionCode( @Param( "functionList" )List< String > functionList );

我在本地调试是OK的，在线上就报错，实在是不知道哪里出了问题，请教一下各位大神！！！

晓风轻
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mybatis mysql merge_使用Mybatis和druid连接池报错 merge sql error, dbType mysql, sql
weixin_39861624的博客
01-19 1661
at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:567)at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.primary(MySqlExprParser.java:166)at com.alibaba.druid.sql.par...
Mybatis读写分离 mysql数据库 Druid连接池
11-02
数据库是mysql，采用druid连接池。 读写分离采用插件的形式实现的，优点是不需要写源注解，不需要写分开的Mapper.xml。 如果只有主库的话，那么会创建两个地址相同的连接池，写主库，读从库。 注意：没有使用Spring...
canal-adpter执行update语句durid报错parse sql error解决方法
weixin_43513735的博客
04-24 229
canal-adpter在执行update同步数据时报错。
mysql的sql语句没错但是报错,sql语句可以正常执行，但是报错：【merge sql error, dbType mysql, sql :】...
weixin_33503998的博客
03-18 3701
错误信息如下：2017-09-06 19:03:41.186:[ERROR] method:com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:147) merge sql error, dbType mysql, sql : select * from users order by convert(display_...
民航电子数据库：报错merge sql error, dbType null, druid-1.1.9, sql : xxx
最新发布
weixin_52116015的博客
04-25 616
民航电子数据库：报错merge sql error, dbType null, druid-1.1.9, sql : xxx com.alibaba.druid.sql.parser.ParserException: syntax error, error in :' LIMIT 0,1', expect IDENTIFIER, actual IDENTIFIER pos 101, line 2, column 36, token IDENTIFIER LIMIT
[druid or mybatis] merge sql error, dbType mysql, druid-1.2.12, sql : .
qq_42809896的博客
12-19 7004
parserException: not supported.pos 1, line 1, column 1, token .
使用Mybatis和druid连接池报错 merge sql error, dbType mysql, sql : select
baidu_33321010的博客
03-20 3406
Druid + Mysql + Mybatis，使用Mybatis和druid连接池报错 merge sql error, dbType mysql
merge sql error, dbType dm, sql
weixin_39067447的博客
02-26 2886
merge sql error, dbType dm, sql 达梦数据库配合Druid报错及解决方案 一. 问题描述 编写代码进行测试的时候，控制台报出如下错误 2021-02-26 16:34:49.637 ERROR 21256 --- [nio-8080-exec-1] c.alibaba.druid.filter.stat.StatFilter : merge sql error, dbType dm, sql : SELECT ... ASC LIMIT ? com.alibaba.dr
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.
报错:merge sql error, dbType mysql, sql : select...
先知三日
12-11 744
使用Mybatis和druid连接池报错merge sql error, dbType mysql, sql : select
MySql_JDBC, Druid数据库连接池以及Template技术所需jar包.zip
11-16
MySQL JDBC、Druid数据库连接池和Template技术是Java Web开发中的关键组件，它们极大地提高了数据库操作的效率和便捷性。让我们深入探讨这些知识点。 首先，MySQL JDBC（Java Database Connectivity）是Java与MySQL...
spring-boot_mysql_mybatis_druid
09-06
1. **添加依赖**：在Spring Boot的`pom.xml`文件中，我们需要添加Spring Boot的`spring-boot-starter-web`、`spring-boot-starter-jdbc`、MySQL驱动、MyBatis核心库和Druid连接池的依赖。 2. **配置MySQL**：在`...
MyBatis 通过第三方Druid数据连接池连接SQL server 简单例子
06-30
本教程将详细介绍如何在MyBatis中利用第三方库Druid来创建数据连接池，并以SQL Server为例进行配置和使用。 首先，我们需要理解MyBatis和Druid的基本概念。MyBatis是一个轻量级的ORM（对象关系映射）框架，它可以将...
SpringBoot+MyBatis+Druid连接池+JDBC官方驱动+ClickHouse
01-17
在这个场景中，我们关注的是一个基于SpringBoot、MyBatis和Druid连接池的项目，它利用了ClickHouse的JDBC官方驱动进行数据操作。这个组合提供了强大的数据库管理和分析能力，特别适合大数据量的实时查询和分析。下面...
【druid】merge sql error, dbType kingbase, druid-1.2.5, sql
筱星
07-23 1035
druid+Mybatis使用问题
druid报错，merge sql error, interval
lzy1286427633的博客
09-14 2249
merge sql error报错
记一次MySQL创建数据库连接时提示数据库超时问题
Huiger1234的博客
04-25 7967
首先看一下报错信息： Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConne..
Druid中 SQL包含INTERVAL 会直接抛异常 token INTERVAL
loveLifeLoveCoding的博客
06-02 3432
查询近一个月总数sql，mapper如下： <select id="countMonthExp" parameterType="com.hky.domain.Experience" resultType="java.lang.Integer"> select COUNT(1) from TB_EXPERIENCE exp where exp.creatdate>DATE_SUB(CURDATE(), interval 1 MONTH) and exp.cstatus = 1 </s.

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值