You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "BJ Freeman (JIRA)" <ji...@apache.org> on 2008/07/18 14:00:32 UTC
[jira] Created: (OFBIZ-1882) Fix Derby reserve words for 10.3.1.3
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.
[jira] Commented: (OFBIZ-1882) Fix Derby reserve words for
10.3.1.3
Posted by "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.
[jira] Closed: (OFBIZ-1882) Fix Derby reserve words for 10.3.1.3
Posted by "BJ Freeman (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
BJ Freeman closed OFBIZ-1882.
-----------------------------
Resolution: Won't Fix
David Suggests waiting for release of 10.3.1.4, which fixes this
> 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.