[ http://issues.apache.org/jira/browse/DDLUTILS-3?page=all ]
Thomas Dudziak updated DDLUTILS-3:
----------------------------------
Component: Core (No specific database)
> 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
> Components: Core (No specific database)
> 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
