[
https://issues.apache.org/jira/browse/OFBIZ-4346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13068828#comment-13068828
]
David E. Jones commented on OFBIZ-4346:
---------------------------------------
Adding a class per database is not the preferred way to handle SQL variations
(you'll notice that OOTB there are no such things for the entity engine).
The better approach is to change the existing code to support the different
syntax variations, and add an attribute to the datasource element in the
entityengine.xml file so that the proper variation can be chosen for each
database. That is how all current syntax variations are configured and coded.
> Support MySQL and Postgres's LIMIT and OFFSET options
> -----------------------------------------------------
>
> Key: OFBIZ-4346
> URL: https://issues.apache.org/jira/browse/OFBIZ-4346
> Project: OFBiz
> Issue Type: Improvement
> Components: framework
> Affects Versions: SVN trunk
> Reporter: Shi Jinghai
> Priority: Minor
> Attachments: mysql_postgres_limit_offset_trunk.patch
>
>
> Two helper classes are added for MySQL and Postgres to support LIMIT and
> OFFSET options.
> These classes can be configured in entityengine.xml:
> helper-class="org.ofbiz.entity.datasource.postgres.PostgresHelperDAO" for
> Postgres
> and
> helper-class="org.ofbiz.entity.datasource.mysql.MysqlHelperDAO" for MySQL.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
