Does ofbiz support regular query for mysql database?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Does ofbiz support regular query for mysql database?

zhiyongcui
Does ofbiz support regular query for mysql database?
Reply | Threaded
Open this post in threaded view
|

Re: Does ofbiz support regular query for mysql database?

Paul Foxworthy
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.coherentsoftware.com.au/

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/
Reply | Threaded
Open this post in threaded view
|

Re: Does ofbiz support regular query for mysql database?

Jacques Le Roux
Administrator
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.