Hi everyone,
I'm all new to Camel and after getting documentation, I went directly to the
ETL example because it really looks like what I'm trying to do.
So I just did mvn compile, which worked (everything did in the directory
where the POM is).
And then I tried mvn camel:run and I get a problem : it looks like the same
message get displayed over and over again.
"*2014-06-13 11:07:52,094 [.CustomerEntity] INFO Tracer
-
ID-ITEM-93866-58463-1402650414339-0-78 >>> (route2)
from(jpa://org.apache.camel
.example.etl.CustomerEntity?consumeDelete=false&consumeLockEntity=false&delay=30
00) --> setHeader[CamelFileName] <<< Pattern:InOnly,
Headers:{CamelEntityManager
=org.apache.openjpa.persistence.EntityManagerImpl@5d84d74b,
breadcrumbId=ID-ITEM
-93866-58463-1402650414339-0-77},
BodyType:org.apache.camel.example.etl.Customer
Entity, Body:<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customer id="1">
<userName>james</userName>
<firstName>James</firstName>
<surname>Strachan</surname>
<city>London</city>
</customer>*
2014-06-13 11:07:52,096 [.CustomerEntity] INFO Tracer
-
ID-ITEM-93866-58463-1402650414339-0-78 >>> (route2)
setHeader[CamelFileName] --
> file://target/customers <<< Pattern:InOnly,
> Headers:{breadcrumbId=ID-ITEM-9386
6-58463-1402650414339-0-77, CamelFileName=james.xml,
CamelEntityManager=org.apac
he.openjpa.persistence.EntityManagerImpl@5d84d74b},
BodyType:org.apache.camel.ex
ample.etl.CustomerEntity, Body:<?xml version="1.0" encoding="UTF-8"
standalone="
yes"?>
<customer id="1">
<userName>james</userName>
<firstName>James</firstName>
<surname>Strachan</surname>
<city>London</city>
</customer>
2014-06-13 11:07:52,136 [.CustomerEntity] INFO Tracer
-
ID-ITEM-93866-58463-1402650414339-0-80 >>> (route2)
from(jpa://org.apache.camel
.example.etl.CustomerEntity?consumeDelete=false&consumeLockEntity=false&delay=30
00) --> setHeader[CamelFileName] <<< Pattern:InOnly,
Headers:{CamelEntityManager
=org.apache.openjpa.persistence.EntityManagerImpl@5d84d74b,
breadcrumbId=ID-ITEM
-93866-58463-1402650414339-0-79},
BodyType:org.apache.camel.example.etl.Customer
Entity, Body:<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customer id="2">
<userName>hiram</userName>
<firstName>Hiram</firstName>
<surname>Chirino</surname>
<city>Tampa</city>
</customer>
2014-06-13 11:07:52,137 [.CustomerEntity] INFO Tracer
-
ID-ITEM-93866-58463-1402650414339-0-80 >>> (route2)
setHeader[CamelFileName] --
> file://target/customers <<< Pattern:InOnly,
> Headers:{CamelEntityManager=org.ap
ache.openjpa.persistence.EntityManagerImpl@5d84d74b,
breadcrumbId=ID-ITEM-93866-
58463-1402650414339-0-79, CamelFileName=hiram.xml},
BodyType:org.apache.camel.ex
ample.etl.CustomerEntity, Body:<?xml version="1.0" encoding="UTF-8"
standalone="
yes"?>
<customer id="2">
<userName>hiram</userName>
<firstName>Hiram</firstName>
<surname>Chirino</surname>
<city>Tampa</city>
</customer>
60513 camel TRACE [Camel (camel) thread #1 -
jpa://org.apache.camel.example.e
tl.CustomerEntity] openjpa.jdbc.SQL - <t 53213167, conn 227180630> executing
pre
pstmnt 882159474
SELECT t0.id, t0.city, t0.firstName, t0.phone, t0.street, t0.surname,
t0.userName, t0.zip
FROM customer t0
60514 camel TRACE [Camel (camel) thread #1 -
jpa://org.apache.camel.example.e
tl.CustomerEntity] openjpa.jdbc.SQL - <t 53213167, conn 227180630> [0 ms]
spent
*2014-06-13 11:07:55,165 [.CustomerEntity] INFO Tracer
-
ID-ITEM-93866-58463-1402650414339-0-82 >>> (route2)
from(jpa://org.apache.camel
.example.etl.CustomerEntity?consumeDelete=false&consumeLockEntity=false&delay=30
00) --> setHeader[CamelFileName] <<< Pattern:InOnly,
Headers:{breadcrumbId=ID-IT
EM-93866-58463-1402650414339-0-81,
CamelEntityManager=org.apache.openjpa.persist
ence.EntityManagerImpl@5d84d74b},
BodyType:org.apache.camel.example.etl.Customer
Entity, Body:<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customer id="1">
<userName>james</userName>
<firstName>James</firstName>
<surname>Strachan</surname>
<city>London</city>
</customer>*
2014-06-13 11:07:55,167 [.CustomerEntity] INFO Tracer
-
ID-ITEM-93866-58463-1402650414339-0-82 >>> (route2)
setHeader[CamelFileName] --
> file://target/customers <<< Pattern:InOnly,
> Headers:{breadcrumbId=ID-ITEM-9386
6-58463-1402650414339-0-81, CamelFileName=james.xml,
CamelEntityManager=org.apac
he.openjpa.persistence.EntityManagerImpl@5d84d74b},
BodyType:org.apache.camel.ex
ample.etl.CustomerEntity, Body:<?xml version="1.0" encoding="UTF-8"
standalone="
yes"?>
<customer id="1">
<userName>james</userName>
<firstName>James</firstName>
<surname>Strachan</surname>
<city>London</city>
</customer>
2014-06-13 11:07:55,196 [.CustomerEntity] INFO Tracer
-
ID-ITEM-93866-58463-1402650414339-0-84 >>> (route2)
from(jpa://org.apache.camel
.example.etl.CustomerEntity?consumeDelete=false&consumeLockEntity=false&delay=30
00) --> setHeader[CamelFileName] <<< Pattern:InOnly,
Headers:{breadcrumbId=ID-IT
EM-93866-58463-1402650414339-0-83,
CamelEntityManager=org.apache.openjpa.persist
ence.EntityManagerImpl@5d84d74b},
BodyType:org.apache.camel.example.etl.Customer
Entity, Body:<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customer id="2">
<userName>hiram</userName>
<firstName>Hiram</firstName>
<surname>Chirino</surname>
<city>Tampa</city>
</customer>
2014-06-13 11:07:55,198 [.CustomerEntity] INFO Tracer
-
ID-ITEM-93866-58463-1402650414339-0-84 >>> (route2)
setHeader[CamelFileName] --
> file://target/customers <<< Pattern:InOnly,
> Headers:{CamelEntityManager=org.ap
ache.openjpa.persistence.EntityManagerImpl@5d84d74b,
CamelFileName=hiram.xml, br
eadcrumbId=ID-ITEM-93866-58463-1402650414339-0-83},
BodyType:org.apache.camel.ex
ample.etl.CustomerEntity, Body:<?xml version="1.0" encoding="UTF-8"
standalone="
yes"?>
<customer id="2">
<userName>hiram</userName>
<firstName>Hiram</firstName>
<surname>Chirino</surname>
<city>Tampa</city>
</customer>
"
The two bold parts are the exact same ones.
Plus I'm really confused about what the example is supposed to do. Isn't it
supposed to create the java classes ? Or am I completely wrong ?
Else, isn't it supposed to create the persons in my database ? How do I see
if it has been done ?
Thanks a lot for your answers.
--
View this message in context:
http://camel.465427.n5.nabble.com/Problem-with-ETL-example-tp5752256.html
Sent from the Camel - Users mailing list archive at Nabble.com.