Hi Sudha,
I would suggest you to look around in the data model before attempting
to introduce new tables and new columns to existing table. OFBiz data
model is so vast that it will fit into most of the requirements. You can
look around in the "Webtools" application to learn about the data model.
However, if you really need add new tables, you can define your own
entities. Look around in the entitydef folders in various applications.
If you need to modify the existing one, search around how to extend the
entities. Sorry, I do not have the exact code, but I am sure you can
find many examples in the OFbiz.
OFBiz supports multiple databases out of the box. You can do that in
${ofbiz.home}/entity/config/entityengine.xml file. Also, dont forget to
copy your correct JDBC jar in ${ofbiz.home}/entity/lib/jdbc folder.
I would also suggest you to read Business Setup and Technical Setup
guides on Documentation section. These are great source of information.
Thanks,
Raj
On 04/08/10 17:21, OfBizSuds wrote:
Thank you so much Raj, that was really helpful. I followed your model& have
got quite a few things working as per our requirements.
It would be great if you could also provide some steps on how to go about
adding new entities (tables).
Also if we need to capture more fields for the customer table where should
we add these?? It's probably not recommended to change the existing Data
Model correct?
Suppose instead of Derby we want to use MySQL, is that easy to do??
Appreciate your help,
Sudha
