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.
