[
https://issues.apache.org/jira/browse/OODT-61?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13115809#comment-13115809
]
Ricky Nguyen commented on OODT-61:
----------------------------------
Seems like the real problem is that {{ResultSet#getString(String colName)}}
does not accept column names of the form "TABLE.COLUMN", but only "COLUMN".
This becomes problematic when 2 or more columns have the same name (resulting
from the JOIN). There are 2 ways around this:
# use {{ResultSet#getString(int colIndex)}}
# use column aliases when building the SQL statement (select colName as
colAlias ...)
Well, column aliases are exactly what MappingField provides!
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
