You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@oodt.apache.org by "Chris A. Mattmann (JIRA)" <ji...@apache.org> on 2011/06/05 03:35:51 UTC
[jira] [Updated] (OODT-61) appendTableName property for mapping
files in XMLPS breaks columnname-based lookup in ResultSet
[ https://issues.apache.org/jira/browse/OODT-61?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris A. Mattmann updated OODT-61:
----------------------------------
Fix Version/s: (was: 0.3)
0.4
> appendTableName property for mapping files in XMLPS breaks columnname-based lookup in ResultSet
> -----------------------------------------------------------------------------------------------
>
> Key: OODT-61
> URL: https://issues.apache.org/jira/browse/OODT-61
> Project: OODT
> Issue Type: Bug
> Components: xmlps
> Affects Versions: 0.1-incubating
> Environment: Mac OS X 10.6, Java SDK 6, Tomcat 7, connecting to SQL Server and Oracle databases.
> Reporter: Dave Kale
> Assignee: Dave Kale
> Fix For: 0.4
>
> Original Estimate: 168h
> Remaining Estimate: 168h
>
> Basically, I introduced a bug when I added the appendTableName property to the map file reading stuff in XMLPS. The original goal of appendTableName was to help with disambiguation when joining tables with fields that have identical names. However, the way "appendTableName" is handled right now, XMLPS tries to used the table-appended field name to retrieve results from the ResultSet, producing the following error:
> Nov 17, 2010 10:48:11 AM org.apache.oodt.xmlps.product.DBMSExecutor toCDERow
> WARNING: Unable to obtain field: [TableName.FieldName] from result set: message: Invalid column name
> I propose that we do one of the following:
> 1. Make the simplest fix, which is not use the appended table name when looking up results in the ResultSet.
> 2. Get rid of the appendTableName property and instead make XMLPS handle disambiguation automatically: when it detects fields of the same name from different tables, it automatically appends table name when constructing queries in which the field shows up in the SELECT part of the query.
> 3. Other options?
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira