Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: domain of primemoxie@gmail.com
 designates 74.125.83.46 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:from:to:references:subject:date:x-priority
         :x-msmail-priority:x-mailer:x-rfc2646:x-mimeole;
        b=EcKV+HvLlpBh2ID8BAz3QJB/P1i7TKEs8u7YBtp0yFUXw/aBsq99Iqthr6rNZMNfin
         hvZ3UFNJkAA4tpidqeLYajLr26IKcp3TZf80ZV7srnjOUXcsB4aRTmRFvrdGCXc3fuVR
         Hyb3VfGag+DHelv8gwsbvS5mNsBTiJjfalpTE=
Message-ID: <26DC6D448DCF43F3A6B75EDD0599173A@cn.ibm.com>
From: "Alex, Huang" <primemoxie@gmail.com>
To: <users@openjpa.apache.org>
References: 
 <98B9CE2F3DD544F1B3B61D843F814E3E@cn.ibm.com><AANLkTikPjS4nXyYFa_gu4oE9Gj2eFATbUk17oM5bbos6@mail.gmail.com><5E604528FEE248F8A59B607BD08FDB75@cn.ibm.com><AANLkTikV-uJ0n==DjMzV+21XgZbd3xVhun-CVSUEWW=7@mail.gmail.com><DD13DF5DA4B04EA1A43CCF20160856CA@cn.ibm.com><AANLkTik5vF19k2izuSXPMCV4YvpwJ5Gmk1FHJqLtxQs0@mail.gmail.com><48D23FDA34194668AD8E07065213E074@cn.ibm.com><AANLkTimh_wEuQrk5B+qsHewOTcDeJagu4tPrVXKy+AF=@mail.gmail.com><D2148370C5C54E1AB31FCFE6352D9C34@cn.ibm.com><AANLkTimzdDbs+gB92K4a9fnrEirD6GSNDkdmymK55GJ5@mail.gmail.com><9E98409B2B00451CBCDB88E5CF3FB01C@cn.ibm.com>
 <AANLkTim7AYmo2NGbdyjcbqu6BR7JkzWdLd=V807=1GU0@mail.gmail.com>
Subject: Re: Can't obtain Primary Key value by JPQL
Date: Fri, 5 Nov 2010 13:18:54 +0800

Hi Rick,

I got the reason. I always enhance entities by Eclipse plug-in.  After got 
your clue, I enhanced entities again by using command. And the problem 
disappeared.

Really thank you for all the help.
Alex, Huang

----- Original Message ----- 
From: "Rick Curtis" <curtisr7@gmail.com>
To: <users@openjpa.apache.org>
Sent: Friday, November 05, 2010 1:20 AM
Subject: Re: Can't obtain Primary Key value by JPQL


> How are you enhancing your Entities? If you are using build time, can you
> post the enhanced .class file?
>
> Thanks,
> Rick
>
> On Wed, Nov 3, 2010 at 8:32 PM, Alex, Huang <primemoxie@gmail.com> wrote:
>
>> Hi Rick,
>>
>> >How did you get the data into your DB?
>> I  insert data at mysql prompt.
>> ================================================
>> mysql> INSERT INTO t_user(name,age) VALUES ('John', 26);
>> Query OK, 1 row affected (0.03 sec)
>> ================================================
>>
>> Now,db's data like below,
>> ================================================
>> mysql> select * from t_user;
>> +-----+--------+-----+
>> | uid | name   | age |
>> +-----+--------+-----+
>> |   1 | Huang  |  26 |
>> |   2 | Alex   |  28 |
>> |   3 | tester |  22 |
>> |   4 | John   |  26 |
>> +-----+--------+-----+
>> 4 rows in set (0.00 sec)
>> ================================================
>>
>> >What happens if you call em.find(TUser.class, [known_id]) ?
>>
>> I run the following case, and it completed successful.
>> ================================================
>>  public void testFind(){
>>  EntityManager em = emf.createEntityManager();
>>  em.getTransaction().begin();
>>   TUser user  = em.find(TUser.class, 2);
>>  assertEquals("Alex", user.getName());
>>  assertEquals(28, user.getAge());
>>  }
>> ================================================
>>
>> After  I added "assertEquals(2,user.getUid());", AssertionFailedError
>> occured.
>> ================================================
>> junit.framework.AssertionFailedError: expected:<2> but was:<0>
>> ================================================
>>
>> >Could you try creating some data and persisting it via JPA?
>> OK.I added a method to test case.
>> ==========================================
>>  public void testInsert(){
>>   EntityManager em = emf.createEntityManager();
>>  em.getTransaction().begin();
>>   TUser user = new TUser();
>>  user.setName("Jeason");
>>  user.setAge(27);
>>  em.persist(user);
>>  em.getTransaction().commit();
>>  em.close();
>>  }
>> ==========================================
>>
>> I run the test case and it completed successful. At mysql prompt I
>> confirmed
>> the data has been created.
>>
>> ==========================================
>> mysql> select * from t_user;
>> +-----+--------+-----+
>> | uid | name   | age |
>> +-----+--------+-----+
>> |   1 | Huang  |  26 |
>> |   2 | Alex   |  28 |
>> |   3 | tester |  22 |
>> |   4 | John   |  26 |
>> |   5 | Jeason |  27 |
>> +-----+--------+-----+
>> 5 rows in set (0.00 sec)
>> ==========================================
>>
>> Look forward to your advance.
>> Alex,Huang
>> ----- Original Message -----
>> From: "Rick Curtis" <curtisr7@gmail.com>
>> To: <users@openjpa.apache.org>
>> Sent: Thursday, November 04, 2010 5:29 AM
>> Subject: Re: Can't obtain Primary Key value by JPQL
>>
>>
>> > That looks about identical to the test case that I came up with.
>> >
>> >> Any advice?
>> > I'm running low on ideas here...  How did you get the data into your 
>> > DB?
>> > What happens if you call em.find(TUser.class, [known_id]) ? Could you 
>> > try
>> > creating some data and persisting it via JPA?
>> >
>> > Thanks,
>> > Rick
>> >
>>
>>
>>
>