Hi Camel uses the ResultSetMetaData to get the column name. And this is apparently where the alias and column name conflicts.
Could you create a ticket in the bug tracker, so we can investigate and find a solution? I am sure others using MySQL and plain JDBC would have found a solution to this. http://activemq.apache.org/camel/support.html The source is in: camel-jdbc/.../JdbcProducer.java http://activemq.apache.org/camel/source.html Med venlig hilsen Claus Ibsen ...................................... Silverbullet Skovsgårdsvænget 21 8362 Hørning Tlf. +45 2962 7576 Web: www.silverbullet.dk -----Original Message----- From: Reda [mailto:[EMAIL PROTECTED] Sent: 3. november 2008 09:01 To: [email protected] Subject: RE: camel-jdbc sql statement with "select f1 as field1 .." Yes, the SQL statement works with mysql client and with camel-iBatis component... I'm using mysql <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.6</version> </dependency> -- View this message in context: http://www.nabble.com/camel-jdbc-sql-statement-with-%22select-f1-as-field1-..%22-tp20293296s22882p20298556.html Sent from the Camel - Users mailing list archive at Nabble.com.
