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
 lists+1214986160035-208411@n2.nabble.com designates 216.139.236.158 as
 permitted sender)
Date: Fri, 18 Sep 2009 08:17:34 -0700 (PDT)
From: ecerulm <ruben.laguna@gmail.com>
To: users@openjpa.apache.org
Message-ID: <1253287054302-3670456.post@n2.nabble.com>
Subject: OpenJPA generates extra UPDATEs
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Hi, 

I have the following snippet of code 


        EntityManagerFactory emf =
Persistence.createEntityManagerFactory("persistencexmltest1PU");
        EntityManager em = emf.createEntityManager();        
        for (int i = 0; i < 10; i++) {
            em.getTransaction().begin();
            MyEntity n =new MyEntity();
            n.setValue(i);
            em.persist(n);        
            em.getTransaction().commit();
            //em.clear(); //This shouldn't be needed, right?
        }


And OpenJPA 1.2.0 (with HSQLDB) is generating 

INSERT INTO MYTABLE (ID, VALUE, CREATED) VALUES (?, ?, ?) [params=(int) 1,
(int) 0, (null) null]
INSERT INTO MYTABLE (ID, VALUE, CREATED) VALUES (?, ?, ?) [params=(int) 2,
(int) 1, (null) null]
UPDATE MYTABLE SET CREATED = ? WHERE ID = ? [params=(null) null, (int) 1]
INSERT INTO MYTABLE (ID, VALUE, CREATED) VALUES (?, ?, ?) [params=(int) 3,
(int) 2, (null) null]
UPDATE MYTABLE SET CREATED = ? WHERE ID = ? [params=(null) null, (int) 2]
UPDATE MYTABLE SET CREATED = ? WHERE ID = ? [params=(null) null, (int) 1]


The MyEntity entity IS enhanced so I guess that
https://issues.apache.org/jira/browse/OPENJPA-546 doesn't apply. 

If I call EntityManager.clear() after the commit then the issue is fixed.
But is this the expected behaviour? OpenJPA is generating SQL updates for
unchanged entities within the transaction, that is not what I was expecting. 

For me, this started when I added a @Temporal(TemporalType.TIMESTAMP) field
to the entity (MyEntity). With a "simpler" entity I get only INSERTs (no
UPDATEs). 


http://rubenlaguna.com/wp/2009/09/18/openjpa-generated-sql-contains-extra-updates/


-- 
View this message in context: http://n2.nabble.com/OpenJPA-generates-extra-UPDATEs-tp3670456p3670456.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.