首页 / MYSQL / Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含9756字，纯文字阅读大概需要14分钟。

内容图文

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘ at line 1
### The error may involve com.qingmu.core.dao.good.BrandDao.insertSelective-Inline
### The error occurred while setting parameters
### SQL: insert into tb_brand
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘ at line 1
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘ at line 1, dubbo version: 2.8.4, current host: 127.0.0.1
org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘ at line 1
### The error may involve com.qingmu.core.dao.good.BrandDao.insertSelective-Inline
### The error occurred while setting parameters
### SQL: insert into tb_brand
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘ at line 1
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘ at line 1
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
    at com.sun.proxy.$Proxy11.insert(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:240)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:51)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
    at com.sun.proxy.$Proxy13.insertSelective(Unknown Source)
    at com.qingmu.core.service.BrandServiceImpl.add(BrandServiceImpl.java:64)
    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:302)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    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: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.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
    at com.sun.proxy.$Proxy18.add(Unknown Source)
    at com.alibaba.dubbo.common.bytecode.Wrapper0.invokeMethod(Wrapper0.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:70)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
    at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:132)
    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:113)
    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:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘ at line 1
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2826)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302)
    at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
    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.PreparedStatementLogger.invoke(PreparedStatementLogger.java:62)
    at com.sun.proxy.$Proxy26.execute(Unknown Source)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)
    at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)
    at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)
    at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)
    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.Plugin.invoke(Plugin.java:62)
    at com.sun.proxy.$Proxy24.update(Unknown Source)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(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:358)
    ... 47 more

由于我的sql语句是使用逆向工程生成的,然后sql语句拼写错误,就可以省略,

找到的原因是在页面想后端发送数据的时候,是以json格式进行传输的,然后没有解析,想直接存入到数据库中,

报出来的sql语句异常

技术分享图片

原文：https://www.cnblogs.com/qingmuchuanqi48/p/10671114.html

内容总结

以上是互联网集市为您收集整理的Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:全部内容，希望文章能够帮你解决Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/1310571.html

来源：【匿名】

【上一篇】MySQL存储引擎【下一篇】用IE远程创建Mysql数据库的简易程序

更多 ►

【Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:】教程文章相关的互联网学习教程文章

System.TypeInitializationException: 'The type initializer for 'MySql.Data.MySqlClient.Replication.ReplicationManager' threw an exception.'

下午在调试的时候报错数据库连接就报错我就很纳闷后面用原来的代码写发现还是报错System.TypeInitializationException: ‘The type initializer for ‘MySql.Data.MySqlClient.Replication.ReplicationManager‘ threw an exception.‘应该是出在Mysql包上的问题但是我发现更换版本也不行我就尝试着打开mysql到自己数据库看看回来之后调试又成功了，之后问题又出现过1次但是同样打开数据库就解决了很奇怪。- 之后的一星期左右到是...

mysql-PHP中PDO的错误模式,ERRMODE_EXCEPTION和ERRMODE_WARNING区别是什么?

PDO::ERRMODE_EXCEPTION PDO::ERRMODE_WARNING 区别是什么? 我怎么看了以后,觉得这俩除了反馈信息的格式不一样外,别的看起来都一样? 就是讲解的时候有个"抛出"一词,谁可以简单的跟我说说什么区别?回复内容：PDO::ERRMODE_EXCEPTION PDO::ERRMODE_WARNING 区别是什么? 我怎么看了以后,觉得这俩除了反馈信息的格式不一样外,别的看起来都一样? 就是讲解的时候有个"抛出"一词,谁可以简单的跟我说说什么区别?错误模式说明: 异常模式:$pd...

mysql连接不上Uncaught exception 'PDOException' with message 'could not find driver

打开PHP.INI 把extension=php_pdo.dll 前面的分号去掉重启APACHE。extension=php_pdo_mysql.dllmysql连接不上Uncaught exception PDOException with message could not find driver标签：本文系统来源：http://www.cnblogs.com/XACOOL/p/5416175.html

nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai【代码】【图】

通过查找资料，可能是wait_timeout设置过小导致的，尝试加大wait_timeout的值后，系统恢复正常。更改过程如下：##查看MySQL配置 root@localhost:mysql.sock [finance]>show global variables like ‘wait_timeout‘; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 10 | +---------------+-------+ 1 row in set (0.01 sec)root@localhost:mysql.sock [finance]>show glo...

java.lang.Exception: 资源处理失败，失败原因：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '?????‰' in 'where clause'【代码】

1 TbUser.USER_NO.name + " = " + "\‘" + userNo + "\‘" ;也许看不懂，哈哈，公司自己封装的，没关系，解决这个错误的关键在于+ "\‘" + userNo + "\‘" ;这句话，将自己传过来的动态值替换到userNo 即可。java.lang.Exception: 资源处理失败，失败原因：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ?????‰ in where clause标签：nta 自己原因 java lang gpo 拼接 perm post ...

