Return-Path: 
 <camel-user-return-4090-apmail-activemq-camel-user-archive=activemq.apache.org@activemq.apache.org>
Delivered-To: apmail-activemq-camel-user-archive@locus.apache.org
Received: (qmail 90112 invoked from network); 3 Nov 2008 06:10:04 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 3 Nov 2008 06:10:04 -0000
Received: (qmail 9623 invoked by uid 500); 3 Nov 2008 06:10:11 -0000
Delivered-To: apmail-activemq-camel-user-archive@activemq.apache.org
Received: (qmail 9605 invoked by uid 500); 3 Nov 2008 06:10:10 -0000
Mailing-List: contact camel-user-help@activemq.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:camel-user-help@activemq.apache.org>
List-Unsubscribe: <mailto:camel-user-unsubscribe@activemq.apache.org>
List-Post: <mailto:camel-user@activemq.apache.org>
List-Id: <camel-user.activemq.apache.org>
Reply-To: camel-user@activemq.apache.org
Delivered-To: mailing list camel-user@activemq.apache.org
Received: (qmail 9594 invoked by uid 99); 3 Nov 2008 06:10:10 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Nov 2008 22:10:10 -0800
X-ASF-Spam-Status: No, hits=0.2 required=10.0
	tests=SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [195.69.129.177] (HELO exsmtp01.exserver.dk) (195.69.129.177)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Nov 2008 06:08:52 +0000
Received: from EXVS04.exserver.dk ([10.10.10.81]) by exsmtp01.exserver.dk with
 Microsoft SMTPSVC(6.0.3790.1830);
	 Mon, 3 Nov 2008 07:06:23 +0100
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: camel-jdbc sql statement with "select f1 as field1 .."
Date: Mon, 3 Nov 2008 07:08:16 +0100
Message-ID: <4C1FB9C00D24A140906239533638C4D205CDB3F1@EXVS04.exserver.dk>
In-Reply-To: <20293296.post@talk.nabble.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: camel-jdbc sql statement with "select f1 as field1 .."
Thread-Index: Ack9JiZ9SfEbJyU5Ro6oeik0HTDhegAVD++Q
From: "Claus Ibsen" <ci@silverbullet.dk>
To: <camel-user@activemq.apache.org>
X-OriginalArrivalTime: 03 Nov 2008 06:06:23.0418 (UTC)
 FILETIME=[4C6B61A0:01C93D7A]
X-Virus-Checked: Checked by ClamAV on apache.org

Hi

Have you tried to run the SQL in a SQL prompt (or editor such as =
DbVisualizer) to see if you get the same error there?

What database are you using?



Med venlig hilsen
=20
Claus Ibsen
......................................
Silverbullet
Skovsg=E5rdsv=E6nget 21
8362 H=F8rning
Tlf. +45 2962 7576
Web: www.silverbullet.dk
-----Original Message-----
From: Reda [mailto:matteo.redaelli@libero.it]=20
Sent: 2. november 2008 21:06
To: camel-user@activemq.apache.org
Subject: camel-jdbc sql statement with "select f1 as field1 .."


With
 <from uri=3D"timer://pollTheDatabase?delay=3D10000" />
   <setBody>
     <constant>select username as userid from mdl_user
          where firstname=3D'' or lastname =3D '' or email =3D '' or =
idnumber=3D''
     </constant>
   </setBody>
  <to uri=3D"jdbc:moodleDB" />

I get the error
  Column 'username' not found.

If I remove "as userid" the route works. How can add aliases for the
database column names?

Thanks
Matteo


--=20
View this message in context: =
http://www.nabble.com/camel-jdbc-sql-statement-with-%22select-f1-as-field=
1-..%22-tp20293296s22882p20293296.html
Sent from the Camel - Users mailing list archive at Nabble.com.