Hi,
I try to create a camel route to fetch records from a DB
Here is the route
<route id="trigger-database">
<from
uri="jpa://com.fusesource.webinars.persistence.model.Incident"/>
<split>
<simple>${body}</simple>
<log message=">>> Select all : ${body}"/>
</split>
</route>
and the log
INFO: Apache Camel 2.6.0 (CamelContext: camel) started in 1.164 seconds
2218 reportincident INFO [Camel (camel) thread #0 -
jpa://com.fusesource.webinars.persistence.model.Incident]
openjpa.Runtime - Starting OpenJPA 2.1.0
2650 reportincident TRACE [Camel (camel) thread #0 -
jpa://com.fusesource.webinars.persistence.model.Incident]
openjpa.jdbc.SQL - <t 1239788402, conn 89845573> executing stmnt
2097118307 DELETE FROM Incident
2650 reportincident TRACE [Camel (camel) thread #0 -
jpa://com.fusesource.webinars.persistence.model.Incident]
openjpa.jdbc.SQL - <t 1239788402, conn 89845573> [0 ms] spent
2651 reportincident TRACE [Camel (camel) thread #0 -
jpa://com.fusesource.webinars.persistence.model.Incident]
openjpa.jdbc.SQL - <t 1239788402, conn 89845573> executing stmnt
1952466133 DELETE FROM OPENJPA_SEQUENCE_TABLE
2651 reportincident TRACE [Camel (camel) thread #0 -
jpa://com.fusesource.webinars.persistence.model.Incident]
openjpa.jdbc.SQL - <t 1239788402, conn 89845573> [0 ms] spent
2811 reportincident INFO [Camel (camel) thread #0 -
jpa://com.fusesource.webinars.persistence.model.Incident]
openjpa.Runtime - The Entity
"com.fusesource.webinars.persistence.model.Incident" was enhanced at
level "2", but the current level of enhancement is "1,055,128".
2813 reportincident INFO [Camel (camel) thread #0 -
jpa://com.fusesource.webinars.persistence.model.Incident]
openjpa.Runtime - A down level Entity was detected and logged. Please
enable RUNTIME trace to see all down level Entities.
2895 reportincident TRACE [Camel (camel) thread #0 -
jpa://com.fusesource.webinars.persistence.model.Incident]
openjpa.jdbc.SQL - <t 1239788402, conn 1942438914> executing prepstmnt
470193061 SELECT t0.incidentId, t0.CREATION_DATE, t0.CREATION_USER,
t0.DETAILS, t0.EMAIL, t0.FAMILY_NAME, t0.GIVEN_NAME, t0.INCIDENT_DATE,
t0.INCIDENT_REF, t0.PHONE, t0.SUMMARY FROM Incident t0
2896 reportincident TRACE [Camel (camel) thread #0 -
jpa://com.fusesource.webinars.persistence.model.Incident]
openjpa.jdbc.SQL - <t 1239788402, conn 1942438914> [1 ms] spent
2928 reportincident TRACE [Camel (camel) thread #0 -
jpa://com.fusesource.webinars.persistence.model.Incident]
openjpa.jdbc.SQL - <t 1239788402, conn 2032204138> executing prepstmnt
2086912306 SELECT t0.incidentId, t0.CREATION_DATE, t0.CREATION_USER,
t0.DETAILS, t0.EMAIL, t0.FAMILY_NAME, t0.GIVEN_NAME, t0.INCIDENT_DATE,
t0.INCIDENT_REF, t0.PHONE, t0.SUMMARY FROM Incident t0
2928 reportincident TRACE [Camel (camel) thread #0 -
jpa://com.fusesource.webinars.persistence.model.Incident]
openjpa.jdbc.SQL - <t 1239788402, conn 2032204138> [0 ms] spent
3
The JPA component starts to poll but no info is send through an
exchange in the log!!
Regards,
Charles Moulliard
Sr. Principal Solution Architect - FuseSource
Apache Committer
Blog : http://cmoulliard.blogspot.com
Twitter : http://twitter.com/cmoulliard
Linkedin : http://www.linkedin.com/in/charlesmoulliard
Skype: cmoulliard
