[jira] [Updated] (OPENJPA-1304) Refactor naming policy of database schema elements

["Albert Lee (Updated) (JIRA)" <ji...@apache.org>]

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

Albert Lee updated OPENJPA-1304:
--------------------------------

    Fix Version/s:     (was: 2.2.0)

Remove fix version in preparation for 2.2.0 release.
                
> Refactor naming policy of database schema elements
> --------------------------------------------------
>
>                 Key: OPENJPA-1304
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1304
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: jdbc, jpa, kernel, query, sql
>    Affects Versions: 2.0.0-M3
>            Reporter: Pinaki Poddar
>            Assignee: Pinaki Poddar
>
> The issue of naming database elements (Table/Column/Schema/Sequence/Constraints) is getting trickier with several aspects
>   a) The logic/protocol of naming of database elements is somewhat well-spread at different parts
>   b) few assumptions are implicit (like full name of a table is a concatenation of schema.table -- but MySQL, for example, will not like that)
>   c) other 'container' things often cache these elements by their names but these names may get shortened/modified because of database length restrictions/keyword clash
>   d) database variations impose few other twists (such as case-sensitivity)
> -- all these make naming a complex issue. One can see when methods like MappingDefaults.correctName() appear -- as if we know we have done mistakes elsewhere :)
>   e) the proverbial straw on the camel's back is the new JPA 2.0 requirement of these names be optionally quoted/delimited with default/platform specific quote characters.
>    
> The question is should we attempt refactoring name-related operations into a DatabaseElementNamingPolicy?
> Is it too risky?
>  If we do how the policy works with DBDictionary?
> How can we ensure backward compatibility? 
> How can we leverage it by adding new features that follow some rules to map name persistent Java element names to database element names saving the user to specify column names everywhere?
> Comments/Thoughts?

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