[jira] Commented: (OFBIZ-1882) Fix Derby reserve words for 10.3.1.3

["BJ Freeman (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-1882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12614711#action_12614711 ] 

BJ Freeman commented on OFBIZ-1882:
-----------------------------------

also if your running postgresql  you will need to change the reserve word to ALTER column
http://www.postgresql.org/docs/7.3/static/sql-altertable.html
http://www.postgresql.org/docs/8.1/static/sql-altertable.html

> Fix Derby reserve words for  10.3.1.3
> -------------------------------------
>
>                 Key: OFBIZ-1882
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1882
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>
> our current version of derby is the last official release 10.3.1.3
> This supports the Alter column, instead of the RENAME COLUMN currently
> in DatabaseUtil
> this break the modifying of the DB.
> So I propose using the DAOHELPEr since it is assigned in the
> entityengine.xml
>             helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> Modify the interface Generic Helper to process Reserved words
> Add a String ProcessReservedWords(string word){return word;}
> to the Helper files that use the interface
> Copy and modify the GenericHelperDAO to GenericHelperDAODerby10_3_1_3
> fill out
> String ProcessReservedWords(string word){return word;}
> to return Alter for Rename otherwise return word.
> Then wrap all the reserved words in DatabaseUtil or any other java file
> that has reserved words, with ProcessReservedWords();
> then change the entityengine.xml for derby to
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAODerby10_3_1_3"
> Note David says wait till next release 
> this is more for documentation if someone wants to do it.

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