Re: Does ofbiz support regular query for mysql database?

Posted by Jacques Le Roux on
URL: http://ofbiz.116.s1.nabble.com/Does-ofbiz-support-regular-query-for-mysql-database-tp4375214p4378790.html

You might also use directly SQL queries, as it's done at https://demo-trunk.ofbiz.apache.org/webtools/control/EntitySQLProcessor
(see EntitySQLProcessor.groovy for code clues)
But as well explained Paul, it's not the recommend way of doing and should only be reserved to cases where the Entity Engine is not
capable of doing. I never crossed a case...

FYI, Atlassian Jira is using the OFBiz Entity Engine underneath (for almost a decade now)
http://www.atlassian.com/software/jira/overview

Jacques

From: "Paul Foxworthy" <[hidden email]>

> Hello zhiyongcui,
>
> OFBiz has an entity engine, so that you can define the data model you need,
> and the database to persist your data is automatically created. OFBiz can
> use several databases including MySQL, Derby, Postgres, Oracle and Microsoft
> SQL Server.
>
> You use the entity engine rather than directly create a MySQL query. There
> are several benefits: your application will continue to work even if you
> change your mind about which database you want to use, and you can
> reconfigure your data model and the entity engine will automatically adjust
> the structure of the database.
>
> More on the entity engine at http://ofbiz.apache.org/docs/entity.html
>
> Cheers
>
> Paul Foxworthy
>
>
> zhiyongcui wrote
>>
>> Does ofbiz support regular query for mysql database?
>>
>
> -----
> --
> Coherent Software Australia Pty Ltd
> http://www.cohsoft.com.au/
>
> Bonsai ERP, the all-inclusive ERP system
> http://www.bonsaierp.com.au/
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Does-ofbiz-support-regular-query-for-mysql-database-tp4375214p4378313.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.