camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Moulliard <cmoulli...@gmail.com>
Subject camel-bam (Hibernate vs Openjpa)
Date Tue, 08 Dec 2009 16:30:49 GMT
JPA implementation is radically different between Hibernate and openjpa.

Here is a snapshot of what happens in the transaction who will save the
ProcessDefinition

    protected ProcessDefinition findOrCreateProcessDefinition() {
        Map<String, Object> params = new HashMap<String, Object>(1);
        params.put("name", processName);

        List<ProcessDefinition> list =
CastUtils.cast(jpaTemplate.findByNamedParams("select x from "
            + ProcessDefinition.class.getName() + " x where x.name = :name",
params));
        if (!list.isEmpty()) {
            LOG.info(">> list not empty - Definition : " +
list.get(0).toString() + ", name : " + list.get(0).getName() + ", id : " +
list.get(0).getId());
            return list.get(0);
        } else {
            ProcessDefinition answer = new ProcessDefinition();
            answer.setName(processName);
            LOG.info(">> before persist Definition : " + answer.toString() +
", name : " + answer.getName() + ", id : " + answer.getId());
            jpaTemplate.persist(answer);

            list = CastUtils.cast(jpaTemplate.find("select p from " +
ProcessDefinition.class.getName() +" p "));
            LOG.info(">> Definition name : " + list.get(0).getName() + ", id
: " + list.get(0).getId());
            LOG.info(">> after persist Definition : ");
            return answer;
        }
    }



1) openjpa


2009-12-08 17:24:43,168 [main           ] INFO
ProcessBuilder                 - >> before persist Definition :
org.apache.camel.bam.model.ProcessDefinition[null], name : Process-1, id :
null
2009-12-08 17:24:43,184 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Initiating transaction commit
2009-12-08 17:24:43,184 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Committing JPA transaction on EntityManager
[org.apache.openjpa.persistence.EntityManagerImpl@6ffd79]
2009-12-08 17:24:43,184 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Closing JPA EntityManager
[org.apache.openjpa.persistence.EntityManagerImpl@6ffd79] after transaction
2009-12-08 17:24:43,184 [tyMonitorEngine] DEBUG
EntityManagerFactoryUtils      - Closing JPA EntityManager
2009-12-08 17:24:43,184 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Creating new transaction with name [null]:
PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2009-12-08 17:24:43,184 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Opened new EntityManager
[org.apache.openjpa.persistence.EntityManagerImpl@f38cf0] for JPA
transaction
2009-12-08 17:24:43,184 [tyMonitorEngine] TRACE
SQL                            - <t 15040737, conn 23149395> executing
prepstmnt 31361704 SELECT t0.id, t0.ACTIVITYDEFINITION_ID,
t0.escalationLevel, t0.PROCESSINSTANCE_CORRELATIONKEY,
t0.receivedMessageCount, t0.timeExpected, t0.timeOverdue FROM
CAMEL_ACTIVITYSTATE t0 WHERE (t0.timeOverdue < ?) [params=(Time) 17:24:43]
2009-12-08 17:24:43,184 [tyMonitorEngine] TRACE
SQL                            - <t 15040737, conn 23149395> [0 ms] spent
2009-12-08 17:24:43,184 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Initiating transaction commit
2009-12-08 17:24:43,184 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Committing JPA transaction on EntityManager
[org.apache.openjpa.persistence.EntityManagerImpl@f38cf0]
2009-12-08 17:24:43,184 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Closing JPA EntityManager
[org.apache.openjpa.persistence.EntityManagerImpl@f38cf0] after transaction
2009-12-08 17:24:43,184 [tyMonitorEngine] DEBUG
EntityManagerFactoryUtils      - Closing JPA EntityManager
2009-12-08 17:24:43,184 [tyMonitorEngine] DEBUG
ActivityMonitorEngine          - Sleeping for 1000 millis
2009-12-08 17:24:43,246 [main           ] TRACE
Runtime                        - Updating sequence values.
2009-12-08 17:24:43,246 [main           ] TRACE
Runtime                        - Getting current sequence values.
2009-12-08 17:24:43,246 [main           ] TRACE
SQL                            - <t 14043096, conn 16703414> executing
prepstmnt 4123674 SELECT SEQUENCE_VALUE FROM OPENJPA_SEQUENCE_TABLE WHERE ID
= ? [params=(int) 0]
2009-12-08 17:24:43,246 [main           ] TRACE
SQL                            - <t 14043096, conn 16703414> [0 ms] spent
2009-12-08 17:24:43,246 [main           ] TRACE
Runtime                        - Inserting row for this mapping into
sequence table.
2009-12-08 17:24:43,246 [main           ] TRACE
SQL                            - <t 14043096, conn 32633742> executing
prepstmnt 17912146 INSERT INTO OPENJPA_SEQUENCE_TABLE (ID, SEQUENCE_VALUE)
VALUES (?, ?) [params=(int) 0, (int) 1]
2009-12-08 17:24:43,246 [main           ] TRACE
SQL                            - <t 14043096, conn 32633742> [0 ms] spent
2009-12-08 17:24:43,246 [main           ] TRACE
Runtime                        - Updating sequence values.
2009-12-08 17:24:43,246 [main           ] TRACE
Runtime                        - Getting current sequence values.
2009-12-08 17:24:43,246 [main           ] TRACE
SQL                            - <t 14043096, conn 16183734> executing
prepstmnt 28117049 SELECT SEQUENCE_VALUE FROM OPENJPA_SEQUENCE_TABLE WHERE
ID = ? [params=(int) 0]
2009-12-08 17:24:43,246 [main           ] TRACE
SQL                            - <t 14043096, conn 16183734> [0 ms] spent
2009-12-08 17:24:43,246 [main           ] TRACE
SQL                            - <t 14043096, conn 16183734> executing
prepstmnt 7806641 UPDATE OPENJPA_SEQUENCE_TABLE SET SEQUENCE_VALUE = ? WHERE
ID = ? AND SEQUENCE_VALUE = ? [params=(long) 51, (int) 0, (long) 1]
2009-12-08 17:24:43,262 [main           ] TRACE
SQL                            - <t 14043096, conn 16183734> [16 ms] spent
2009-12-08 17:24:43,278 [main           ] TRACE
SQL                            - <t 14043096, conn 31352855> executing
prepstmnt 1732792 INSERT INTO CAMEL_PROCESSDEFINITION (id, name) VALUES (?,
?) [params=(long) 1, (null) null]
2009-12-08 17:24:43,278 [main           ] TRACE
SQL                            - <t 14043096, conn 31352855> [0 ms] spent
2009-12-08 17:24:43,278 [main           ] TRACE
SQL                            - <t 14043096, conn 31352855> executing
prepstmnt 13969258 SELECT t0.id, t0.name FROM CAMEL_PROCESSDEFINITION t0
2009-12-08 17:24:43,278 [main           ] TRACE
SQL                            - <t 14043096, conn 31352855> [0 ms] spent
2009-12-08 17:24:43,278 [main           ] DEBUG
TransactionTemplate            - Initiating transaction rollback on
application exception
java.lang.NullPointerException
    at
