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

liferay.com | 2 months ago
  1. 0

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

    liferay.com | 8 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 | 2 months ago
    org.hibernate.exception.SQLGrammarException: could not execute query
  3. 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]]
  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