Yes. You can set up your EntityManager using Spring/Blueprint and inject it into your bean. In your bean you can use the EntityManager to query/update/create entities. IMO, it's simpler to do it in this way instead of modeling a Camel route which query the database first, use a CBR to route the message and update/create an entity.
Best, Christian On Mon, Jan 21, 2013 at 8:56 PM, Chris Wolf <cwolf.a...@gmail.com> wrote: > Hello Christian, > > So forget about the "jpa:" endpoint and just do the persistence and > conditional logic, including > getting the EntityManager within the bean? > > Thanks, > > -Chris > > On Mon, Jan 21, 2013 at 1:42 PM, Christian Müller > <christian.muel...@gmail.com> wrote: > > I would do this all together in a single bean... > > > > Best, > > Christian > > > > Sent from a mobile device > > Am 21.01.2013 18:12 schrieb "Chris Wolf" <cwolf.a...@gmail.com>: > > > >> I recently changed a schema to be more normalized by factoring out a > >> column of type varchar2 that takes one of only a few dozen, but long > >> values, > >> so I created a lookup table for these strings and replaced the > >> sting-valued column in the main entity with a foreign-key valued > >> column, referencing > >> the lookup table. > >> > >> So now when I persist the main entity, I need to perform a lookup in > >> the string lookup table and only create a new lookup entity if there's > >> no entry, otherwise > >> set the main entity's lookup ref to the PK of the found, matched > >> string. How can I do this in the jpa producer without introducing > >> EntityManager/Query code > >> in the entity or some pre-processing bean? > >> > >> Thanks, > >> > >> > >> Chris > >> > --