org.hibernate.QueryException: unexpected char: ';' [select s from mapping.ScaleData s, mapping.ScalesMappingData sm, mapping.AgencyRatingData ar, mapping.AgencyData a where s.scaleid=sm.scale.scaleid and sm.agencyrating.ratingid=ar.ratingid and ar.agency.agencyid=a.agencyid and a.agencyname=: param1 and ar.rating= :param2;]

Hibernate JIRA | Damir Isanbirdin | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:14.265 !MESSAGE Unhandled event loop exception !ENTRY org.eclipse.ui 4 0 2006-10-04 04:17:14.265 !MESSAGE Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) !STACK 0 org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) .... !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:16.921 !MESSAGE Save Failed !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.doSave(HQLEditor.java:430) at org.eclipse.ui.internal.SaveableHelper$1.run(SaveableHelper.java:95) at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:116) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:346) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:291) !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:17.296 !MESSAGE Unhandled event loop exception !ENTRY org.eclipse.ui 4 0 2006-10-04 04:17:17.296 !MESSAGE Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) !STACK 0 org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) at org.eclipse.swt.SWT.error(SWT.java:2942) at org.eclipse.swt.SWT.error(SWT.java:2865) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:126) at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3102) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2761) at org.eclipse.jface.window.Window.runEventLoop(Window.java:809) ... 51 more !ENTRY org.hibernate.eclipse.console 4 150 2006-10-04 04:17:29.687 !MESSAGE Exception while executing HQL Query !SUBENTRY 1 org.hibernate.eclipse.console 4 150 2006-10-04 04:17:29.703 !MESSAGE org.hibernate.QueryException: unexpected char: ';' [select s from mapping.ScaleData s, mapping.ScalesMappingData sm, mapping.AgencyRatingData ar, mapping.AgencyData a where s.scaleid=sm.scale.scaleid and sm.agencyrating.ratingid=ar.ratingid and ar.agency.agencyid=a.agencyid and a.agencyname=: param1 and ar.rating= :param2;] !STACK 0 org.hibernate.QueryException: unexpected char: ';' [select s from mapping.ScaleData s, mapping.ScalesMappingData sm, mapping.AgencyRatingData ar, mapping.AgencyData a where s.scaleid=sm.scale.scaleid and sm.agencyrating.ratingid=ar.ratingid and ar.agency.agencyid=a.agencyid and a.agencyname=: param1 and ar.rating= :param2;] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:203) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:110) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1586) at org.hibernate.console.HQLQueryPage.setSession(HQLQueryPage.java:77) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:292) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.eclipse.console.actions.ExecuteHQLAction.execute(ExecuteHQLAction.java:134) at org.hibernate.eclipse.console.actions.ExecuteHQLAction$2.run(ExecuteHQLAction.java:104) at org.eclipse.jface.action.Action.runWithEvent(Action.java:996) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:538) ... !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:36.171 !MESSAGE Save Failed !ENTRY org.eclipse.ui 2 0 2006-10-04 04:17:36.171 !MESSAGE Save Failed !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.doSave(HQLEditor.java:430) at org.eclipse.ui.internal.SaveableHelper$1.run(SaveableHelper.java:95) at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:116) ... !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:42.484 !MESSAGE Save Failed !ENTRY org.eclipse.ui 2 0 2006-10-04 04:17:42.500 !MESSAGE Save Failed !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.doSave(HQLEditor.java:430) at org.eclipse.ui.internal.SaveableHelper$1.run(SaveableHelper.java:95) at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:116) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:346) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:291) at org.eclipse.jface.window.ApplicationWindow$1.run(ApplicationWindow.java:624) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69) at org.eclipse.jface.window.ApplicationWindow.run(ApplicationWindow.java:621) at org.eclipse.ui.internal.WorkbenchWindow.run(WorkbenchWindow.java:2134) ... !ENTRY org.eclipse.ui.workbench 4 2 2006-10-04 04:17:48.78 !MESSAGE Problems occurred when invoking code from plug-in: "org.eclipse.ui.workbench". !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.getConsoleConfiguration(HQLEditor.java:438) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.updateText(DynamicSQLPreviewView.java:115) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.setCurrentEditor(DynamicSQLPreviewView.java:108) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.hookIntoEditor(DynamicSQLPreviewView.java:92) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.access$2(DynamicSQLPreviewView.java:85) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView$1.partBroughtToTop(DynamicSQLPreviewView.java:70) at org.eclipse.ui.internal.PartListenerList2$2.run(PartListenerList2.java:83) 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.PartListenerList2.fireEvent(PartListenerList2.java:54) ...

    Hibernate JIRA | 1 decade ago | Damir Isanbirdin
    org.hibernate.QueryException: unexpected char: ';' [select s from mapping.ScaleData s, mapping.ScalesMappingData sm, mapping.AgencyRatingData ar, mapping.AgencyData a where s.scaleid=sm.scale.scaleid and sm.agencyrating.ratingid=ar.ratingid and ar.agency.agencyid=a.agencyid and a.agencyname=: param1 and ar.rating= :param2;]
  2. 0

    !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:14.265 !MESSAGE Unhandled event loop exception !ENTRY org.eclipse.ui 4 0 2006-10-04 04:17:14.265 !MESSAGE Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) !STACK 0 org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) .... !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:16.921 !MESSAGE Save Failed !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.doSave(HQLEditor.java:430) at org.eclipse.ui.internal.SaveableHelper$1.run(SaveableHelper.java:95) at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:116) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:346) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:291) !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:17.296 !MESSAGE Unhandled event loop exception !ENTRY org.eclipse.ui 4 0 2006-10-04 04:17:17.296 !MESSAGE Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) !STACK 0 org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) at org.eclipse.swt.SWT.error(SWT.java:2942) at org.eclipse.swt.SWT.error(SWT.java:2865) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:126) at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3102) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2761) at org.eclipse.jface.window.Window.runEventLoop(Window.java:809) ... 51 more !ENTRY org.hibernate.eclipse.console 4 150 2006-10-04 04:17:29.687 !MESSAGE Exception while executing HQL Query !SUBENTRY 1 org.hibernate.eclipse.console 4 150 2006-10-04 04:17:29.703 !MESSAGE org.hibernate.QueryException: unexpected char: ';' [select s from mapping.ScaleData s, mapping.ScalesMappingData sm, mapping.AgencyRatingData ar, mapping.AgencyData a where s.scaleid=sm.scale.scaleid and sm.agencyrating.ratingid=ar.ratingid and ar.agency.agencyid=a.agencyid and a.agencyname=: param1 and ar.rating= :param2;] !STACK 0 org.hibernate.QueryException: unexpected char: ';' [select s from mapping.ScaleData s, mapping.ScalesMappingData sm, mapping.AgencyRatingData ar, mapping.AgencyData a where s.scaleid=sm.scale.scaleid and sm.agencyrating.ratingid=ar.ratingid and ar.agency.agencyid=a.agencyid and a.agencyname=: param1 and ar.rating= :param2;] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:203) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:110) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1586) at org.hibernate.console.HQLQueryPage.setSession(HQLQueryPage.java:77) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:292) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.eclipse.console.actions.ExecuteHQLAction.execute(ExecuteHQLAction.java:134) at org.hibernate.eclipse.console.actions.ExecuteHQLAction$2.run(ExecuteHQLAction.java:104) at org.eclipse.jface.action.Action.runWithEvent(Action.java:996) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:538) ... !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:36.171 !MESSAGE Save Failed !ENTRY org.eclipse.ui 2 0 2006-10-04 04:17:36.171 !MESSAGE Save Failed !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.doSave(HQLEditor.java:430) at org.eclipse.ui.internal.SaveableHelper$1.run(SaveableHelper.java:95) at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:116) ... !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:42.484 !MESSAGE Save Failed !ENTRY org.eclipse.ui 2 0 2006-10-04 04:17:42.500 !MESSAGE Save Failed !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.doSave(HQLEditor.java:430) at org.eclipse.ui.internal.SaveableHelper$1.run(SaveableHelper.java:95) at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:116) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:346) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:291) at org.eclipse.jface.window.ApplicationWindow$1.run(ApplicationWindow.java:624) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69) at org.eclipse.jface.window.ApplicationWindow.run(ApplicationWindow.java:621) at org.eclipse.ui.internal.WorkbenchWindow.run(WorkbenchWindow.java:2134) ... !ENTRY org.eclipse.ui.workbench 4 2 2006-10-04 04:17:48.78 !MESSAGE Problems occurred when invoking code from plug-in: "org.eclipse.ui.workbench". !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.getConsoleConfiguration(HQLEditor.java:438) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.updateText(DynamicSQLPreviewView.java:115) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.setCurrentEditor(DynamicSQLPreviewView.java:108) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.hookIntoEditor(DynamicSQLPreviewView.java:92) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.access$2(DynamicSQLPreviewView.java:85) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView$1.partBroughtToTop(DynamicSQLPreviewView.java:70) at org.eclipse.ui.internal.PartListenerList2$2.run(PartListenerList2.java:83) 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.PartListenerList2.fireEvent(PartListenerList2.java:54) ...

    Hibernate JIRA | 1 decade ago | Damir Isanbirdin
    org.hibernate.QueryException: unexpected char: ';' [select s from mapping.ScaleData s, mapping.ScalesMappingData sm, mapping.AgencyRatingData ar, mapping.AgencyData a where s.scaleid=sm.scale.scaleid and sm.agencyrating.ratingid=ar.ratingid and ar.agency.agencyid=a.agencyid and a.agencyname=: param1 and ar.rating= :param2;]
  3. 0

    ArrayIndexOutOfBoundsException in server log when there is a search criteria and user enters an opening parenthesis at the beginning of search bar.

    https://bugzilla.redhat.com/bugzilla/ | 7 years ago | Sunil Kondkar
    com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public abstract java.util.List org.rhq.enterprise.gui.coregui.client.gwt.SearchGWTService.getSuggestions(org.rhq.core.domain.search.SearchSubsystem,java.lang.String,int)' threw an unexpected exception: java.lang.IllegalArgumentException: org.hibernate.QueryException: unexpected char: '%' [SELECT DISTINCT res.name FROM org.rhq.core.domain.resource.Resource res WHERE LOWER(res.name) LIKE '%'%' ORDER BY res.name ]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    error in running HQL Query

    Coderanch | 7 years ago | madhuri kunchala
    org.hibernate.QueryException: unexpected char: ';' [from testdb.User where id between 1 and 5; from User; ]
  6. 0

    Hibernate query returning error

    Stack Overflow | 6 years ago | blue-sky
    org.hibernate.QueryException: unexpected char: '"' [Event where eventName like "test" and startingDate >= "2011-01-19" and endingDate &lt;= "2011-01-31" ]

    1 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. org.hibernate.QueryException

      unexpected char: ';' [select s from mapping.ScaleData s, mapping.ScalesMappingData sm, mapping.AgencyRatingData ar, mapping.AgencyData a where s.scaleid=sm.scale.scaleid and sm.agencyrating.ratingid=ar.ratingid and ar.agency.agencyid=a.agencyid and a.agencyname=: param1 and ar.rating= :param2;]

      at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile()
    2. Hibernate HQL/JP-QL Parser
      QueryTranslatorImpl.compile
      1. org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:203)
      2. org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:110)
      2 frames
    3. Hibernate
      SessionImpl.createQuery
      1. org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
      2. org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
      3. org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
      4. org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
      5. org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
      6. org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1586)
      6 frames
    4. org.hibernate.console
      ConsoleConfiguration.executeHQLQuery
      1. org.hibernate.console.HQLQueryPage.setSession(HQLQueryPage.java:77)
      2. org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:292)
      3. org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35)
      4. org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287)
      4 frames
    5. org.hibernate.eclipse
      ExecuteHQLAction$2.run
      1. org.hibernate.eclipse.console.actions.ExecuteHQLAction.execute(ExecuteHQLAction.java:134)
      2. org.hibernate.eclipse.console.actions.ExecuteHQLAction$2.run(ExecuteHQLAction.java:104)
      2 frames
    6. JFace
      ActionContributionItem.handleWidgetSelection
      1. org.eclipse.jface.action.Action.runWithEvent(Action.java:996)
      2. org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:538)
      2 frames