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