java.lang.IllegalArgumentException: org.hibernate.QueryException: Not all named parameters have been set: [p1] [SELECT e.id, e.date, e_branch.name, e_state.name, e.clientName, e_agent.name from Request e left join e.branch e_branch left join e.state e_state left join e.agent e_agent where e.user.name like :p0 AND e.state.id = :p1]

openxava | juanjovega | 3 years ago
  1. 0

    Problema con filtro

    openxava | 3 years ago | juanjovega
    java.lang.IllegalArgumentException: org.hibernate.QueryException: Not all named parameters have been set: [p1] [SELECT e.id, e.date, e_branch.name, e_state.name, e.clientName, e_agent.name from Request e left join e.branch e_branch left join e.state e_state left join e.agent e_agent where e.user.name like :p0 AND e.state.id = :p1]
  2. 0

    Read active sub categories by category missing currentDate parameter

    GitHub | 3 years ago | mark--liu
    java.lang.IllegalArgumentException: org.hibernate.QueryException: Not all named parameters have been set: [currentDate] [SELECT category FROM org.broadleafcommerce.core.catalog.domain.Category category WHERE category.defaultParentCategory.id = :defaultParentCategoryId AND (category.archiveStatus.archived IS NULL OR category.archiveStatus.archived = 'N') AND (category.activeStartDate < :currentDate) AND (category.activeEndDate IS NULL OR category.activeEndDate > :currentDate)]
  3. 0

    JBPM - Hibernate QuerySyntaxException

    Stack Overflow | 3 years ago | jerith2
    java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, name.text, subject.text, description.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processSessionId) from org.jbpm.task.Task t left join t.taskData.createdBy left join t.taskData.actualOwner left join t.subjects as subject left join t.descriptions as description left join t.names as name, org.jbpm.task.OrganizationalEntity potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in () ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and ( name.language = :language or t.names.size = 0 ) and ( subject.language = :language or t.subjects.size = 0 ) and ( description.language = :language or t.descriptions.size = 0 ) and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and t.taskData.expirationTime is null]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate weird behavior using in clause inside inner query

    Stack Overflow | 4 years ago | Migore
    java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: , near line 1, column 244 [select p.fichaCaracterizacao.id from br.ufscar.siga.cadastrosgerais.entity.FichaParecer p where 1=1 and p.id in (select x.fichaCaracterizacao.id from br.ufscar.siga.cadastrosgerais.entity.FichaParecer x where x.departamento in :departamentos0_, :departamentos1_, :departamentos2_)]
  6. 0

    Monitor visibilty tab can generate QuerySyntaxException (postgres database resource)

    https://bugzilla.redhat.com/bugzilla/ | 9 years ago | Jay Shaughnessy
    java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [ SELECT oob.schedule.id,count(*) FROM org.rhq.core.domain.measurement.oob.MeasurementOutOfBounds oob WHERE oob.occurred BETWEEN :begin AND :end AND oob.schedule.id IN ( ) GROUP BY oob.schedule.id] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:616)

    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.lang.IllegalArgumentException

      org.hibernate.QueryException: Not all named parameters have been set: [p1] [SELECT e.id, e.date, e_branch.name, e_state.name, e.clientName, e_agent.name from Request e left join e.branch e_branch left join e.state e_state left join e.agent e_agent where e.user.name like :p0 AND e.state.id = :p1]

      at org.hibernate.ejb.AbstractEntityManagerImpl.convert()
    2. Hibernate EJB
      QueryImpl.getResultList
      1. org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1376)
      2. org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1317)
      3. org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255)
      3 frames
    3. org.openxava.tab
      TableModelBean.getValueAt
      1. org.openxava.tab.impl.JPATabProvider.nextBlock(JPATabProvider.java:170)
      2. org.openxava.tab.impl.JPATabProvider.nextChunk(JPATabProvider.java:139)
      3. org.openxava.tab.impl.EntityTabDataProvider.nextChunk(EntityTabDataProvider.java:32)
      4. org.openxava.tab.impl.EntityTab.nextChunk(EntityTab.java:249)
      5. org.openxava.tab.impl.TableModelBean.getRow(TableModelBean.java:121)
      6. org.openxava.tab.impl.TableModelBean.getValueAt(TableModelBean.java:172)
      6 frames