Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-2569

QBE is not using the right column name in join

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.3.0
    • Fix Version/s: None
    • Component/s: jpa
    • Labels:
      None
    • Environment:
      tomee+ 1.6.0 stable

      Description

      I have a query like this

      public List<E> qbe(E example)

      { OpenJPACriteriaBuilder cb = (OpenJPACriteriaBuilder) entityManager.getCriteriaBuilder(); CriteriaQuery<E> q = cb.createQuery(clazz); Root<E> entity = q.from(clazz); q.where(cb.qbe(entity, example)); // query by example q.select(entity); TypedQuery<E> tq = entityManager.createQuery(q); return tq.getResultList(); }

      for entities like this

      @Entity
      @Table(name="APPUSER",uniqueConstraints=@UniqueConstraint(columnNames=

      {"username"}

      ))
      public class User implements Serializable{
      /**
      *
      */
      private static final long serialVersionUID = 4411272750939441365L;

      @Id
      @GeneratedValue(strategy = GenerationType.AUTO)
      private Long id;
      (...)

      and this

      @Entity
      public class PasswordRotationJob implements Serializable{

      (...)
      @ManyToOne
      @JoinColumn(name="userId")
      private User submitter;

      The QBE query seems to assume a wrong column name

      Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00904: "T1"."USERID": invalid identifier

      {prepstmnt 1347119244 SELECT t0.id,(...), t1.id, (...), t2.id, (...) FROM PasswordRotationJob t0, APPUSER t1, (...) WHERE (...) AND t0.userId = t1.userId(+) (...)}

      [code=904, state=42000]

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              shikida leonardo kenji shikida
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: