View source | Discuss this page | Page history | Printable version   

ERP 2.50:Developers Guide/Examples/Data Access Layer and REST

ERP 2.50:Developers Guide




This page contains links to code and to other resources showing examples of usage of the Data Access Layer and REST Webservices.

Using OBDal and OBCriteria

The OBDalTest class contains examples of using the OBDal and OBCriteria services. Test cases cover simple querying, retrieval of single records and paging.

Using OBQuery

The DAL test cases contain several examples on how to use the OBQuery class. Specifically check out the DalQueryTest test class. It contains examples of querying with multiple joins and paging.

Using the DatasetService class

The DataSetService class offers an api to work with Datasets programmatically.

There are two test classes which test this service, they contain code which can be useful when working with data sets programmatically:

Calling REST Webservices through Java

Openbravo has a number of test cases which are used to test REST webservices on a running Openbravo instance. They are located in the org.openbravo.test.webservice package.

There is a read and a write/update testclass. They both inherit from the BaseWSTest class. This class has good examples of code on how-to build http connections with authentication through Java.

The WSReadTest class inherits from BaseWSTest. It contains examples of doing simple REST requests as well as using a where-clause and paging.

The WSUpdateTest class inherits from BaseWSTest. The tests which are a good basis for your own code:

There is a blog on working with Openbravo REST webservices directly from Firefox, this can be useful for test purposes.

Using the runtime model

The Openbravo Data Access Layer implements and makes use of a runtime in-memory representation of the model. This model is also available to application developers and can be used for generic functionality.

The Data Access Layer concepts guide contains an explanation of the runtime model and a code example to convert a business object to xml: see here.

This blog also discusses coding against the runtime model. It contains example code which exports all data in Openbravo with just a few lines of code.

ERP 2.50:Developers Guide/Examples/Window and Tab | ERP 2.50:Developers Guide/Examples/Reference 

Retrieved from ""

This page has been accessed 11,524 times. This page was last modified on 14 June 2011, at 11:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.