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" <[email protected]>
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.