Execution default-cli of goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2:generate failed: Exception getting JDBC Driver: com.mysql.jdbc.Driver （mybatis逆向工程）

plugin><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-maven-plugin</artifactId><version>1.3.2</version><configuration><configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile><overwrite>true</overwrite><verbose>true</verbose></configuration><dependencies><dependency><groupId>mysql</groupId><artifactId>mysql-conn...

Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionExcep linux下mysql修改连接超时wait_timeout修改后就ok了

mysql死锁com.mysql.cj.jdbc.exception.MYSQLTransactionRollbackException Deadlock found when trying to get lock;try restarting transaction【图】

1.生产环境出现以下报错该错误发生在update操作中，该表并未建立索引，也就是只有InnoDB默认的主键索引，发生错误的程序是for循环中update。什么情况下会出现Deadlock found when trying to get lock？ https://dev.mysql.com/doc/refman/5.6/en/innodb-deadlocks.html 出现死锁需要两个条件： 1）至少2个客户端（a,b）同时在执行事务 2)客户端a锁定了某一行，未提交事务，此时客户端b也需要update/delete这一行，此时客户端b就...

oracle10g+win7安装oracle10g报错java.lang.Exception:【图】

oracle10g win 7 安装 oracle 10g 登录em后，提示java.lang.Exception: Exception in sending Request :: null （1）找到oracle安装目录下的db_1中的XXX_orcl类型的文件下面的sysman里面的config中的emd.properties文件，将agentTZRegion=GMT改成agentTZRegiooracle10g win 7 安装 oracle 10g 登录em后，提示java.lang.Exception: Exception in sending Request :: null （1）找到oracle安装目录下的db_1中的XXX_orcl类型的文件下面...

Oraclepragma举例：exception_init【图】

PRAGMA是一个编译指示(或命令)。编译指示在编译时被处理，它们不在运行时执行。编译指示是对编译程序发出的特殊指令。它也称为伪 PRAGMA是一个编译指示(或命令)。编译指示在编译时被处理，它们不在运行时执行。编译指示是对编译程序发出的特殊指令。它也称为伪指令（pseudoinstruction），不会改变程序的含义。它只是向编译程序传递信息，实际上它是非常类似于嵌在 SQL 语句的注释中的性能调整提示。 EXCEPTION_INIT：将一个特定的...

Oraclepragma举例:exception_init()【图】

PRAGMA EXCEPTION_INIT(DEADLOCK_DETECTED, -60);EXCEPTION_INIT编译指令，从字面意思上我们能了解一点，即EXCEPTION的初始化。 PRAGMA EXCEPTION_INIT(DEADLOCK_DETECTED, -60); EXCEPTION_INIT编译指令，从字面意思上我们能了解一点，即EXCEPTION的初始化。语法也简单，PRAGMA EXCEPTION (exception_name, error_number); 大家都有经验，在处理EXCEPTION 是，当没有已经定义好了的EXCEPTION NAME可用时，我们就用OTHERS来处理...

OraclePL/SQL之EXCEPTION--WHENOTHERSTHEN【图】

在处理EXCEPTION时应特别注意WHEN OTHERS THEN的使用，因为WHEN OTHERS THEN会吃掉所有的EXCEPTION。如果在WHEN OTHERS THEN后不在处理EXCEPTION时应特别注意WHEN OTHERS THEN的使用，因为WHEN OTHERS THEN会吃掉所有的EXCEPTION。如果在WHEN OTHERS THEN后不抛出任何信息，即：WHEN OTHERS THEN NULL; 这可能会极大地增加以后程序排错的难度，因为即使出错了，也没有任何提示。所以我们需要特别留意WHEN OTHERS THEN，除了一个一...

connection-Connectionhasbeenabandoned:java.lang.Exception

connectionmysqljavadbcpexception 使用的DBCP连接池和Mysql数据库，偶尔会出现这种异常，不知是什么导致的，并且在出现这个异常的地方进行对Exception的catch，但是奇怪的时捕获不了这种异常，异常一直被传回虚拟机然后打印，请哪位大侠指导一下，具体的异常如下警告: Connection has been abandoned PooledConnection[com.mysql.jdbc.Connection@517667bd]:java.lang.Exception at org.apache.tom...

Exception in thread “main“ com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException已解决！【代码】【图】

问题描述：使用Java连接数据库出现错误： com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at 。。。。。 Caused by: java.lang....

mysql死锁com.mysql.cj.jdbc.exception.MYSQLTransactionRollbackException Deadlock found when trying to g【图】

首页 / MYSQL / Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

内容导读

内容图文

内容总结

内容备注

内容手机端

【Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:】教程文章相关的互联网学习教程文章

JDBC - 相关标签

MYSQL - 技术教程分类

MYSQL - 最新教程

MYSQL - 最热教程