org.hibernate.exception.SQLGrammarException: could not execute query

openxava | fzerpaperez | 2 years ago
  1. 0

    Problema @Stereotype("GALERIA_IMAGENES") en MySQL

    openxava | 2 years ago | fzerpaperez
    org.hibernate.exception.SQLGrammarException: could not execute query
  2. 0

    Exception on trying to run the new ODE with MYSQL DB

    ode-user | 8 years ago | Rosalin Pattnaik
    org.hibernate.exception.SQLGrammarException: could not execute query
  3. 0

    Please help! java.lang.OutOfMemoryError: Perm, memory leak? - Forums | Liferay

    liferay.com | 8 months ago
    org.hibernate.exception.SQLGrammarException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When executing a "previous month" query I get an internal error page. Attached find stack trace from ehour.log. I've also attached a screenshot with my query options. ehour 7.3 mysql 5.0 jdk 1.5 05-01@08:35:23 WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1064, SQLState: 42000 05-01@08:35:23 ERROR org.hibernate.util.JDBCExceptionReporter - 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 ') AND (ENTRY.ENTRY_DATE >= '2008-04-01' AND ENTRY.ENTRY_DATE <=' at line 25 05-01@08:35:23 ERROR org.apache.wicket.RequestCycle - could not execute query org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2223) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152) at net.rrm.ehour.report.dao.DetailedReportDAOHibernateImpl.getHoursPerDayForProjects(DetailedReportDAOHibernateImpl.java:159) at net.rrm.ehour.report.service.DetailedReportServiceImpl.getDetailedReportData(DetailedReportServiceImpl.java:78) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy7.getDetailedReportData(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.wicket.proxy.LazyInitProxyFactory$JdkHandler.invoke(LazyInitProxyFactory.java:416) at org.apache.wicket.proxy.$Proxy189.getDetailedReportData(Unknown Source) at net.rrm.ehour.ui.page.report.global.GlobalReportPage.getDetailedReportData(GlobalReportPage.java:298) at net.rrm.ehour.ui.page.report.global.GlobalReportPage.addDetailedReportPanelTabs(GlobalReportPage.java:192) at net.rrm.ehour.ui.page.report.global.GlobalReportPage.ajaxRequestReceived(GlobalReportPage.java:117) at net.rrm.ehour.ui.page.BasePage.ajaxRequestReceived(BasePage.java:103) at net.rrm.ehour.ui.panel.report.criteria.ReportCriteriaPanel$6.onSubmit(ReportCriteriaPanel.java:348) at org.apache.wicket.ajax.markup.html.form.AjaxButton$1.onSubmit(AjaxButton.java:86) at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:129) at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:161) at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:288) at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:100) at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:90) at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1094) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1169) at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1245) at org.apache.wicket.RequestCycle.request(RequestCycle.java:489) at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:354) at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:194) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:482) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:595) Caused by: com.mysql.jdbc.exceptions.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 ') AND (ENTRY.ENTRY_DATE >= '2008-04-01' AND ENTRY.ENTRY_DATE <=' at line 25 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220)

    eHour JIRA | 9 years ago | Will Glass
    org.hibernate.exception.SQLGrammarException: could not execute query
  6. 0

    database - quartz - issue in 5.1 - Forums | Liferay

    liferay.com | 7 months ago
    org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Table 'lportal.quartz_triggers' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lportal.quartz_triggers' doesn't exist]]

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException

      Table 'bdudeporte.images' doesn't exist

      at com.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      PreparedStatement.executeQuery
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
      3. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
      4. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
      5. com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
      6. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
      7. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
      7 frames
    3. org.apache.tomcat
      DelegatingPreparedStatement.executeQuery
      1. org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      2. org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      2 frames
    4. Hibernate
      QueryLoader.list
      1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
      2. org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
      3. org.hibernate.loader.Loader.doQuery(Loader.java:802)
      4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
      5. org.hibernate.loader.Loader.doList(Loader.java:2542)
      6. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
      7. org.hibernate.loader.Loader.list(Loader.java:2271)
      8. org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
      8 frames
    5. Hibernate HQL/JP-QL Parser
      QueryTranslatorImpl.list
      1. org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
      1 frame
    6. Hibernate
      QueryImpl.list
      1. org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
      2. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
      3. org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
      3 frames
    7. org.openxava.session
      Gallery.loadAllImages
      1. org.openxava.session.Gallery.loadAllImages(Gallery.java:33)
      1 frame
    8. org.openxava.actions
      EditGalleryAction.execute
      1. org.openxava.actions.EditGalleryAction.execute(EditGalleryAction.java:48)
      1 frame
    9. org.openxava.controller
      ModuleManager.execute
      1. org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:494)
      2. org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:402)
      3. org.openxava.controller.ModuleManager.execute(ModuleManager.java:359)
      3 frames
    10. org.apache.jsp
      execute_jsp._jspService
      1. org.apache.jsp.xava.execute_jsp._jspService(execute_jsp.java:196)
      1 frame
    11. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
      1 frame
    12. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
      1 frame
    13. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
      3 frames
    14. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
      1 frame
    15. Glassfish Core
      ApplicationDispatcher.include
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
      4. org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
      5. org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
      5 frames
    16. org.openxava.web
      Module.request
      1. org.openxava.web.servlets.Servlets.getURIAsStream(Servlets.java:66)
      2. org.openxava.web.dwr.Module.getURIAsStream(Module.java:205)
      3. org.openxava.web.dwr.Module.request(Module.java:64)
      3 frames
    17. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    18. Direct Web Remoting
      DwrServlet.doPost
      1. org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
      2. org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
      3. org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
      4. org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
      5. org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
      6. org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
      7. org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
      7 frames
    19. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
      2 frames
    20. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      2 frames
    21. Tomcat WS
      WsFilter.doFilter
      1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      1 frame
    22. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
      8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
      9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
      10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)
      10 frames
    23. Grizzly HTTP
      JIoEndpoint$SocketProcessor.run
      1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)
      2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
      3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
      3 frames
    24. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      3. java.lang.Thread.run(Thread.java:745)
      3 frames