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

Hibernate JIRA | Syam Kumar | 1 decade ago
  1. 0

    !ENTRY org.hibernate.eclipse 1 10000 2005-12-22 23:15:31.828 !MESSAGE DEBUG main org.hibernate.SQL - select genmessage0_.id as id266_, genmessage0_.site_id as site2_266_, genmessage0_.module_id as module3_266_, genmessage0_.message_code as message4_266_, genmessage0_.message_text as message5_266_, genmessage0_.version as version266_, genmessage0_.last_modified_date_time as last7_266_, genmessage0_.last_modified_by as last8_266_, genmessage0_.extension01 as extension9_266_, genmessage0_.extension02 as extension10_266_, genmessage0_.extension03 as extension11_266_, genmessage0_.extension04 as extension12_266_, genmessage0_.extension05 as extension13_266_, genmessage0_.extension06 as extension14_266_, genmessage0_.extension07 as extension15_266_, genmessage0_.extension08 as extension16_266_, genmessage0_.extension09 as extension17_266_, genmessage0_.extension10 as extension18_266_, genmessage0_.extension11 as extension19_266_, genmessage0_.extension12 as extension20_266_, genmessage0_.extension13 as extension21_266_, genmessage0_.extension14 as extension22_266_, genmessage0_.extension15 as extension23_266_, genmessage0_.extension17 as extension24_266_, genmessage0_.extension16 as extension25_266_, genmessage0_.extension18 as extension26_266_, genmessage0_.extension19 as extension27_266_, genmessage0_.extension20 as extension28_266_ from asset.asset.gen_messages genmessage0_ !ENTRY org.hibernate.eclipse 2 30000 2005-12-22 23:15:31.843 !MESSAGE WARN main org.hibernate.util.JDBCExceptionReporter - SQL Error: 1064, SQLState: 42000 !ENTRY org.hibernate.eclipse 4 40000 2005-12-22 23:15:31.843 !MESSAGE ERROR main 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 '.gen_messages genmessage0_' at line 1 !ENTRY org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE Exception while executing HQL Query !SUBENTRY 1 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE org.hibernate.exception.SQLGrammarException: could not execute query !STACK 0 org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2161) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948) Caused by: java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) ... 71 more !SUBENTRY 2 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE org.hibernate.exception.SQLGrammarException: could not execute query !STACK 0 org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2161) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948) Caused by: java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) ... 71 more !SUBENTRY 2 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 !STACK 0 java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948)

    Hibernate JIRA | 1 decade ago | Syam Kumar
    org.hibernate.exception.SQLGrammarException: could not execute query
  2. 0

    As am new to hibernate i used the tool to generate the java,class, and mapping files of my database using reverse engineering. Everything worked file the classes and mapping were generated but when i opened the console perspective in Eclipse, created the SessionFactory and tried to execute the query i got the following error. !ENTRY org.hibernate.eclipse 1 10000 2005-12-22 23:15:31.828 !MESSAGE DEBUG main org.hibernate.SQL - select genmessage0_.id as id266_, genmessage0_.site_id as site2_266_, genmessage0_.module_id as module3_266_, genmessage0_.message_code as message4_266_, genmessage0_.message_text as message5_266_, genmessage0_.version as version266_, genmessage0_.last_modified_date_time as last7_266_, genmessage0_.last_modified_by as last8_266_, genmessage0_.extension01 as extension9_266_, genmessage0_.extension02 as extension10_266_, genmessage0_.extension03 as extension11_266_, genmessage0_.extension04 as extension12_266_, genmessage0_.extension05 as extension13_266_, genmessage0_.extension06 as extension14_266_, genmessage0_.extension07 as extension15_266_, genmessage0_.extension08 as extension16_266_, genmessage0_.extension09 as extension17_266_, genmessage0_.extension10 as extension18_266_, genmessage0_.extension11 as extension19_266_, genmessage0_.extension12 as extension20_266_, genmessage0_.extension13 as extension21_266_, genmessage0_.extension14 as extension22_266_, genmessage0_.extension15 as extension23_266_, genmessage0_.extension17 as extension24_266_, genmessage0_.extension16 as extension25_266_, genmessage0_.extension18 as extension26_266_, genmessage0_.extension19 as extension27_266_, genmessage0_.extension20 as extension28_266_ from asset.asset.gen_messages genmessage0_ !ENTRY org.hibernate.eclipse 2 30000 2005-12-22 23:15:31.843 !MESSAGE WARN main org.hibernate.util.JDBCExceptionReporter - SQL Error: 1064, SQLState: 42000 !ENTRY org.hibernate.eclipse 4 40000 2005-12-22 23:15:31.843 !MESSAGE ERROR main 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 '.gen_messages genmessage0_' at line 1 !ENTRY org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE Exception while executing HQL Query !SUBENTRY 1 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE org.hibernate.exception.SQLGrammarException: could not execute query !STACK 0 org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2161) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948) Caused by: java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) ... 71 more !SUBENTRY 2 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE org.hibernate.exception.SQLGrammarException: could not execute query !STACK 0 org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2161) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948) Caused by: java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) ... 71 more !SUBENTRY 2 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 !STACK 0 java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948) Do u know why it is happening. Did i do something wrong?

    Hibernate JIRA | 1 decade ago | Syam Kumar
    org.hibernate.exception.SQLGrammarException: could not execute query
  3. 0

    !ENTRY org.hibernate.eclipse 1 10000 2005-12-22 23:15:31.828 !MESSAGE DEBUG main org.hibernate.SQL - select genmessage0_.id as id266_, genmessage0_.site_id as site2_266_, genmessage0_.module_id as module3_266_, genmessage0_.message_code as message4_266_, genmessage0_.message_text as message5_266_, genmessage0_.version as version266_, genmessage0_.last_modified_date_time as last7_266_, genmessage0_.last_modified_by as last8_266_, genmessage0_.extension01 as extension9_266_, genmessage0_.extension02 as extension10_266_, genmessage0_.extension03 as extension11_266_, genmessage0_.extension04 as extension12_266_, genmessage0_.extension05 as extension13_266_, genmessage0_.extension06 as extension14_266_, genmessage0_.extension07 as extension15_266_, genmessage0_.extension08 as extension16_266_, genmessage0_.extension09 as extension17_266_, genmessage0_.extension10 as extension18_266_, genmessage0_.extension11 as extension19_266_, genmessage0_.extension12 as extension20_266_, genmessage0_.extension13 as extension21_266_, genmessage0_.extension14 as extension22_266_, genmessage0_.extension15 as extension23_266_, genmessage0_.extension17 as extension24_266_, genmessage0_.extension16 as extension25_266_, genmessage0_.extension18 as extension26_266_, genmessage0_.extension19 as extension27_266_, genmessage0_.extension20 as extension28_266_ from asset.asset.gen_messages genmessage0_ !ENTRY org.hibernate.eclipse 2 30000 2005-12-22 23:15:31.843 !MESSAGE WARN main org.hibernate.util.JDBCExceptionReporter - SQL Error: 1064, SQLState: 42000 !ENTRY org.hibernate.eclipse 4 40000 2005-12-22 23:15:31.843 !MESSAGE ERROR main 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 '.gen_messages genmessage0_' at line 1 !ENTRY org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE Exception while executing HQL Query !SUBENTRY 1 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE org.hibernate.exception.SQLGrammarException: could not execute query !STACK 0 org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2161) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948) Caused by: java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) ... 71 more !SUBENTRY 2 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE org.hibernate.exception.SQLGrammarException: could not execute query !STACK 0 org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2161) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948) Caused by: java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) ... 71 more !SUBENTRY 2 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 !STACK 0 java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948)

    Hibernate JIRA | 1 decade ago | Syam Kumar
    org.hibernate.exception.SQLGrammarException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    As am new to hibernate i used the tool to generate the java,class, and mapping files of my database using reverse engineering. Everything worked file the classes and mapping were generated but when i opened the console perspective in Eclipse, created the SessionFactory and tried to execute the query i got the following error. !ENTRY org.hibernate.eclipse 1 10000 2005-12-22 23:15:31.828 !MESSAGE DEBUG main org.hibernate.SQL - select genmessage0_.id as id266_, genmessage0_.site_id as site2_266_, genmessage0_.module_id as module3_266_, genmessage0_.message_code as message4_266_, genmessage0_.message_text as message5_266_, genmessage0_.version as version266_, genmessage0_.last_modified_date_time as last7_266_, genmessage0_.last_modified_by as last8_266_, genmessage0_.extension01 as extension9_266_, genmessage0_.extension02 as extension10_266_, genmessage0_.extension03 as extension11_266_, genmessage0_.extension04 as extension12_266_, genmessage0_.extension05 as extension13_266_, genmessage0_.extension06 as extension14_266_, genmessage0_.extension07 as extension15_266_, genmessage0_.extension08 as extension16_266_, genmessage0_.extension09 as extension17_266_, genmessage0_.extension10 as extension18_266_, genmessage0_.extension11 as extension19_266_, genmessage0_.extension12 as extension20_266_, genmessage0_.extension13 as extension21_266_, genmessage0_.extension14 as extension22_266_, genmessage0_.extension15 as extension23_266_, genmessage0_.extension17 as extension24_266_, genmessage0_.extension16 as extension25_266_, genmessage0_.extension18 as extension26_266_, genmessage0_.extension19 as extension27_266_, genmessage0_.extension20 as extension28_266_ from asset.asset.gen_messages genmessage0_ !ENTRY org.hibernate.eclipse 2 30000 2005-12-22 23:15:31.843 !MESSAGE WARN main org.hibernate.util.JDBCExceptionReporter - SQL Error: 1064, SQLState: 42000 !ENTRY org.hibernate.eclipse 4 40000 2005-12-22 23:15:31.843 !MESSAGE ERROR main 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 '.gen_messages genmessage0_' at line 1 !ENTRY org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE Exception while executing HQL Query !SUBENTRY 1 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE org.hibernate.exception.SQLGrammarException: could not execute query !STACK 0 org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2161) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948) Caused by: java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) ... 71 more !SUBENTRY 2 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE org.hibernate.exception.SQLGrammarException: could not execute query !STACK 0 org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2161) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948) Caused by: java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) ... 71 more !SUBENTRY 2 org.hibernate.eclipse.console 4 150 2005-12-22 23:15:31.843 !MESSAGE java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 !STACK 0 java.sql.SQLException: 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 '.gen_messages genmessage0_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1677) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2158) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037) at org.hibernate.loader.Loader.list(Loader.java:2032) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848) at org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905) at org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748) at org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221) at org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282) at org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133) at org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148) at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718) at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334) at org.eclipse.core.launcher.Main.basicRun(Main.java:278) at org.eclipse.core.launcher.Main.run(Main.java:973) at org.eclipse.core.launcher.Main.main(Main.java:948) Do u know why it is happening. Did i do something wrong?

    Hibernate JIRA | 1 decade ago | Syam Kumar
    org.hibernate.exception.SQLGrammarException: could not execute query

  1. Kialandei 1 times, last 1 week ago
  2. poroszd 1 times, last 1 year ago
