org.hibernate.exception.SQLGrammarException:

最新推荐文章于 2021-06-30 10:35:53 发布
麦兜南宫
最新推荐文章于 2021-06-30 10:35:53 发布
阅读量4.1k
点赞数
分类专栏： play MySQL数据库
本文链接：https://blog.csdn.net/yanlici1249075710/article/details/93191943
版权
play 同时被 2 个专栏收录
11 篇文章 0 订阅
订阅专栏
MySQL数据库
4 篇文章 0 订阅
订阅专栏
play.exceptions.JavaExecutionException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
        at play.mvc.ActionInvoker.invoke(ActionInvoker.java:242)
        at play.server.PlayHandler$NettyInvocation.execute(PlayHandler.java:237)
        at play.Invoker$Invocation.run(Invoker.java:264)
        at play.server.PlayHandler$NettyInvocation.run(PlayHandler.java:217)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
        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: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214)
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147)
        at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1224)
        at org.hibernate.ejb.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:108)
        at jobtobp.ConsumerSecnicJobToBp.updateModifyTempData(ConsumerSecnicJobToBp.java:301)
        at jobtobp.ConsumerSecnicJobToBp.handleScenicList(ConsumerSecnicJobToBp.java:116)
        at jobtobp.ConsumerSecnicJobToBp.ConsumerSecnicData(ConsumerSecnicJobToBp.java:79)
        at jobtobp.GetSecnicJobToBp.getSecnicData(GetSecnicJobToBp.java:65)
        at controllers.remote.tongcheng.OrderIDAction.queryIdProGoodsSku(OrderIDAction.java:44)
        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 play.mvc.ActionInvoker.invokeWithContinuation(ActionInvoker.java:750)
        at play.mvc.ActionInvoker.invoke(ActionInvoker.java:708)
        at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:684)
        at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:679)
        at play.mvc.ActionInvoker.invoke(ActionInvoker.java:172)
        ... 10 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:219)
        at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
        at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396)
        at org.hibernate.ejb.QueryImpl.internalExecuteUpdate(QueryImpl.java:188)
        at org.hibernate.ejb.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:99)
        ... 24 more
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 'INSERT INTO `tc_lv_scenic_temp` (`id`,`scenic_id`,`scenic_name`,`scenic_level`,`' 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:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:210)
        ... 28 more

play.exceptions.JavaExecutionException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
        at play.mvc.ActionInvoker.invoke(ActionInvoker.java:242)
        at play.server.PlayHandler$NettyInvocation.execute(PlayHandler.java:237)
        at play.Invoker$Invocation.run(Invoker.java:264)
        at play.server.PlayHandler$NettyInvocation.run(PlayHandler.java:217)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
        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: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214)
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147)
        at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1224)
        at org.hibernate.ejb.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:108)
        at jobtobp.ConsumerSecnicJobToBp.updateModifyTempData(ConsumerSecnicJobToBp.java:301)
        at jobtobp.ConsumerSecnicJobToBp.handleScenicList(ConsumerSecnicJobToBp.java:116)
        at jobtobp.ConsumerSecnicJobToBp.ConsumerSecnicData(ConsumerSecnicJobToBp.java:79)
        at jobtobp.GetSecnicJobToBp.getSecnicData(GetSecnicJobToBp.java:65)
        at controllers.remote.tongcheng.OrderIDAction.queryIdProGoodsSku(OrderIDAction.java:44)
        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 play.mvc.ActionInvoker.invokeWithContinuation(ActionInvoker.java:750)
        at play.mvc.ActionInvoker.invoke(ActionInvoker.java:708)
        at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:684)
        at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:679)
        at play.mvc.ActionInvoker.invoke(ActionInvoker.java:172)
        ... 10 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:219)
        at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
        at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396)
        at org.hibernate.ejb.QueryImpl.internalExecuteUpdate(QueryImpl.java:188)
        at org.hibernate.ejb.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:99)
        ... 24 more
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 'INSERT INTO `tc_lv_scenic_temp` (`id`,`scenic_id`,`scenic_name`,`scenic_level`,`' 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:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:210)
        ... 28 more
2019-06-20 11:17:52,498 ERROR ~ getTicketProductDetail ---1
2019-06-20 11:17:52,502 ERROR ~ getTicketProductDetail ---2
2019-06-20 11:17:52,504 ERROR ~ getTicketProductDetail ---3
2019-06-20 11:17:52,506 ERROR ~ getTicketProductDetail ---4
2019-06-20 11:17:52,507 ERROR ~ getTicketProductDetail ---5
2019-06-20 11:17:52,509 ERROR ~ getTicketProductDetail ---6
2019-06-20 11:17:52,510 ERROR ~ getTicketProductDetail ---7
2019-06-20 11:17:52,511 ERROR ~ getTicketProductDetail ---8
2019-06-20 11:17:52,513 ERROR ~ getTicketProductDetail ---9
2019-06-20 11:17:52,518 ERROR ~ getTicketProductDetail ---10
2019-06-20 11:17:52,522 ERROR ~ getTicketProductDetail ---11
2019-06-20 11:17:52,169 ERROR ~ 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 'INSERT INTO `tc_lv_scenic_temp` (`id`,`scenic_id`,`scenic_name`,`scenic_level`,`' at line 1
2019-06-20 11:17:52,173 ERROR ~ Internal Server Error (500) for request GET /travel/interface/tongcheng/getThreadGoodsSku?productId=283
play.exceptions.JavaExecutionException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
        at play.mvc.ActionInvoker.invoke(ActionInvoker.java:242)
        at play.server.PlayHandler$NettyInvocation.execute(PlayHandler.java:237)
        at play.Invoker$Invocation.run(Invoker.java:264)
        at play.server.PlayHandler$NettyInvocation.run(PlayHandler.java:217)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
        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: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214)
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147)
        at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1224)
        at org.hibernate.ejb.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:108)
        at jobtobp.ConsumerSecnicJobToBp.updateModifyTempData(ConsumerSecnicJobToBp.java:301)
        at jobtobp.ConsumerSecnicJobToBp.handleScenicList(ConsumerSecnicJobToBp.java:116)
        at jobtobp.ConsumerSecnicJobToBp.ConsumerSecnicData(ConsumerSecnicJobToBp.java:79)
        at jobtobp.GetSecnicJobToBp.getSecnicData(GetSecnicJobToBp.java:65)
        at controllers.remote.tongcheng.OrderIDAction.queryIdProGoodsSku(OrderIDAction.java:44)
        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 play.mvc.ActionInvoker.invokeWithContinuation(ActionInvoker.java:750)
        at play.mvc.ActionInvoker.invoke(ActionInvoker.java:708)
        at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:684)
        at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:679)
        at play.mvc.ActionInvoker.invoke(ActionInvoker.java:172)
        ... 10 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:219)
        at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
        at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396)
        at org.hibernate.ejb.QueryImpl.internalExecuteUpdate(QueryImpl.java:188)
        at org.hibernate.ejb.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:99)
        ... 24 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your My
这个原因是因为使用play用的jpa中sql语句中多了一个逗号
麦兜南宫
关注
0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
org.hibernate.exception.SQLGrammarException:

play.exceptions.JavaExecutionException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query at play.mvc.ActionInvoker.invoke(ActionInvoker.java:242)...
复制链接

扫一扫
专栏目录