You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by Charles Moulliard <cm...@gmail.com> on 2011/03/23 17:00:17 UTC
camel-JPA and SELECT
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
Re: camel-JPA and SELECT
Posted by Charles Moulliard <cm...@gmail.com>.
Forget my email. That was an error with @entity configuration
On Wed, Mar 23, 2011 at 5:00 PM, Charles Moulliard <cm...@gmail.com> wrote:
> 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
>