[BEANUTILS-383] `select name as foo_name' - > RowSetDynaClass detects false column name which causes java.sql.SQLException: Column 'name' not found.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.8.3
• Fix Version/s: 2.0.0

Environment

gentoo linux 64 bit

• Assignee: Unassigned
• Reporter: Kfir Ozer
• Created: 25/Nov/10 09:32
• Updated: 05/Dec/13 21:05

Description

Hello.

If i have the following query:
'select game.name as game_name from games'

and i use RowSetDynaClass to fetch a list of DynaBeans from the result set, i get the following error:

ERROR c.x.xpofacebook.mysql.MysqlDb - stack trace: java.sql.SQLException: Column 'name' not found.

it seems that the RowSetDynaClass fetches the column names as their original names and does not consider column names modification with the 'as' keyword.

Issue Links

• relates to: BEANUTILS-344 Method createDynaProperty of JDBCDynaClass should first look for column label instead of column name in ResultSetMetadata object..
• relates to: BEANUTILS-371 RowSetDynaClass.setUseColumnLabel() property setter is useless: the "use column label" flag must be known at construction time