[ http://issues.apache.org/jira/browse/DDLUTILS-3?page=comments#action_12317959 ]
Dave Sunerton-Burl commented on DDLUTILS-3: ------------------------------------------- Which of the supported databases has this been tested successfully on? > Column names are different case between getInstance and query in DynaSql > ------------------------------------------------------------------------ > > Key: DDLUTILS-3 > URL: http://issues.apache.org/jira/browse/DDLUTILS-3 > Project: DdlUtils > Type: Bug > Environment: HSQLDB > Reporter: Dave Sunerton-Burl > Assignee: Thomas Dudziak > > When getting a DynaBean using getInstance("TABLE_NAME") the property names > are uppercase. When getting a DynaBean from an Iterator using query("SELECT * > FROM TABLE_NAME") the properties are lowercase. This means that the copy() > method returns a DynaBean where all the properties are null, which makes > doing updates difficult. > I have a test method in my code which shows this problem; > public void testColumnNames() throws Exception { > JdbcModelReader reader = new JdbcModelReader(loaderDb.getDataSource() > .getConnection()); > Database database = reader.getDatabase(); > DynaSql dynaSql = new DynaSql( > SqlBuilderFactory.newSqlBuilder("hsqldb"), loaderDb > .getDataSource(), database); > DynaBean beanFromSchema = dynaSql.newInstance("TEST"); > Iterator iter = dynaSql.query("SELECT * FROM TEST"); > DynaBean beanFromQuery = (DynaBean) iter.next(); > assertEquals(beanFromSchema.getDynaClass().getDynaProperties()[0] > .getName(), > beanFromQuery.getDynaClass().getDynaProperties()[0] > .getName()); > } -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
