DOAG Deutsche ORACLE-Anwendergruppe e.V.

Open Source: Development with Oracle JET

What do you do when your development budget is too tight? Luc Bors, Oracle ACE Director and Technical Director at eProseed decided to switch to Oracle’s open source products. At the DOAG 2016 Conference + Exhibition in November, he presents the successfully completed project with all its challenges.

After the team around Luc Bors had initially started the project with cloud-based products such as "Oracle Database Cloud Service" and "Oracle Java Cloud Service", there were some issues with the sponsoring of the project at the customer. That is why the team started looking for a cost-effective alternative and found it in a combination of "Oracle JavaScript Extension Toolkit" (JET), GlassFish, MySQL and eclipseLink – all are free Oracle open source products, which the team then used to develop the required multitenant solution.

At the very beginning, there were many pitfalls and challenges, says the Technical Director: "First of all we had to learn Oracle JET. We never used this toolkit before and it took some time to make things work. The next pitfall was when we decided to switch from Oracle Weblogic and Oracle XE database to Glassfish and MySQL. One would expect that this is an easy switch, but it proofed to be challenging. What runs on Weblogic does not necessarily run on Glassfish, and what works with Oracle Database is not always fit for MySQL."

Another point that should be considered is browser caching and cache busting: "The JET application is cached in the browser, as it is static content. There are ways to circumvent this, and especially when deploying new versions of the application, it is a must that the browser is forced to refresh the application."

The advantages of Oracle JET

Considering the overall application architecture, the team decided on a Web-based frontend that is built with Oracle JET. This frontend is linked to REST Services that are created on top of JPA Entities with TopLink. The Services are deployed on Glassfish and the data is stored in a MySQL Database.

The great advantage of Oracle JET is this: The toolkit supports the development of web applications using JavaScript and also includes a compilation of commonly used open source JavaScript Frameworks like Knockout, RequireJS and JQuery. Consequently, there is already a large collection of knowledge and documentation in the community. In addition, the built-in two way binding provides a powerful way for creating highly responsive User Experience. "All this has helped us to create the application user interface quickly," Bors concludes.

The half marathon runner is not only fascinated by open source development, but also by Mobile and Web: Over the years he has specialized in Oracle Forms, ADF and the Mobile Application Framework. He has also started his own Internet of Things project recently. For a year now, in his spare time, he is working on a robot, which he plans – once it is finished – to connect to Oracle’s IoT cloud.

14.09.2016 Development, DOAG Konferenz
By: Marina Fischer