Simple Select generates extra SQL statements to UPDATE Entities

[Pieter Pareit]

Hi,

A simple select statement generates update statements afterwards.

// ----------------------- CODE

EntityManagerFactory factory =
Persistence.createEntityManagerFactory("openjpa");              
EntityManager em = factory.createEntityManager();
em.getTransaction().begin();
                        
List<CompanyEffDate> rows = em.createQuery("SELECT c FROM CompanyEffDate as
c LEFT OUTER JOIN FETCH c.companyAddresses").getResultList();

for(CompanyEffDate companyEffDate : rows){
        System.out.println("companyName: "+ companyEffDate.getId());
        System.out.println("companyAddress size: "+
companyEffDate.getCompanyAddresses().size());
}

em.getTransaction().commit();
em.close();

// -------------- LOGGING
813  openjpa  TRACE  [TP-Processor3] openjpa.jdbc.SQL - <t 13468632, conn
640013
3> executing prepstmnt 17122634 SELECT t0.effectiveDate, t0.id, t0.name,
t1.comp
anyId, t1.effectiveDate, t1.id, t1.postal FROM company t0 LEFT OUTER JOIN
compan
yaddress t1 ON t0.id = t1.companyId ORDER BY t1.companyId ASC
819  openjpa  TRACE  [TP-Processor3] openjpa.jdbc.SQL - <t 13468632, conn
640013
3> [1 ms] spent
companyName: 19a06d80-3ca1-4ffa-8052-f4a88b1b66e1
companyAddress size: 0
companyName: b7977af7-c3f9-4e0b-a7f8-864886beec3e
companyAddress size: 1

911  openjpa  TRACE  [TP-Processor3] openjpa.jdbc.SQL - <t 13468632, conn
784712
5> executing prepstmnt 18220809 UPDATE companyaddress SET companyId = ?,
postal
= ? WHERE effectiveDate = ? AND id = ? [params=(String)
b7977af7-c3f9-4e0b-a7f8-
864886beec3e, (String) 1000, (Timestamp) 2009-08-26 15:38:42.0, (String)
89c30f0
e-4c83-4560-a92f-87165154a6b4]
919  openjpa  TRACE  [TP-Processor3] openjpa.jdbc.SQL - <t 13468632, conn
784712
5> [0 ms] spent
923  openjpa  TRACE  [TP-Processor3] openjpa.jdbc.SQL - <t 13468632, conn
784712
5> executing prepstmnt 17721367 UPDATE company SET name = ? WHERE
effectiveDate
= ? AND id = ? [params=(String) Ignacio Andreu, (Timestamp) 2009-08-26
15:38:42.
0, (String) b7977af7-c3f9-4e0b-a7f8-864886beec3e]
929  openjpa  TRACE  [TP-Processor3] openjpa.jdbc.SQL - <t 13468632, conn
784712
5> [1 ms] spent
932  openjpa  TRACE  [TP-Processor3] openjpa.jdbc.SQL - <t 13468632, conn
784712
5> executing prepstmnt 13889218 UPDATE company SET name = ? WHERE
effectiveDate
= ? AND id = ? [params=(String) Ignacio Andreu, (Timestamp) 2009-08-26
15:39:02.
0, (String) 19a06d80-3ca1-4ffa-8052-f4a88b1b66e1]
939  openjpa  TRACE  [TP-Processor3] openjpa.jdbc.SQL - <t 13468632, conn
784712
5> [1 ms] spent

Thanks in advance,
Pieter Pareit
http://www.easypay-group.com

-- 
View this message in context: 
http://n2.nabble.com/Simple-Select-generates-extra-SQL-statements-to-UPDATE-Entities-tp3521916p3521916.html
Sent from the OpenJPA Developers mailing list archive at Nabble.com.