I can't see bar as column header in the result set for the following query. I always get foo.

select foo as 'bar' from mytable


In the MySQL JDBC driver 5.1 decided to change how their JDBC driver handle aliases. The workaround is to set the following driver property in the Connection properties under Driver Properties:

useOldAliasMetadataBehavior = true