Table alias in results map.

2006-03-29 Thread Daniel Pitts
I want to perform a query like: select id=getData resultClass=map parameterClass=string Select * FROM data AS `root:data` JOIN other AS `root:other` JOIN something as `root:other:something` WHERE $where$ /select The tables data, other, and something may or may not have similarly named columns.

Re: Table alias in results map.

2006-03-29 Thread Jeff Butler
Short answer - no. Only the column name is returned in the result set. This is JDBC, not just iBATIS. Run the query in something like the Squirrel SQL client to verify. A better solution would be to use a real domain object instead of a map, and use iBATIS' group by and descriminator support.