OpenJPA
  1. OpenJPA
  2. OPENJPA-2343

Version field returns null when explicity projected from a JOIN in SELECT clause

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.1, 2.3.0
    • Fix Version/s: 2.1.2, 2.2.1.1, 2.2.3, 2.3.0
    • Component/s: query
    • Labels:
      None
    • Patch Info:
      Patch Available

      Description

      With these entities:

      @Entity
      public class Foo {
      private int id;
      private int version;
      @Id
      public int getId()

      { return id; }
      public void setId(int id) { this.id = id; }

      public void setVersion(int version) { this.version = version; }
      @Version
      public int getVersion() { return this.version; }
      }

      @Entity
      public class Bar{
      private int id;
      private Foo foo;
      @Id
      public int getId() { return id; }

      public void setId(int id)

      { this.id = id; }

      public void setFoo(Foo foo)

      { this.foo = foo; }

      @ManyToOne
      public Foo getFoo()

      { return foo; }

      }
      Insert a record for each associating foo with bar.

      Foo foo = new Foo();
      em.getTransaction().begin();
      em.persist(foo);
      Bar bar = new Bar();
      bar.setFoo(foo);
      em.persist(bar);
      em.getTransaction().commit();
      em.close();

      queries

      select bar.id as id, foo as foo from Bar bar join bar.foo foo
      The version field is available via foo.getVersion()

      select bar.id as id, foo.version as version from Bar bar join bar.foo foo
      version is always null.

      By enabling the jdbc debug I can see that the actual SQL being run is correct but the value is just not hydrated.

        Issue Links

          Activity

          Hide
          ASF subversion and git services added a comment -

          Commit 1533235 from Heath Thomann in branch 'openjpa/branches/2.3.x'
          [ https://svn.apache.org/r1533235 ]

          OPENJPA-2343: Version field returns null when explicity projected from a JOIN in SELECT clause - based fix off of patch provided by Howard Kelsey. Merged 2.2.x commit to 2.3.x.

          Show
          ASF subversion and git services added a comment - Commit 1533235 from Heath Thomann in branch 'openjpa/branches/2.3.x' [ https://svn.apache.org/r1533235 ] OPENJPA-2343 : Version field returns null when explicity projected from a JOIN in SELECT clause - based fix off of patch provided by Howard Kelsey. Merged 2.2.x commit to 2.3.x.
          Hide
          ASF subversion and git services added a comment -

          Commit 1533227 from Heath Thomann in branch 'openjpa/trunk'
          [ https://svn.apache.org/r1533227 ]

          OPENJPA-2343: Version field returns null when explicity projected from a JOIN in SELECT clause - based fix off of patch provided by Howard Kelsey. Merged 2.2.x commit to trunk.

          Show
          ASF subversion and git services added a comment - Commit 1533227 from Heath Thomann in branch 'openjpa/trunk' [ https://svn.apache.org/r1533227 ] OPENJPA-2343 : Version field returns null when explicity projected from a JOIN in SELECT clause - based fix off of patch provided by Howard Kelsey. Merged 2.2.x commit to trunk.
          Hide
          ASF subversion and git services added a comment -

          Commit 1533223 from Heath Thomann in branch 'openjpa/branches/2.2.x'
          [ https://svn.apache.org/r1533223 ]

          OPENJPA-2343: Version field returns null when explicity projected from a JOIN in SELECT clause - based fix off of patch provided by Howard Kelsey. Merged 2.2.1.x commit to 2.2.x.

          Show
          ASF subversion and git services added a comment - Commit 1533223 from Heath Thomann in branch 'openjpa/branches/2.2.x' [ https://svn.apache.org/r1533223 ] OPENJPA-2343 : Version field returns null when explicity projected from a JOIN in SELECT clause - based fix off of patch provided by Howard Kelsey. Merged 2.2.1.x commit to 2.2.x.
          Hide
          ASF subversion and git services added a comment -

          Commit 1533222 from Heath Thomann in branch 'openjpa/branches/2.2.1.x'
          [ https://svn.apache.org/r1533222 ]

          OPENJPA-2343: Version field returns null when explicity projected from a JOIN in SELECT clause - based fix off of patch provided by Howard Kelsey. Merged 2.1.x commit to 2.2.1.x.

          Show
          ASF subversion and git services added a comment - Commit 1533222 from Heath Thomann in branch 'openjpa/branches/2.2.1.x' [ https://svn.apache.org/r1533222 ] OPENJPA-2343 : Version field returns null when explicity projected from a JOIN in SELECT clause - based fix off of patch provided by Howard Kelsey. Merged 2.1.x commit to 2.2.1.x.
          Hide
          ASF subversion and git services added a comment -

          Commit 1533218 from Heath Thomann in branch 'openjpa/branches/2.1.x'
          [ https://svn.apache.org/r1533218 ]

          OPENJPA-2343: Version field returns null when explicity projected from a JOIN in SELECT clause - based fix off of patch provided by Howard Kelsey.

          Show
          ASF subversion and git services added a comment - Commit 1533218 from Heath Thomann in branch 'openjpa/branches/2.1.x' [ https://svn.apache.org/r1533218 ] OPENJPA-2343 : Version field returns null when explicity projected from a JOIN in SELECT clause - based fix off of patch provided by Howard Kelsey.

            People

            • Assignee:
              Rick Curtis
              Reporter:
              howard kelsey
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development