incubator-oodt-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dave Kale (JIRA)" <j...@apache.org>
Subject [jira] Updated: (OODT-29) Import (ERNE) XMLPS component
Date Mon, 13 Sep 2010 06:21:34 GMT

     [ https://issues.apache.org/jira/browse/OODT-29?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Dave Kale updated OODT-29:
--------------------------

    Attachment: oodt-xmlps+grid_ignore_target.diff

XMLPS successfully converted to new Apache namespace, along with the following four changes
and two caveats:

1. Added Apache License headers, though RAT still breaks when you try to do "mvn install."
 Something about unapproved licenses.  Really annoying.  I was very tempted to comment out
the RAT lines in the pom file... :-D

2. Removed references to ERNE/EDRN and renamed things when appropriate.

3. Removed unit tests because they depended on access to an ERNE/EDRN database!  Needs new
unit tests!

4. Modified the MappingReader, Mapping, etc., to have one additional tag for the field element:
a boolean called "apptabname" that tells the code assembling the SQL query whether to append
the table name to the field name.  This affects not only the SQL query but also the string
keys that are used to retrieve results from the ResultSet (or whatever it's called...too tired
to remember...); for our database, the query

SELECT TableName.FieldName FROM TableName

would give results, but the column name was just "FieldName," which meant that the following
line in DBMSExecutor:

CDERow row = toCDERow(rs, map, returnNames);

returned nulls.  Now you can configure this behavior.  I recommend changing the tag, though;
"apptabname" is pretty inscrutable.

CAVEAT #1: I'm new to maven, so please check the pom file with a fine-toothed comb.

CAVEAT #2: This builds and has been successfully used on our database, but by all means please
check it and test it, because I made the changes in a hurry!

> Import (ERNE) XMLPS component
> -----------------------------
>
>                 Key: OODT-29
>                 URL: https://issues.apache.org/jira/browse/OODT-29
>             Project: OODT
>          Issue Type: Task
>          Components: product server, profile server
>         Environment: XML configurable Product- and Profile- server package for connecting
to databases
>            Reporter: Dave Kale
>             Fix For: 0.1-incubating
>
>         Attachments: oodt-xmlps+grid_ignore_target.diff
>
>   Original Estimate: 120h
>  Remaining Estimate: 120h
>
> Another CHLA/JPL motivated task.  Many of our data sources reside in databases (welcome
to health IT...everything lives in normalized M$ SQL servers).  The XMLPS package from ERNE
makes it easy to deploy rapidly product servers, profile servers, and query handlers by separating
the mechanisms for setting up connections, parsing queries, etc. (which lives in java code)
from the data definitions, i.e., table names, field names, etc. (which are defined in XML-based
configuration files).  This probably requires the web-grid component, as well.
> In fact, I am almost done with this task!  I have ported the code to the apache namespace
and removed or generalized ERNE-specific naming conventions.  The following remains to be
done:
> 1. Add apache license headers.
> 2. New unit tests that aren't dependent on details specific to the ERNE project.
> 3. Testing.
> I think I can finish it by the end of next week.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message