[
https://issues.apache.org/jira/browse/OFBIZ-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13599603#comment-13599603
]
Paul Foxworthy commented on OFBIZ-5146:
---------------------------------------
Hi all,
Yes, I was just looking to try and determine how widely these functions are
supported. For SQL 03 compliance, I think we should look at EXTRACT() not
YEAR() or MONTH(). See
http://users.atw.hu/sqlnut/sqlnut2-chp-4-sect-4.html#sqlnut2-CHP-4-SECT-4.3 for
one discussion of this.
What's our general policy?
https://fisheye6.atlassian.com/browse/ofbiz/trunk/framework/entity/config/entityengine.xml?hb=true
lists HSQL, Derby, Daffodil, Axion, MySQL, Postgres, Oracle, SAPDb, Sybase,
Firebird, MSSQL and Advantage.
https://cwiki.apache.org/OFBADMIN/demo-and-test-setup-guide.html says OFBiz has
been tested with DB2.
Can we only expose functions that will work on every database we imply is
supported? That might mean adding function translation to the entity engine,
for example to send the database either YEAR() or EXTRACT() as appropriate.
Cheers
Paul Foxworthy
> in ModelViewEntity.java, a Map is built with only a few of the SQL functions,
> extend the map to include the MONTH and Year functions.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-5146
> URL: https://issues.apache.org/jira/browse/OFBIZ-5146
> Project: OFBiz
> Issue Type: Improvement
> Components: framework
> Affects Versions: SVN trunk
> Reporter: Jaideep Singh
> Fix For: SVN trunk
>
> Attachments: ModelViewEntity.patch, ModelViewEntity.patch
>
>
> in ModelViewEntity.java, a Map is built with only a few of the SQL functions,
> extend the map to include the MONTH and Year functions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
