Return-Path: X-Original-To: apmail-camel-users-archive@www.apache.org Delivered-To: apmail-camel-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5C3B5961E for ; Wed, 6 Jun 2012 21:19:16 +0000 (UTC) Received: (qmail 73540 invoked by uid 500); 6 Jun 2012 21:19:15 -0000 Delivered-To: apmail-camel-users-archive@camel.apache.org Received: (qmail 73500 invoked by uid 500); 6 Jun 2012 21:19:15 -0000 Mailing-List: contact users-help@camel.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@camel.apache.org Delivered-To: mailing list users@camel.apache.org Received: (qmail 73491 invoked by uid 99); 6 Jun 2012 21:19:15 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jun 2012 21:19:15 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of alexander.g.kaiser@gmail.com designates 209.85.212.173 as permitted sender) Received: from [209.85.212.173] (HELO mail-wi0-f173.google.com) (209.85.212.173) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jun 2012 21:19:08 +0000 Received: by wibhj6 with SMTP id hj6so4247590wib.2 for ; Wed, 06 Jun 2012 14:18:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=8AzLIT389o89XhvXm4kiOZi1PLfR24j/OjckJ+I6aLI=; b=ZMZ2NvX2JaspkgFlz8tR/lxukLoYTt6XPHlWP1Jf7ko1WCpyKAyThib+6XCMDcw0/a rCULYgo4f/SddFV4r2P3Im/i1BR8Kh7Io80M1qjkjt3gm8A1UchtZAlrij8sPxHBioag o3njJ19GHZg2WNh7FiwgiwKUXfK5jQY+3/7KTUt72wjK9526nFDeNkuNBFI0oGP2KMwI QhhcYmA8eECXmow6ycpEEiLZYUAfGnVNeahzoh9klqw6zKAJGUoKsH9ouoORivNal/OS doU+wVYEeZJ7hyWbP1EOezxeUPStac3v41fA4kk+aNQMorAujP0LvhX2c4RwxATIYpSr kTbg== MIME-Version: 1.0 Received: by 10.216.211.209 with SMTP id w59mr17507643weo.160.1339017523200; Wed, 06 Jun 2012 14:18:43 -0700 (PDT) Received: by 10.223.144.206 with HTTP; Wed, 6 Jun 2012 14:18:42 -0700 (PDT) Date: Wed, 6 Jun 2012 22:18:42 +0100 Message-ID: Subject: adding headers to a message based on a databse query From: Alexander Kaiser To: users@camel.apache.org Content-Type: multipart/alternative; boundary=0016e6dbea75d1841304c1d44fd8 --0016e6dbea75d1841304c1d44fd8 Content-Type: text/plain; charset=ISO-8859-1 Hi, I wonder whether it is possible to add message headers to a message based on the results of a jdbc query without writing a custom processor. E.g. I have a message with a header 'userid'. And I have a database table users which contains user's properties. Now I want to use the value of the userid header to query the database table users and add the columns received from the database as headers to the message. Further down the route I want to use the headers/properties recieved from the database to make routing decisions. -- Alexander --0016e6dbea75d1841304c1d44fd8--