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

liferay.com | 4 days ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    liferay.com | 11 months ago
    org.hibernate.exception.SQLGrammarException: could not execute query
  2. 0

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

    liferay.com | 4 days ago
    org.hibernate.exception.SQLGrammarException: could not execute query
  3. 0

    database - quartz - issue in 5.1 - Forums | Liferay

    liferay.com | 10 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]]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 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

    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 'lportal5.Company' 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:3256)
      6. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
      7. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
      7 frames
    3. org.apache.tomcat
      DelegatingPreparedStatement.executeQuery
      1. org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
      1 frame
    4. Hibernate
      Loader.list
      1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
      2. org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
      3. org.hibernate.loader.Loader.doQuery(Loader.java:674)
      4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
      5. org.hibernate.loader.Loader.doList(Loader.java:2213)
      6. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
      7. org.hibernate.loader.Loader.list(Loader.java:2099)
      7 frames
    5. Hibernate
      QueryImpl.list
      1. org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:912)
      2. org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
      3. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
      4. org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      4 frames
    6. com.liferay.util
      QueryUtil.list
      1. com.liferay.util.dao.hibernate.QueryUtil.list(QueryUtil.java:59)
      1 frame
    7. Liferay Portal Service
      CompanyPersistenceImpl.findAll
      1. com.liferay.portal.service.persistence.CompanyPersistenceImpl.findAll(CompanyPersistenceImpl.java:730)
      2. com.liferay.portal.service.persistence.CompanyPersistenceImpl.findAll(CompanyPersistenceImpl.java:686)
      2 frames
    8. Liferay Portal Impl
      CompanyLocalServiceImpl.getCompanies
      1. com.liferay.portal.service.impl.CompanyLocalServiceImpl.getCompanies(CompanyLocalServiceImpl.java:379)
      1 frame
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    10. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    11. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      1 frame
    12. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    13. Unknown
      $Proxy2.getCompanies
      1. $Proxy2.getCompanies(Unknown Source)
      1 frame
    14. Liferay Portal Service
      CompanyLocalServiceUtil.getCompanies
      1. com.liferay.portal.service.CompanyLocalServiceUtil.getCompanies(CompanyLocalServiceUtil.java:142)
      1 frame
    15. com.liferay.portal
      LuceneUtil.<clinit>
      1. com.liferay.portal.lucene.IndexWriterFactory.<init>(IndexWriterFactory.java:80)
      2. com.liferay.portal.lucene.LuceneUtil.<init>(LuceneUtil.java:685)
      3. com.liferay.portal.lucene.LuceneUtil.<clinit>(LuceneUtil.java:683)
      3 frames
    16. Liferay Portal Impl
      MainServlet.init
      1. com.liferay.portal.events.StartupAction.run(StartupAction.java:239)
      2. com.liferay.portal.events.EventsProcessor._process(EventsProcessor.java:149)
      3. com.liferay.portal.events.EventsProcessor.process(EventsProcessor.java:76)
      4. com.liferay.portal.servlet.MainServlet.init(MainServlet.java:142)
      4 frames
    17. JavaServlet
      GenericServlet.init
      1. javax.servlet.GenericServlet.init(GenericServlet.java:212)
      1 frame
    18. Glassfish Core
      Catalina.start
      1. org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
      2. org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
      3. org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
      4. org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
      5. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
      6. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
      7. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
      8. org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
      9. org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
      10. org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
      11. org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
      12. org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
      13. org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
      14. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
      15. org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
      16. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
      17. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
      18. org.apache.catalina.core.StandardService.start(StandardService.java:448)
      19. org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
      20. org.apache.catalina.startup.Catalina.start(Catalina.java:552)
      20 frames
    19. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    20. Glassfish Core
      Bootstrap.main
      1. org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
      2. org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
      2 frames