In my experience, column indexes are kind of fragile - I prefer to alias the fields like this:
select customer.name as "customerName", product.name as "productName" from.... Larry On Dec 5, 2007 3:54 PM, Jeff Butler <[EMAIL PROTECTED]> wrote: > It's not magic, but you could also use columnIndex in your result map > instead of column - then you wouldn't need to do any renaming in the SQL > statement. > > Jeff Butler
