Re: ResultSetMetaData enhancements

[Kris Jurka <books(at)ejurka(dot)com>]

On Mon, 12 Jul 2004, ow wrote:

> Yes, rsmd.getTableName() appears to work. However, I was under
> impression that the folowing should also work (but it does not):
> 
> someValue = rs.getXXX("table.column"); // instead of just rs.getXXX("column")
> 
> This would be usefull if result set contained two columns from different
> tables with the same name.
> 

It actually isn't rs.getXXX("column"), it's the alias given to a select 
output.  Note that "SELECT a AS b FROM tab" will need to use 
rs.getXXX("b"), not "a".  There are some rules for coming up with a 
default alias which make the column name the alias for plain 
columns without aliases.

Adding the tablename to the getXXX method doesn't seem any cleaner to me 
than providing a select alias for the column and actually would have some 
implementation issues.  Notably column names are allowed to have a . in 
them, so how would you know when someone was providing a table name.

Kris Jurka