Hi, here is what I'm trying to do, but I'm not sure if I'm on the right track or not.
I have a inbound file that I want to process, and use it to either create or update existing rows in a table. I know I can do this using camel-jdbc, but I wanted to see if it can be done with jpa I know to use jpa with namedparameters I have to use it as a consumer. and I need to use jpa mid-route as a consumer, and namedparamters can only be set using registry. so I was thinking of flow like this from("direct:fileprocess") .//bindy to process file .process(new SetQueryIdProcessor) // to find the id in the current line of the file, and set it in registry .pollEnrich("jpa:" + Entity.class.getName() + "?consumeDelete=false&consumer.namedQuery=findById& consumer.parameters=#params") // to see if the record already exist and then based on that, either update existing record, or create new one. Am I on the right track? Is this doable or is camel-jdbc the only way? Thanks -- Omnem crede diem tibi diluxisse supremum.