org.hibernate.hql.ast.QuerySyntaxException: unexpected token: on near line 1, column 65 [from com.mydomain.myproject.domain.Person inner join Project_Person on person_id = id where project_id = 1]

Stack Overflow | Tim | 6 years ago
  1. 0

    Hibernate: org.hibernate.hql.ast.QuerySyntaxException: unexpected token

    Stack Overflow | 6 years ago | Tim
    org.hibernate.hql.ast.QuerySyntaxException: unexpected token: on near line 1, column 65 [from com.mydomain.myproject.domain.Person inner join Project_Person on person_id = id where project_id = 1]
  2. 0

    Erro de persistência. Hibernate + duas chaves primárias !!

    com.br | 1 year ago
    org.hibernate.hql.ast.QuerySyntaxException: unexpected token: values near line 1, column 120 [insert into NBS.PRISMA_BOX_RESERVA (prisma, data_comeca, data_termina, motivo, placa, crm_cod_empresa, crm_cod_evento) values ('XXXXX', TO_DATE('24/01/2012 08:00','DD/MM/YYYY HH24:MI'), TO_DATE('24/01/2012 08:00','DD/MM/YYYY HH24:MI'), 'On Line. Sr(a) XXXXXXXX', '123456', null, null)]
  3. 0

    unexpected token异常 -

    verydemo.com | 1 year ago
    org.hibernate.hql.ast.QuerySyntaxException: unexpected token: % near line 1, column 550 [select bmb.bombId,bmb.userid,bmb.bombType,bmb.bombState,bmb.bombRead,b.bomId,b.bomTopic,b.userid,b.bomRecList,b.bomCopyList,b.bomSecList,b.bomTime,b.bomState,bmb.bomfId,f.bomfName,bbu.userName,bbu.userAccount,bbu.empId,s.userName,s.userAccount from net.bolue.oa.vo.BlOaMailBox as bmb left outer join bmb.bm as b left outer join bmb.bmf as f left outer join bmb.blBasicUser as bbu left outer join b.sender as s where 1=1 and bmb.userid=:userid and bmb.bombType=:bombType and bmb.bombState=:bombState and bmb.bombRead=:bombRead and s.userAccount like %超级管理员% order by b.bomTime desc]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    unexpected token异常 | 红颜丽人

    hongyanliren.com | 1 year ago
    org.hibernate.hql.ast.QuerySyntaxException: unexpected token: % near line 1, column 550 [select bmb.bombId,bmb.userid,bmb.bombType,bmb.bombState,bmb.bombRead,b.bomId,b.bomTopic,b.userid,b.bomRecList,b.bomCopyList,b.bomSecList,b.bomTime,b.bomState,bmb.bomfId,f.bomfName,bbu.userName,bbu.userAccount,bbu.empId,s.userName,s.userAccount from net.bolue.oa.vo.BlOaMailBox as bmb left outer join bmb.bm as b left outer join bmb.bmf as f left outer join bmb.blBasicUser as bbu left outer join b.sender as s where 1=1 and bmb.userid=:userid and bmb.bombType=:bombType and bmb.bombState=:bombState and bmb.bombRead=:bombRead and s.userAccount like %超级管理员% order by b.bomTime desc]
  6. 0

    javax.el.ELException on search with assigned writer, common name, and topic id

    https://bugzilla.redhat.com/bugzilla/ | 5 years ago | sgilda
    javax.faces.FacesException: javax.el.ELException: /CustomSearchTopicList.xhtml @312,199 value="Topic Search Results (#{empty topicTagsList.resultList ? 0 : (topicTagsList.paginated ? topicTagsList.resultCount : topicTagsList.resultList.size)}) #{topicTagsList.searchTagHeading}": java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ) near line 1, column 386 [select topic from com.redhat.topicindex.entity.Topic as Topic where ((exists (select 1 from com.redhat.topicindex.entity.TopicToTag topicToTag where topicToTag.topic = topic and topicToTag.tag.tagId = 110) ) And (exists (select 1 from com.redhat.topicindex.entity.TopicToTag topicToTag where topicToTag.topic = topic and topicToTag.tag.tagId = 78) )) And (topic.topicId in (4953) and ) and topic.topicId in (:el8)]

    6 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.hql.ast.QuerySyntaxException

      unexpected token: on near line 1, column 65 [from com.mydomain.myproject.domain.Person inner join Project_Person on person_id = id where project_id = 1]

      at org.hibernate.hql.ast.QuerySyntaxException.convert()
    2. Hibernate HQL/JP-QL Parser
      QueryTranslatorImpl.compile
      1. org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
      2. org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
      3. org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
      4. org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
      5. org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
      6. org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
      6 frames
    3. Hibernate
      SessionImpl.createQuery
      1. org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
      2. org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
      3. org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
      4. org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
      5. org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
      6. org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
      6 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    5. Hibernate
      ThreadLocalSessionContext$TransactionProtectionWrapper.invoke
      1. org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:344)
      1 frame
    6. Unknown
      $Proxy26.createQuery
      1. $Proxy26.createQuery(Unknown Source)
      1 frame