Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (nike.apache.org: domain of joysn71@gmail.com designates
 74.125.82.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=GVPCG+AloDqg+Bg31yn7DMe9D18WN/cTaxCDc+Xei1g2F6TGY1LPhJ0jxrxisIbTpP
         GvZD97AhCRrfGt3KnCN1ELJ3qXqio0yXDbEF2DMvhP+m4rVuWFjMM5arWQvTxjERU0Fw
         zsr03msZJDsISqYoOH+ohnc+PbEqed4MofC+M=
MIME-Version: 1.0
Date: Sun, 20 Feb 2011 00:07:50 +0100
Message-ID: <AANLkTim+zWvEzi6pLVMRej+fZq+MJoU--tk2Mxca21eG@mail.gmail.com>
Subject: @Id not loaded when loading an entity
From: Chris Joysn <joysn71@gmail.com>
To: users@openjpa.apache.org
Content-Type: multipart/alternative; boundary=0016e64c1cf0219769049caab349

--0016e64c1cf0219769049caab349
Content-Type: text/plain; charset=ISO-8859-1

Hello,

when i load an entity the id value is not populated. The entity that was
created using the following test code has the id attribute set correct,
and i can verify this in the database table too, but when i re-read the
entity the id attribute is not populated.

-----8<-----
        em = getEntityManagerFactory().createEntityManager();

        EntityTransaction tx = em.getTransaction();
        tx.begin();

        // insert order

        Order order = new Order();
        order.setStatus("testStatus");
        em.persist(order);

        tx.commit();

        // verify if order was inserted correct

        final String query = "SELECT o FROM Order AS o WHERE o.status = ?1";

        Query q = em.createQuery(query);
        q.setParameter(1, "testStatus");

        Order orderLoaded = null;
        orderLoaded = (Order) q.getSingleResult();
        em.detach(orderLoaded);

        assertNotNull(orderLoaded);
        assertTrue(orderLoaded.getId() > 0);
        assertEquals(order.getStatus(), orderLoaded.getStatus());
-----8<-----

i am using OpenJPA 2.0.1 with MySQL JDBC 5.1.10 and MySQL Server 5.1.49.
with the following entity:

@Entity
@Table(name="orders")
public class Order implements Serializable {

    /** serial for Serializable */
    private static final long serialVersionUID = -8061887078955032972L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;

    @Version
    private int version;

    @Column(nullable = false, length = 50)
    private String status;

    @Column
    private Date created;

    ... remaining code skipped ...

as i am not able to find a solution via the docs and using the internet, can
anybody help on why
the id column is not populated?

Thanks

--0016e64c1cf0219769049caab349--