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

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

    Error - /public/eco_accommodation.xhtml @294,81 test="#{!empty accommodationBean.accommodation.tariff.pricePer}" /public/eco_accommodation.xhtml @294,81 test="#{!empty accommodationBean.accommodation.tariff.pricePer}": org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select accommodat0_.unid as unid34_0_, address1_.unid as unid12_1_, user4_.unid as unid1_2_, link6_.unid as unid10_3_, phone7_.unid as unid13_4_, propertyty8_.unid as unid23_5_, transport9_.unid as unid16_6_, images10_.unid as unid11_7_, activity12_.unid as unid22_8_, ggwinterne13_.unid as unid26_9_, internetlo16_.unid as unid25_10_, internetlo19_.unid as unid25_11_, tariff20_.unid as unid31_12_, questionna21_.unid as unid38_13_, energyreso24_.unid as unid36_14_, dietarysel27_.unid as unid37_15_, accommodat28_.unid as unid33_16_, accommodat0_.company_id as company2_34_0_, accommodat0_.address_id as address3_34_0_, accommodat0_.phone_id as phone4_34_0_, accommodat0_.transport_id as transport5_34_0_, accommodat0_.questionnaire_id as question6_34_0_, accommodat0_.short_description as short7_34_0_, accommodat0_.description as descript8_34_0_, accommodat0_.adults_only as adults9_34_0_, accommodat0_.property_type_id as property10_34_0_, accommodat0_.property_type_other as property11_34_0_, accommodat0_.activity_other as activity12_34_0_, accommodat0_.max_nb_guests as max13_34_0_, accommodat0_.nb_guest_rooms as nb14_34_0_, accommodat0_.nb_ensuite_rooms as nb15_34_0_, accommodat0_.nb_conference_rooms as nb16_34_0_, accommodat0_.nb_conference_delegates as nb17_34_0_, accommodat0_.fitness_center as fitness18_34_0_, accommodat0_.spa_facilities as spa19_34_0_, accommodat0_.internet_id as internet20_34_0_, accommodat0_.nb_restaurants as nb21_34_0_, accommodat0_.nb_bars as nb22_34_0_, accommodat0_.tariff_id as tariff23_34_0_, accommodat0_.booking_option as booking24_34_0_, accommodat0_.creation_date as creation25_34_0_, accommodat0_.last_update as last26_34_0_, accommodat0_.other as other34_0_, accommodat0_.status_id as status28_34_0_, accommodat0_.vip as vip34_0_, accommodat0_.last_referral_report_checked_date as last30_34_0_, address1_.address1 as address2_12_1_, address1_.address2 as address3_12_1_, address1_.address3 as address4_12_1_, address1_.city_id as city5_12_1_, address1_.postcode as postcode12_1_, address1_.latitude as latitude12_1_, address1_.longitude as longitude12_1_, address1_.accuracy as accuracy12_1_, address1_.coordinate_from as coordinate10_12_1_, user4_.username as username1_2_, user4_.password as password1_2_, user4_.role_id as role4_1_2_, user4_.title as title1_2_, user4_.forename as forename1_2_, user4_.surname as surname1_2_, user4_.email as email1_2_, user4_.phone_id as phone9_1_2_, user4_.creation_date as creation10_1_2_, user4_.newsletter_ind as newsletter11_1_2_, user4_.active as active1_2_, users3_.company_id as company1_0__, users3_.user_id as user2_0__, link6_.url as url10_3_, link6_.title as title10_3_, link6_.text as text10_3_, phone7_.landline as landline13_4_, phone7_.mobile as mobile13_4_, phone7_.fax as fax13_4_, propertyty8_.name as name23_5_, transport9_.railway_station as railway2_16_6_, transport9_.airport_international as airport3_16_6_, transport9_.airport_local as airport4_16_6_, images10_.location as location11_7_, images10_.title as title11_7_, images10_.campaign_id as campaign5_11_7_, images10_.accommodation_id as accommod6_11_7_, images10_.class as class11_7_, images10_.accommodation_id as accommod6_1__, images10_.unid as unid1__, activity12_.name as name22_8_, activity12_.active as active22_8_, activities11_.accommodation_id as accommod1_2__, activities11_.activity_id as activity2_2__, ggwinterne13_.type_id as type3_26_9_, ggwinterne13_.charge as charge26_9_, internetlo16_.name as name25_10_, facilities15_.internet_id as internet1_3__, facilities15_.location_id as location2_3__, internetlo19_.name as name25_11_, wireless18_.internet_id as internet1_4__, wireless18_.location_id as location2_4__, tariff20_.price_from as price2_31_12_, tariff20_.price_from_per as price3_31_12_, tariff20_.currency_code as currency4_31_12_, tariff20_.price_per as price5_31_12_, tariff20_.seasonal_variations as seasonal6_31_12_, tariff20_.other as other31_12_, questionna21_.last_update as last2_38_13_, questionna21_.conserve_heat as conserve3_38_13_, questionna21_.conserve_water as conserve4_38_13_, questionna21_.efficient_lighting as efficient5_38_13_, questionna21_.recycle as recycle38_13_, questionna21_.oil_gas_carbon as oil7_38_13_, questionna21_.waste_food as waste8_38_13_, questionna21_.energy_other as energy9_38_13_, questionna21_.bio_degradable as bio10_38_13_, questionna21_.reclamation_materials as reclama11_38_13_, questionna21_.renewable_furnishings as renewable12_38_13_, questionna21_.food_locally as food13_38_13_, questionna21_.dietary_selections_other as dietary14_38_13_, questionna21_.local_employment as local15_38_13_, questionna21_.instruct_staff as instruct16_38_13_, questionna21_.info_packs as info17_38_13_, questionna21_.web_green_info as web18_38_13_, questionna21_.wildlife as wildlife38_13_, questionna21_.other as other38_13_, energyreso24_.name as name36_14_, energyreso23_.questionnaire_id as question1_5__, energyreso23_.energy_resource_id as energy2_5__, dietarysel27_.name as name37_15_, dietarysel26_.questionnaire_id as question1_6__, dietarysel26_.dietary_selection_id as dietary2_6__, accommodat28_.name as name33_16_ from tbl_accommodation accommodat0_ left outer join tbl_address address1_ on accommodat0_.address_id=address1_.unid left outer join tbl_company company2_ on accommodat0_.company_id=company2_.unid left outer join tbl_user_company users3_ on company2_.unid=users3_.company_id left outer join tbl_user user4_ on users3_.user_id=user4_.unid left outer join tbl_link link6_ on company2_.link_id=link6_.unid left outer join tbl_phone phone7_ on accommodat0_.phone_id=phone7_.unid left outer join lk_property_type propertyty8_ on accommodat0_.property_type_id=propertyty8_.unid left outer join tbl_transport transport9_ on accommodat0_.transport_id=transport9_.unid left outer join tbl_image images10_ on accommodat0_.unid=images10_.accommodation_id left outer join tbl_acco_activity activities11_ on accommodat0_.unid=activities11_.accommodation_id left outer join lk_activity activity12_ on activities11_.activity_id=activity12_.unid left outer join tbl_internet ggwinterne13_ on accommodat0_.internet_id=ggwinterne13_.unid left outer join tbl_internet_facility facilities15_ on ggwinterne13_.unid=facilities15_.internet_id left outer join lk_internet_location internetlo16_ on facilities15_.location_id=internetlo16_.unid left outer join tbl_internet_wireless wireless18_ on ggwinterne13_.unid=wireless18_.internet_id left outer join lk_internet_location internetlo19_ on wireless18_.location_id=internetlo19_.unid left outer join tbl_tariff tariff20_ on accommodat0_.tariff_id=tariff20_.unid left outer join tbl_questionnaire questionna21_ on accommodat0_.questionnaire_id=questionna21_.unid left outer join tbl_quest_energy energyreso23_ on questionna21_.unid=energyreso23_.questionnaire_id left outer join lk_energy_resource energyreso24_ on energyreso23_.energy_resource_id=energyreso24_.unid left outer join tbl_quest_dietary dietarysel26_ on questionna21_.unid=dietarysel26_.questionnaire_id left outer join lk_dietary_selection dietarysel27_ on dietarysel26_.dietary_selection_id=dietarysel27_.unid left outer join lk_accommodation_status accommodat28_ on accommodat0_.status_id=accommodat28_.unid where accommodat0_.unid=? and (activity12_.active=1 or activity12_.active is null) order by images10_.unid]; SQL state [HY000]; error code [1030]; Got error 28 from storage engine; nested exception is java.sql.SQLException: Got error 28 from storage engine

    itsagreengreenworld.com | 11 months ago
    com.sun.facelets.tag.TagAttributeException: /public/eco_accommodation.xhtml @294,81 test="#{!empty accommodationBean.accommodation.tariff.pricePer}" /public/eco_accommodation.xhtml @294,81 test="#{!empty accommodationBean.accommodation.tariff.pricePer}": org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select accommodat0_.unid as unid34_0_, address1_.unid as unid12_1_, user4_.unid as unid1_2_, link6_.unid as unid10_3_, phone7_.unid as unid13_4_, propertyty8_.unid as unid23_5_, transport9_.unid as unid16_6_, images10_.unid as unid11_7_, activity12_.unid as unid22_8_, ggwinterne13_.unid as unid26_9_, internetlo16_.unid as unid25_10_, internetlo19_.unid as unid25_11_, tariff20_.unid as unid31_12_, questionna21_.unid as unid38_13_, energyreso24_.unid as unid36_14_, dietarysel27_.unid as unid37_15_, accommodat28_.unid as unid33_16_, accommodat0_.company_id as company2_34_0_, accommodat0_.address_id as address3_34_0_, accommodat0_.phone_id as phone4_34_0_, accommodat0_.transport_id as transport5_34_0_, accommodat0_.questionnaire_id as question6_34_0_, accommodat0_.short_description as short7_34_0_, accommodat0_.description as descript8_34_0_, accommodat0_.adults_only as adults9_34_0_, accommodat0_.property_type_id as property10_34_0_, accommodat0_.property_type_other as property11_34_0_, accommodat0_.activity_other as activity12_34_0_, accommodat0_.max_nb_guests as max13_34_0_, accommodat0_.nb_guest_rooms as nb14_34_0_, accommodat0_.nb_ensuite_rooms as nb15_34_0_, accommodat0_.nb_conference_rooms as nb16_34_0_, accommodat0_.nb_conference_delegates as nb17_34_0_, accommodat0_.fitness_center as fitness18_34_0_, accommodat0_.spa_facilities as spa19_34_0_, accommodat0_.internet_id as internet20_34_0_, accommodat0_.nb_restaurants as nb21_34_0_, accommodat0_.nb_bars as nb22_34_0_, accommodat0_.tariff_id as tariff23_34_0_, accommodat0_.booking_option as booking24_34_0_, accommodat0_.creation_date as creation25_34_0_, accommodat0_.last_update as last26_34_0_, accommodat0_.other as other34_0_, accommodat0_.status_id as status28_34_0_, accommodat0_.vip as vip34_0_, accommodat0_.last_referral_report_checked_date as last30_34_0_, address1_.address1 as address2_12_1_, address1_.address2 as address3_12_1_, address1_.address3 as address4_12_1_, address1_.city_id as city5_12_1_, address1_.postcode as postcode12_1_, address1_.latitude as latitude12_1_, address1_.longitude as longitude12_1_, address1_.accuracy as accuracy12_1_, address1_.coordinate_from as coordinate10_12_1_, user4_.username as username1_2_, user4_.password as password1_2_, user4_.role_id as role4_1_2_, user4_.title as title1_2_, user4_.forename as forename1_2_, user4_.surname as surname1_2_, user4_.email as email1_2_, user4_.phone_id as phone9_1_2_, user4_.creation_date as creation10_1_2_, user4_.newsletter_ind as newsletter11_1_2_, user4_.active as active1_2_, users3_.company_id as company1_0__, users3_.user_id as user2_0__, link6_.url as url10_3_, link6_.title as title10_3_, link6_.text as text10_3_, phone7_.landline as landline13_4_, phone7_.mobile as mobile13_4_, phone7_.fax as fax13_4_, propertyty8_.name as name23_5_, transport9_.railway_station as railway2_16_6_, transport9_.airport_international as airport3_16_6_, transport9_.airport_local as airport4_16_6_, images10_.location as location11_7_, images10_.title as title11_7_, images10_.campaign_id as campaign5_11_7_, images10_.accommodation_id as accommod6_11_7_, images10_.class as class11_7_, images10_.accommodation_id as accommod6_1__, images10_.unid as unid1__, activity12_.name as name22_8_, activity12_.active as active22_8_, activities11_.accommodation_id as accommod1_2__, activities11_.activity_id as activity2_2__, ggwinterne13_.type_id as type3_26_9_, ggwinterne13_.charge as charge26_9_, internetlo16_.name as name25_10_, facilities15_.internet_id as internet1_3__, facilities15_.location_id as location2_3__, internetlo19_.name as name25_11_, wireless18_.internet_id as internet1_4__, wireless18_.location_id as location2_4__, tariff20_.price_from as price2_31_12_, tariff20_.price_from_per as price3_31_12_, tariff20_.currency_code as currency4_31_12_, tariff20_.price_per as price5_31_12_, tariff20_.seasonal_variations as seasonal6_31_12_, tariff20_.other as other31_12_, questionna21_.last_update as last2_38_13_, questionna21_.conserve_heat as conserve3_38_13_, questionna21_.conserve_water as conserve4_38_13_, questionna21_.efficient_lighting as efficient5_38_13_, questionna21_.recycle as recycle38_13_, questionna21_.oil_gas_carbon as oil7_38_13_, questionna21_.waste_food as waste8_38_13_, questionna21_.energy_other as energy9_38_13_, questionna21_.bio_degradable as bio10_38_13_, questionna21_.reclamation_materials as reclama11_38_13_, questionna21_.renewable_furnishings as renewable12_38_13_, questionna21_.food_locally as food13_38_13_, questionna21_.dietary_selections_other as dietary14_38_13_, questionna21_.local_employment as local15_38_13_, questionna21_.instruct_staff as instruct16_38_13_, questionna21_.info_packs as info17_38_13_, questionna21_.web_green_info as web18_38_13_, questionna21_.wildlife as wildlife38_13_, questionna21_.other as other38_13_, energyreso24_.name as name36_14_, energyreso23_.questionnaire_id as question1_5__, energyreso23_.energy_resource_id as energy2_5__, dietarysel27_.name as name37_15_, dietarysel26_.questionnaire_id as question1_6__, dietarysel26_.dietary_selection_id as dietary2_6__, accommodat28_.name as name33_16_ from tbl_accommodation accommodat0_ left outer join tbl_address address1_ on accommodat0_.address_id=address1_.unid left outer join tbl_company company2_ on accommodat0_.company_id=company2_.unid left outer join tbl_user_company users3_ on company2_.unid=users3_.company_id left outer join tbl_user user4_ on users3_.user_id=user4_.unid left outer join tbl_link link6_ on company2_.link_id=link6_.unid left outer join tbl_phone phone7_ on accommodat0_.phone_id=phone7_.unid left outer join lk_property_type propertyty8_ on accommodat0_.property_type_id=propertyty8_.unid left outer join tbl_transport transport9_ on accommodat0_.transport_id=transport9_.unid left outer join tbl_image images10_ on accommodat0_.unid=images10_.accommodation_id left outer join tbl_acco_activity activities11_ on accommodat0_.unid=activities11_.accommodation_id left outer join lk_activity activity12_ on activities11_.activity_id=activity12_.unid left outer join tbl_internet ggwinterne13_ on accommodat0_.internet_id=ggwinterne13_.unid left outer join tbl_internet_facility facilities15_ on ggwinterne13_.unid=facilities15_.internet_id left outer join lk_internet_location internetlo16_ on facilities15_.location_id=internetlo16_.unid left outer join tbl_internet_wireless wireless18_ on ggwinterne13_.unid=wireless18_.internet_id left outer join lk_internet_location internetlo19_ on wireless18_.location_id=internetlo19_.unid left outer join tbl_tariff tariff20_ on accommodat0_.tariff_id=tariff20_.unid left outer join tbl_questionnaire questionna21_ on accommodat0_.questionnaire_id=questionna21_.unid left outer join tbl_quest_energy energyreso23_ on questionna21_.unid=energyreso23_.questionnaire_id left outer join lk_energy_resource energyreso24_ on energyreso23_.energy_resource_id=energyreso24_.unid left outer join tbl_quest_dietary dietarysel26_ on questionna21_.unid=dietarysel26_.questionnaire_id left outer join lk_dietary_selection dietarysel27_ on dietarysel26_.dietary_selection_id=dietarysel27_.unid left outer join lk_accommodation_status accommodat28_ on accommodat0_.status_id=accommodat28_.unid where accommodat0_.unid=? and (activity12_.active=1 or activity12_.active is null) order by images10_.unid]; SQL state [HY000]; error code [1030]; Got error 28 from storage engine; nested exception is java.sql.SQLException: Got error 28 from storage engine

  1. Kialandei 1 times, last 2 weeks 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