Information Technology

Menu

OpenUI5 and OData data bindings with MariaDB – CRUD Full Example- Part 1

OpenUI5 is the open source version of the powerful web MVC framework SAPUI5 created by SAP AG. OpenUI5 is based on web standards (HTML5, CSS, OData, XML, jQuery). The backend is linked using OData, JSON, XML and other data formats. Last but not least OpenUI5 have the same principles created for SAPUI5 (ROLE – BASED, ADAPTIVE, COHERENT, SIMPLE and DELIGHTFUL). For that reason OpenUI5 is a great option to build powerful solutions.

In this tutorial we will create a CRUD (Create, Read, Update and Delete) solution using MariaDB v10.1.21 as database, JPA v2.1, Apache Olingo v2.0.8 and Tomcat v7.0.56 to create an OData service, OpenUI5 v1.46.8 as Front End and Tomcat v7.0.56 as application server all included on XAMPP v5.6.30.

This first part include the installation and configuration of the environments, the data table creation in the database and expose the data table as OData service. The second part will include the OpenUI5 front end with the CRUD concepts implemented.

Copy and paste into People_OData/WebContent/WEBINF/lib folder all the jar files that were downloaded from JPA Libraries Dependencies. Right click on People_OData/WebContent/WEBINF/lib folder and click on Validate option.