org.apache.openjpa.kernel.StateManagerImpl.beforeRead(StateManagerImpl.java:939)
    at
org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManagerImpl.java:1479)
    at
org.apache.camel.bam.model.ProcessDefinition.getName(ProcessDefinition.java)
    at
org.apache.camel.bam.ProcessBuilder.findOrCreateProcessDefinition(ProcessBuilder.java:216)
    at
org.apache.camel.bam.ProcessBuilder.getProcessDefinition(ProcessBuilder.java:145)
    at
org.apache.camel.bam.ProcessBuilder$1.doInTransactionWithoutResult(ProcessBuilder.java:103)
    at
org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
    at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)

2) Hibernate

2009-12-08 17:19:18,496 [main           ] INFO
ProcessBuilder                 - >> before persist Definition :
org.apache.camel.bam.model.ProcessDefinition[null], name : Process-1, id :
null
2009-12-08 17:19:18,496 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Creating new transaction with name [null]:
PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2009-12-08 17:19:18,496 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Opened new EntityManager
[org.hibernate.ejb.EntityManagerImpl@120cb3] for JPA transaction
2009-12-08 17:19:18,512 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Initiating transaction commit
2009-12-08 17:19:18,512 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Committing JPA transaction on EntityManager
[org.hibernate.ejb.EntityManagerImpl@120cb3]
2009-12-08 17:19:18,512 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Closing JPA EntityManager
[org.hibernate.ejb.EntityManagerImpl@120cb3] after transaction
2009-12-08 17:19:18,512 [tyMonitorEngine] DEBUG
EntityManagerFactoryUtils      - Closing JPA EntityManager
2009-12-08 17:19:18,512 [tyMonitorEngine] DEBUG
ActivityMonitorEngine          - Sleeping for 984 millis
2009-12-08 17:19:18,684 [main           ] INFO
ProcessBuilder                 - >> after persist Definition :

2009-12-08 17:22:22,293 [main           ] INFO
ProcessBuilder                 - >> before persist Definition :
org.apache.camel.bam.model.ProcessDefinition[null], name : Process-1, id :
null
2009-12-08 17:22:22,293 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Initiating transaction commit
2009-12-08 17:22:22,293 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Committing JPA transaction on EntityManager
[org.hibernate.ejb.EntityManagerImpl@6fdca5]
2009-12-08 17:22:22,293 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Closing JPA EntityManager
[org.hibernate.ejb.EntityManagerImpl@6fdca5] after transaction
2009-12-08 17:22:22,293 [tyMonitorEngine] DEBUG
EntityManagerFactoryUtils      - Closing JPA EntityManager
2009-12-08 17:22:22,309 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Creating new transaction with name [null]:
PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2009-12-08 17:22:22,325 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Opened new EntityManager
[org.hibernate.ejb.EntityManagerImpl@10699ea] for JPA transaction
2009-12-08 17:22:22,325 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Initiating transaction commit
2009-12-08 17:22:22,325 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Committing JPA transaction on EntityManager
[org.hibernate.ejb.EntityManagerImpl@10699ea]
2009-12-08 17:22:22,325 [tyMonitorEngine] DEBUG
JpaTransactionManager          - Closing JPA EntityManager
[org.hibernate.ejb.EntityManagerImpl@10699ea] after transaction
2009-12-08 17:22:22,325 [tyMonitorEngine] DEBUG
EntityManagerFactoryUtils      - Closing JPA EntityManager
2009-12-08 17:22:22,325 [tyMonitorEngine] DEBUG
ActivityMonitorEngine          - Sleeping for 984 millis
2009-12-08 17:22:22,528 [main           ] INFO
ProcessBuilder                 - >> Definition name : Process-1, id : 1
2009-12-08 17:22:22,528 [main           ] INFO
ProcessBuilder                 - >> after persist Definition :

Regards,

Charles Moulliard
Senior Enterprise Architect
Apache Camel Committer

*****************************
blog : http://cmoulliard.blogspot.com
twitter : http://twitter.com/cmoulliard
Linkedlin : http://www.linkedin.com/in/charlesmoulliard

Apache Camel Group :
http://www.linkedin.com/groups?home=&gid=2447439&trk=anet_ug_hm

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message