注册

mybatis-plus+dm8语法分析出错

王添乐 2022/05/17 1635 8 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8 1-2-84-21.10.21-149328-10032-ENT
【操作系统】:windows 10
【CPU】:intel core i7
【问题描述】*:项目框架采用springboot2.3.9 + mybatis-plus 3.3.2+dm8,使用dm8自带的DmJdbcDriver18.jar,项目中配置driver-class-name: dm.jdbc.driver.DmDriver
url: jdbc:dm://10.1.26.95:5236?sechema=AIMEETING2&useSSL=true&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&serverTimezone=Asia/Shanghai
username: SYSDBA
password: SYSDBA
在项目启动时,会通过mybatis-plus查询一个数据库表,结果显示语法分析出错,具体错误如下,请问如何解决?
2022-05-17 14:37:09.241 [][] [restartedMain] ERROR o.s.boot.SpringApplication - Application run failed
java.lang.IllegalStateException: Failed to execute CommandLineRunner
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798)
at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:779)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:322)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226)
at com.zst.aim.BpApplication.main(BpApplication.java:27)
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.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)
Caused by: org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: dm.jdbc.driver.DMException: 第 1 行, 第 8 列[`]附近出现错误:

语法分析出错

The error may exist in com/zst/aim/dao/config/ConfigDao.java (best guess)

The error may involve com.zst.aim.dao.config.ConfigDao.selectList

The error occurred while executing a query

SQL: SELECT key,value,display_name,group_key,order,system_mode,target,description,type,is_deleted FROM sys_config WHERE is_deleted=0

Cause: dm.jdbc.driver.DMException: 第 1 行, 第 8 列[`]附近出现错误:

语法分析出错
; bad SQL grammar []; nested exception is dm.jdbc.driver.DMException: 第 1 行, 第 8 列[]附近出现错误: 语法分析出错 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy151.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96) at com.sun.proxy.$Proxy152.selectList(Unknown Source) at com.zst.aim.spring.runer.ConfigRuner.run(ConfigRuner.java:34) at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:795) ... 10 common frames omitted Caused by: dm.jdbc.driver.DMException: 第 1 行, 第 8 列[]附近出现错误:
语法分析出错
at dm.jdbc.driver.DBError.throwException(DBError.java:684)
at dm.jdbc.b.b.o.E(MSG.java:556)
at dm.jdbc.b.b.o.B(MSG.java:516)
at dm.jdbc.b.b.o.A(MSG.java:497)
at dm.jdbc.b.a.a(DBAccess.java:227)
at dm.jdbc.b.a.a(DBAccess.java:686)
at dm.jdbc.driver.DmdbPreparedStatement.prepareSql(DmdbPreparedStatement.java:267)
at dm.jdbc.driver.DmdbPreparedStatement.allocateHandle(DmdbPreparedStatement.java:224)
at dm.jdbc.driver.DmdbPreparedStatement.<init>(DmdbPreparedStatement.java:126)
at dm.jdbc.driver.DmdbPreparedStatement.<init>(DmdbPreparedStatement.java:176)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:705)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:691)
at dm.jdbc.filter.FilterChain.Connection_prepareStatement(FilterChain.java:2085)
at dm.jdbc.filter.reconnect.ReconnectFilter.Connection_prepareStatement(ReconnectFilter.java:2201)
at dm.jdbc.filter.FilterChain.Connection_prepareStatement(FilterChain.java:2081)
at dm.jdbc.driver.DmdbConnection.prepareStatement(DmdbConnection.java:1327)
at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337)
at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
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.$Proxy286.prepareStatement(Unknown Source)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86)
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:92)
at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:66)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:163)
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:111)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy285.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
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:427)
… 18 common frames omitted
我看上面的错误信息中SQL显示出来有点问题,可以同时看下如下截图:
语法出错截图.png

回答 0
暂无回答
扫一扫
联系客服