Org. springframework. Dao. invaliddataaccessresourceusageexception: cocould not execute JDBC batch

It is a troublesome issue for hibernate to use MySQL in databases. At first glance, it must be considered that there is a problem with hql writing, but this is not the case.

... It is actually the keyword in the evil MySQL. Desc... As a MySQL keyword conflicts with fields in the database table, hql cannot be executed,

 

Org. springframework. dao. invaliddataaccessresourceusageexception: cocould not execute JDBC batch update; Nested exception is Org. hibernate. exception. sqlgrammarexception: cocould not execute JDBC batch update <br/> at Org. springframework. orm. hibernate3.sessionfactoryutils. converthibernateaccessexception (sessionfactoryutils. java: 630) <br/> at Org. springframework. orm. hibernate3.hibernatetransactionmanager. converthibernateaccessexception (hibernatetransactionmanager. java: 789) <br/> at Org. springframework. orm. hibernate3.hibernatetransactionmanager. docommit (hibernatetransactionmanager. java: 663) <br/> at Org. springframework. transaction. support. abstractplatformtransactionmanager. processcommit (abstractplatformtransactionmanager. java: 732) <br/> at Org. springframework. transaction. support. abstractplatformtransactionmanager. commit (abstractplatformtransactionmanager. java: 701) <br/> at Org. springframework. transaction. interceptor. transactionaspectsupport. committransactionafterreturning (transactionaspectsupport. java: 321) <br/> at Org. springframework. transaction. interceptor. transactioninterceptor. invoke (transactioninterceptor. java: 116) <br/> at Org. springframework. AOP. framework. reflectivemethodinvocation. proceed (reflectivemethodinvocation. java: 171) <br/> at Org. springframework. AOP. framework. jdkdynamicaopproxy. invoke (jdkdynamicaopproxy. java: 204) <br/> at $ proxy22.auditproductssuccessed (unknown source) <br/> at com. openb2c. PTG. platform. action. productandcategoryauditaction. passproductauditaction (productandcategoryauditaction. java: 116) <br/> at Sun. reflect. nativemethodaccessorimpl. invoke0 (native method) <br/> at Sun. reflect. nativemethodaccessorimpl. invoke (unknown source) <br/> at Sun. reflect. delegatingmethodaccessorimpl. invoke (unknown source) <br/> at java. lang. reflect. method. invoke (unknown source) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invokeaction (defaactionactioninvocation. java: 441) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invokeactiononly (defaactionactioninvocation. java: 280) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 243) <br/> at com. opensymphony. xwork2.interceptor. defaultworkflowinterceptor. dointercept (defaultworkflowinterceptor. java: 165) <br/> at com. opensymphony. xwork2.interceptor. methodfilterinterceptor. intercept (methodfilterinterceptor. java: 87) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.validator. validationinterceptor. dointercept (validationinterceptor. java: 252) <br/> at Org. apache. struts2.interceptor. validation. annotationvalidationinterceptor. dointercept (annotationvalidationinterceptor. java: 68) <br/> at com. opensymphony. xwork2.interceptor. methodfilterinterceptor. intercept (methodfilterinterceptor. java: 87) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.interceptor. conversionerrorinterceptor. intercept (conversionerrorinterceptor. java: 122) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.interceptor. parametersinterceptor. dointercept (parametersinterceptor. java: 195) <br/> at com. opensymphony. xwork2.interceptor. methodfilterinterceptor. intercept (methodfilterinterceptor. java: 87) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.interceptor. parametersinterceptor. dointercept (parametersinterceptor. java: 195) <br/> at com. opensymphony. xwork2.interceptor. methodfilterinterceptor. intercept (methodfilterinterceptor. java: 87) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.interceptor. staticparametersinterceptor. intercept (staticparametersinterceptor. java: 179) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at Org. apache. struts2.interceptor. multiselectinterceptor. intercept (multiselectinterceptor. java: 75) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at Org. apache. struts2.interceptor. checkboxinterceptor. intercept (checkboxinterceptor. java: 94) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at Org. apache. struts2.interceptor. fileuploadinterceptor. intercept (fileuploadinterceptor. java: 235) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.interceptor. modeldriveninterceptor. intercept (modeldriveninterceptor. java: 89) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.interceptor. scopedmodeldriveninterceptor. intercept (scopedmodeldriveninterceptor. java: 130) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at Org. apache. struts2.interceptor. debugging. debugginginterceptor. intercept (debugginginterceptor. java: 267) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.interceptor. chaininginterceptor. intercept (chaininginterceptor. java: 126) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.interceptor. prepareinterceptor. dointercept (prepareinterceptor. java: 138) <br/> at com. opensymphony. xwork2.interceptor. methodfilterinterceptor. intercept (methodfilterinterceptor. java: 87) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.interceptor. i18ninterceptor. intercept (i18ninterceptor. java: 165) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at Org. apache. struts2.interceptor. servletconfiginterceptor. intercept (servletconfiginterceptor. java: 164) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.interceptor. aliasinterceptor. intercept (aliasinterceptor. java: 179) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at com. opensymphony. xwork2.interceptor. predictionmappinginterceptor. intercept (exceptionmappinginterceptor. java: 176) <br/> at com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237) <br/> at org.apache.struts2.impl.strutsactionproxy.exe cute (strutsactionproxy. java: 52) <br/> at Org. apache. struts2.dispatcher. dispatcher. serviceaction (dispatcher. java: 488) <br/> at org.apache.struts2.dispatcher.ng.executeoperations.exe cuteaction (executeoperations. java: 77) <br/> at Org. apache. struts2.dispatcher. ng. filter. strutsprepareandexecutefilter. dofilter (strutsprepareandexecutefilter. java: 91) <br/> at Org. apache. catalina. core. applicationfilterchain. internaldofilter (applicationfilterchain. java: 235) <br/> at Org. apache. catalina. core. applicationfilterchain. dofilter (applicationfilterchain. java: 206) <br/> at Org. apache. catalina. core. standardwrappervalve. invoke (standardwrappervalve. java: 233) <br/> at Org. apache. catalina. core. standardcontextvalve. invoke (standardcontextvalve. java: 191) <br/> at Org. apache. catalina. core. standardhostvalve. invoke (standardhostvalve. java: 128) <br/> at Org. apache. catalina. valves. errorreportvalve. invoke (errorreportvalve. java: 102) <br/> at Org. apache. catalina. core. standardenginevalve. invoke (standardenginevalve. java: 109) <br/> at Org. apache. catalina. connector. coyoteadapter. service (coyoteadapter. java: 293) <br/> at Org. apache. coyote. http11.http11processor. process (http11processor. java: 849) <br/> at Org. apache. coyote. http11.http11protocol $ http11connectionhandler. process (http11protocol. java: 583) <br/> at org.apache.tomcat.util.net. jioendpoint $ worker. run (jioendpoint. java: 454) <br/> at java. lang. thread. run (unknown source) <br/> caused by: Org. hibernate. exception. sqlgrammarexception: cocould not execute JDBC batch update <br/> at Org. hibernate. exception. sqlstateconverter. convert (sqlstateconverter. java: 92) <br/> at Org. hibernate. exception. jdbcexceptionhelper. convert (jdbcexceptionhelper. java: 66) <br/> at org.hibernate.jdbc.?actbatcher.exe cutebatch (abstractbatcher. java: 275) <br/> at org.hibernate.engine.actionqueue.exe cuteactions (actionqueue. java: 268) <br/> at org.hibernate.engine.actionqueue.exe cuteactions (actionqueue. java: 185) <br/> at Org. hibernate. event. def. abstractflushingeventlistener. extends mexecutions (abstractflushingeventlistener. java: 321) <br/> at Org. hibernate. event. def. defaultflusheventlistener. onflush (defaflusheventlistener. java: 51) <br/> at Org. hibernate. impl. sessionimpl. flush (sessionimpl. java: 1216) <br/> at Org. hibernate. impl. sessionimpl. managedflush (sessionimpl. java: 383) <br/> at Org. hibernate. transaction. jdbctransaction. commit (jdbctransaction. java: 133) <br/> at Org. springframework. orm. hibernate3.hibernatetransactionmanager. docommit (hibernatetransactionmanager. java: 655) <br/>... 73 more <br/> caused by: Java. SQL. batchupdateexception: 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 'desc = 'cloghof jyymv54hyrebrj has timed out' at line 1 <br/> at least cutebatchserially (preparedstatement. java: 1666) <br/> at com.mysql.jdbc.preparedstatement.exe cutebatch (preparedstatement. java: 1082) <br/> at com.mchange.v2.c31_impl.newproxypreparedstatement.exe cutebatch (newproxypreparedstatement. java: 1723) <br/> at Org. hibernate. JDBC. batchingbatcher. doexecutebatch (batchingbatcher. java: 70) <br/> at org.hibernate.jdbc.?actbatcher.exe cutebatch (abstractbatcher. java: 268) <br/>... 81 more 

Solution: If hibernate annotation is used, add ''To the object class set method, that is, the key on the tab button.

'Desc'; the key is.