db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-3) Column names are different case between getInstance and query in DynaSql
Date Tue, 09 Aug 2005 21:51:35 GMT
    [ http://issues.apache.org/jira/browse/DDLUTILS-3?page=comments#action_12318233 ] 

Thomas Dudziak commented on DDLUTILS-3:
---------------------------------------

I've tested the new Derby release, and it returns the table names. In this case, DdlUtils
is able to map the returned column names to the column names defined in the database schema.
This even works for joins (with Derby at least) as an additional unit test shows.

> 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


Mime
View raw message