[ 
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.

Reply via email to