org.springframework.jdbc.BadSqlGrammarException:syntax error at end of input

最新推荐文章于 2024-08-17 16:13:51 发布
原创 最新推荐文章于 2024-08-17 16:13:51 发布 · 739 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#java #数据库

博客主要围绕Java数据库操作展开，指出报错原因是传入的list集合为空，解决办法是在调用相关sql之前先判断list集合是否为空，为Java数据库操作中遇到的此类问题提供了解决思路。

在这里插入图片描述
在这里插入图片描述

报错原因

传入的list集合为空

解决办法

在调用这个sql之前先判断list集合是否为空

com.kingbase8.util.KSQLException: ERROR: permission denied for table xxx
寂夜了无痕的博客
09-18 2846
com.kingbase8.util.KSQLException: ERROR: permission denied for table xxx
六、流行框架介绍(SpringBoot框架详解(含底层原理介绍，适用于springBoot1.x和springBoot2.x,属于通用版本))
kejizhentan的博客
04-07 9382
一、SpringBoot的概述 1.简介 Spring Boot 是 Pivotal 团队在 Spring 的基础上提供的一套全新的开源框架，其目的是为了简化 Spring 应用的搭建和开发过程。Spring Boot 去除了大量的 XML 配置文件，简化了复杂的依赖管理。 Spring Boot 具有 Spring 一切优秀特性，Spring 能做的事，Spring Boot 都可以做，而且使用更加简单，功能更加丰富，性能更加稳定而健壮。随着近些年来微服务技术的流行，Spring Boot 也成了时下炙手
mysql syntax error at end of input
彭于晏的博客
12-03 6653
select exists ( select 1 from ( select ssrs.isenabled,ssi.skcode,ssi.shopcode from set_syn_relation_shop ssrs inner join set_shop_info ssi on ssrs.shopcode=ssi.shopcode) total where total.shopcode='SI00000670' and total.skcode='SK00000287' and total.isenab
Cause: org.postgresql.util.PSQLException: ERROR: syntax error at end of input
weixin_45427945的博客
07-11 1万+
Cause: org.postgresql.util.PSQLException: ERROR: syntax error at end of input
低级sql语法错误: BadSqlGrammarException
weixin_30551947的博客
07-06 6123
低级sql语法错误: BadSqlGrammarException at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:760) at org.springframework.boot.SpringApplicat...
error: SyntaxError: Unexpected end of input 报错
weixin_42578963的博客
01-03 6867
"SyntaxError: Unexpected end of input" 这个错误通常是因为你在编写代码时缺少了一个括号、分号或其他语法符号。这可能是因为你忘记在一个字符串、函数调用或者其他语句中关闭了一个括号。 例如，如果你有这样的代码： print("Hello, world!) 那么你会看到 "SyntaxError: Unexpected end of input" 错误。这是因为你...
Install fail! SyntaxError: Unexpected end of JSON input
Dear欢儿欢的博客
03-10 10000
没错，还是今天，在运行1另外一个项目执行cnpm install时遇到这个问题： 不要惊慌，让我们重新安装一下就好了。 1.首先 执行一下命令清理缓存：cnpm cache clean --force 2.其次 当出现如下提示说明你清理成功了 3.然后呢 删除已经安装的node_modules，然后重新:cnpm install OK，完成！ 最后的最后：写文章不容易啊，...
org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: com.kingbase8.util.KSQLException: ERROR: syntax error at end of input Position: 175 At Line: 16, Line Position: 20 ### The error may exist in file [D:\tools\env\合法合规\apache-tomcat-8.5.96\apache-tomcat-8.5.96\webapps\nidp-web\WEB-INF\classes\com\dhc\nidp\legalCompliance\legalProceUpload\repo\LcpCommonProjInfoMapper.xml] ### The error may involve com.dhc.nidp.legalCompliance.legalProceUpload.repo.LcpCommonProjInfoRepo.updateCommonPro-Inline ### The error occurred while setting parameters ### SQL: UPDATE common_proj_info set LCP_TYPE = ?, IS_HISTORY_PRO = ?, MODIFY_BY = ?, MODIFY_STAFF_NAME = ?, MODIFY_DATE = ?, ### Cause: com.kingbase8.util.KSQLException: ERROR: syntax error at end of input Position: 175 At Line: 16, Line Position: 20 ; bad SQL grammar []; nested exception is com.kingbase8.util.KSQLException: ERROR: syntax error at end of input Position: 175 At Line: 16, Line Position: 20 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) 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:75) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447) at com.sun.proxy.$Proxy39.update(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:295) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:67) 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.$Proxy108.updateCommonPro(Unknown Source) at com.dhc.nidp.legalCompliance.legalProceUpload.as.ProceUpAS.doChangeHistoryData(ProceUpAS.java:149) at com.dhc.nidp.legalCompliance.legalProceUpload.as.ProceUpAS$$FastClassBySpringCGLIB$$9f03d212.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 org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673) at com.dhc.nidp.legalCompliance.legalProceUpload.as.ProceUpAS$$EnhancerBySpringCGLIB$$4375b649.doChangeHistoryData(<generated>) at com.dhc.nidp.legalCompliance.legalProceUpload.as.ProceUpAS$$FastClassBySpringCGLIB$$9f03d212.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
07-31
在使用 Kingbase 数据库执行 SQL 的 `UPDATE` 操作时，若出现 `BadSqlGrammarException` 异常，并提示 `syntax error at end of input`，通常是由于 SQL 语句存在语法错误或结构不完整导致的。以下为常见原因及解决...
上述问题，重写了AbstractEngineConfiguration类，在getDefaultDatabaseTypeMappings方法添加了KingbaseES，打包运行后报2025-10-21 10:46:10.986 [main] [WARN] liquibase.database: - Unknown database: KingbaseES 2025-10-21 10:46:11.289 [main] [ERROR] druid.sql.Statement: - {conn-10005, cstmt-20001} execute error. call current_schema com.kingbase8.util.KSQLException: ERROR: syntax error at end of input Position: 20 At Line: 1, Line Position: 20 at com.kingbase8.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:3551) at com.kingbase8.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2993) at com.kingbase8.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405) at com.kingbase8.jdbc.KbStatement.executeInternal_(KbStatement.java:784) at com.kingbase8.jdbc.KbStatement.execute(KbStatement.java:676) at com.kingbase8.jdbc.KbPreparedStatement.executeWithFlags(KbPreparedStatement.java:286) at com.kingbase8.jdbc.KbCallableStatement.executeWithFlags(KbCallableStatement.java:258) at com.kingbase8.jdbc.KbPreparedStatement.executeQuery(KbPreparedStatement.java:181) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3241) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:459) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3238) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:459) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3238) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:175) at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:213) at liquibase.executor.jvm.JdbcExecutor$QueryCallableStatementCallback.doInCallableStatement(JdbcExecutor.java:494) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:118) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:160) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:171) at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:179) at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:194) at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:189) at liquibase.database.AbstractJdbcDatabase.getConnectionSchemaName(AbstractJdbcDatabase.java:365) at liquibase.database.AbstractJdbcDatabase.getDefaultSchemaName(AbstractJdbcDatabase.java:325) at liquibase.changelog.ChangeLogParameters.<init>(ChangeLogParameters.java:61) at liquibase.Liquibase.<init>(Liquibase.java:119) at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.createLiquibaseInstance(LiquibaseBasedSchemaManager.java:189) at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.schemaCheckVersion(LiquibaseBasedSchemaManager.java:140) at liquibase.Scope.lambda$child$0(Scope.java:177) at liquibase.Scope.child(Scope.java:186) at liquibase.Scope.child(Scope.java:176) at liquibase.Scope.child(Scope.java:155) at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.runForLiquibase(LiquibaseBasedSchemaManager.java:93) at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.initSchema(LiquibaseBasedSchemaManager.java:84) at org.flowable.eventregistry.impl.db.EventDbSchemaManager.initSchema(EventDbSchemaManager.java:36) at org.flowable.eventregistry.impl.cmd.SchemaOperationsEventRegistryEngineBuild.execute(SchemaOperationsEventRegistryEngineBuild.java:29) at org.flowable.eventregistry.impl.cmd.SchemaOperationsEventRegistryEngineBuild.execute(SchemaOperationsEventRegistryEngineBuild.java:24) at org.flowable.common.engine.impl.interceptor.DefaultCommandInvoker.execute(DefaultCommandInvoker.java:22) at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53) at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:105) at org.flowable.common.spring.SpringTransactionInterceptor.lambda$execute$0(SpringTransactionInterceptor.java:57) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:57) at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56) at org.flowable.eventregistry.impl.EventRegistryEngineImpl.<init>(EventRegistryEngineImpl.java:47) at org.flowable.eventregistry.impl.EventRegistryEngineConfiguration.buildEventRegistryEngine(EventRegistryEngineConfiguration.java:208) at org.flowable.eventregistry.spring.SpringEventRegistryEngineConfiguration.buildEventRegistryEngine(SpringEventRegistryEngineConfiguration.java:73) at org.flowable.eventregistry.spring.configurator.SpringEventRegistryConfigurator.initEventRegistryEngine(SpringEventRegistryConfigurator.java:57) at org.flowable.eventregistry.spring.configurator.SpringEventRegistryConfigurator.configure(SpringEventRegistryConfigurator.java:47) at org.flowable.common.engine.impl.AbstractEngineConfiguration.configuratorsAfterInit(AbstractEngineConfiguration.java:1004) at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:1022) at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:906) at org.flowable.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:76) at org.flowable.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:59) at org.flowable.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:169) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1884) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1284) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:345) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:541) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1389) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1309) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:953) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:740) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:415) at org.springframework.boot.SpringApplication.run(SpringApplication.java:303) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1312) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1301) at com.somap.SomapApplication.main(SomapApplication.java:42) 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.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) 2025-10-21 10:46:11.293 [main] liquibase.database: - Error getting default schema liquibase.exception.DatabaseException: Error executing SQL call current_schema: ERROR: syntax error at end of input
最新发布
10-22
根据引用[4]提供的错误信息，我们知道KingbaseES在遇到外键约束问题时会有特定的错误提示，但目前用户遇到的错误是语法错误（syntax error at end of input）和未知数据库类型。 分析步骤： 1. **Unknown database...
org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "[" 位置: 95 ### The error may exist in file [D:\SY22BNEC31\03_PJ開発_密\0306_SourceStep3\item-tag-information-api-sana-application\bin\main\jp\co\sej\ssc\an\Sana0817MP001.xml] ### The error may involve jp.co.sej.ssc.an.SANA0817SelectItemTagList-Inline ### The error occurred while setting parameters ### SQL: WITH v_item_tag_info(item_tag_code, employee_number) AS ( VALUES [ (?, ?) ] ) SELECT T01.item_tag_code AS item_tag_code ,T01.employee_number AS employee_number ,T01.item_tag_name AS item_tag_name ,T01.item_tag_type AS item_tag_type ,T01.item_tag_priority_display_flag AS item_tag_priority_display_flag ,T01.long_term_preservation_flag AS long_term_preservation_flag ,T01.order_display_start_date AS order_display_start_date ,'0' AS list_create_flag ,T02.new_arrival_flag AS new_arrival_flag ,CASE WHEN '2024-01-16' BETWEEN T01.order_display_start_date AND T01.order_display_end_date THEN '1' WHEN '2024-01-16' < T01.order_display_start_date THEN '2' ELSE '3' END AS sort_key FROM m_item_tag T01 -- 商品タグマスタ LEFT OUTER JOIN m_item_tag_details_per_person T02 ON T02.original_store_code = '123456' AND T01.item_tag_code = T02.item_tag_code AND T01.employee_number = T02.employee_number INNER JOIN v_item_tag_info T03 --商品タグ検索条件マスタ ON T01.item_tag_code = T03.item_tag_code AND T01.employee_number = T03.employee_number WHERE T01.original_store_code = '123456' ORDER BY sort_key ASC, T02.new_arrival_flag DESC, T01.item_tag_priority_display_flag DESC, T01.order_display_start_date DESC, T01.item_tag_input_datetime DESC, T01.item_tag_type ASC, T01.item_tag_code ASC ### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "[" 位置: 95 ; bad SQL grammar []
10-16
org.mybatis: DEBUG ``` --- ## **总结** - **根本原因**：PostgreSQL 不支持 `VALUES` 子句中的方括号 `[]`，只支持圆括号 `()`。 - **解决方案**： 1. 将 `[ (?, ?) ]` 改为 `( ?, ? )`。 2. 如果有多行数据...
SyntaxError: Unexpected end of input的解决方案
2301_79779756的博客
08-17 2069
SyntaxError: Unexpected end of input 错误通常由于缺少闭合括号、引号、字符串或模板字面量未闭合、控制流结构不完整或文件截断等原因引起。通过检查和修正这些问题，可以有效解决此错误。
BadSqlGrammarException
Alon__的博客
12-30 2624
【SQL问题】SQLSyntaxErrorException 故障解决方式 在DaoImpl层加上@DataSource注释 @DataSource(DatasourceConstant.PAYMENT) 故障环境介绍 项目 描述 数据库类型 mysql 框架 spring boot 问题范围 多数据源问题 故障发生现象及报错信息 org.springframew...
org.springframework.jdbc.BadSqlGrammarException:
pelosp的博客
12-06 6211
org.springframework.jdbc.BadSqlGrammarException:
报错：org.springframework.jdbc.BadSqlGrammarException:
Mmj_mmj的博客
02-24 7381
2024-02-24 19:44:10.814 ERROR 6184 --- [nio-9090-exec-5] c.e.exception.GlobalExceptionHandler : 异常信息： org.springframework.jdbc.BadSqlGrammarException:
org.springframework.jdbc.BadSqlGrammarException
an74520的专栏
06-14 445
org.springframework.jdbc.BadSqlGrammarException
BadSqlGrammarException，sql语法错误问题
Yingtaozi_0的博客
03-20 707
获取某列表时报错：org.spring framework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: Java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax;排查原因，发现实体类属性名group为sql关键字，导致查询时候该字段作为语法中的group了，而不是对应表字段，故重命名实体类属性名即可。
错误日志(.BadSqlGrammarException：错误的sql参数异常，明明参数和表中数据都对应上了，其实很简单的错误，秒解决)...
庭前云落的博客
12-17 1万+
nested exception is org.springframework.jdbc.BadSqlGrammarException 错误的sql参数异常，明明参数...
解决bad SQL grammar []； nested exception is java.sql.SQLSyntaxErrorException
热门推荐
qq_47450919的博客
01-10 1万+
在使用Spring Boot连接MySQL数据库时，有时候会遇到“Bad SQL Grammar”错误，这种错误通常在执行SQL语句时发生。本文针对的是对于执行多条SQL语句的情况。
org.springframework.jdbc.BadSqlGrammarException： Cause:org.postgresql.util.PSQLExtion:ERROR
04-10
好的，我现在需要处理用户关于org.springframework.jdbc.BadSqlGrammarException异常的问题，特别是使用PostgreSQL时的错误。首先，我应该回忆一下这个异常的一般原因，然后结合用户提供的引用信息，分析可能的情况...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值