11 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. java.sql.SQLException

    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 '.gen_messages genmessage0_' at line 1

    at com.mysql.jdbc.MysqlIO.checkErrorPacket()
  2. MySQL jdbc
    PreparedStatement.executeQuery
    1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
    2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    4. com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
    5. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
    6. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
    6 frames
  3. Hibernate
    QueryLoader.list
    1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
    2. org.hibernate.loader.Loader.getResultSet(Loader.java:1677)
    3. org.hibernate.loader.Loader.doQuery(Loader.java:662)
    4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
    5. org.hibernate.loader.Loader.doList(Loader.java:2158)
    6. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2037)
    7. org.hibernate.loader.Loader.list(Loader.java:2032)
    8. org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
    8 frames
  4. Hibernate HQL/JP-QL Parser
    QueryTranslatorImpl.list
    1. org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300)
    1 frame
  5. Hibernate
    QueryImpl.list
    1. org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146)
    2. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093)
    3. org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
    3 frames
  6. org.hibernate.console
    HQLQueryPage.getList
    1. org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:33)
    1 frame
  7. org.hibernate.eclipse
    QueryPageViewer$ContentProviderImpl.getElements
    1. org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80)
    1 frame
  8. JFace
    StructuredViewer.setInput
    1. org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:848)
    2. org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1086)
    3. org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:790)
    4. org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:905)
    5. org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:798)
    6. org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:748)
    7. org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:737)
    8. org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1264)
    9. org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1201)
    10. org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1262)
    11. org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1221)
    12. org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:698)
    13. org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248)
    14. org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1417)
    14 frames
  9. org.hibernate.eclipse
    QueryPageTabView$1.intervalAdded
    1. org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174)
    2. org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153)
    3. org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111)
    4. org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:88)
    5. org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52)
    6. org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:62)
    6 frames
  10. Java RT
    AbstractListModel.fireIntervalAdded
    1. javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source)
    1 frame
  11. org.hibernate.console
    ConsoleConfiguration.executeHQLQuery
    1. org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50)
    2. org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:60)
    3. org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:306)
    4. org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:302)
    5. org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:295)
    6. org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35)
    7. org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287)
    8. org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:282)
    8 frames
  12. org.hibernate.eclipse
    KnownConfigurationsView$1.doubleClick
    1. org.hibernate.eclipse.console.views.KnownConfigurationsView$3.run(KnownConfigurationsView.java:133)
    2. org.hibernate.eclipse.console.views.KnownConfigurationsView$1.doubleClick(KnownConfigurationsView.java:77)
    2 frames
  13. JFace
    StructuredViewer$1.run
    1. org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:720)
    1 frame
  14. Eclipse Core
    Platform.run
    1. org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044)
    2. org.eclipse.core.runtime.Platform.run(Platform.java:783)
    2 frames
  15. Eclipse UI
    JFaceUtil$1.run
    1. org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44)
    1 frame
  16. JFace
    OpenStrategy$1.handleEvent
    1. org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148)
    2. org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:718)
    3. org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:950)
    4. org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1057)
    5. org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219)
    6. org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216)
    7. org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275)
    7 frames
  17. RWT
    Display.readAndDispatch
    1. org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    2. org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
    3. org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
    4. org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
    4 frames
  18. Eclipse UI
    Workbench.createAndRunWorkbench
    1. org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
    2. org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
    3. org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)
    3 frames
  19. Eclipse UI
    IDEApplication.run
    1. org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
    2. org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
    2 frames
  20. Eclipse Core
    PlatformActivator$1.run
    1. org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
    1 frame
  21. Eclipse OSGi
    EclipseStarter.run
    1. org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
    2. org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
    2 frames
  22. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  23. Equinox
    Main.main
    1. org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
    2. org.eclipse.core.launcher.Main.basicRun(Main.java:278)
    3. org.eclipse.core.launcher.Main.run(Main.java:973)
    4. org.eclipse.core.launcher.Main.main(Main.java:948)
    4 frames