JPA driver – extended database support for OpenCms

Track: Technical
Speaker: Georgi Naplatanov (Oles Biz)

Abstract

This session presents the OpenCms JPA driver which uses the JAVA standard - Java Persistence API (JPA) and with OpenJPA as implementation. Utilizing the structure of the OpenCms internal SQL based drivers, this JPA driver enables the use of OpenCms for a large set of additional databases.

JPA is the target database structure for OpenCms 8, and this driver will probably be the base to be included in this upcoming version of the OpenCms core. For OpenCms 7.5, the driver will be made available as an additional module to be released before the conference.

Currently with the JPA driver the following additional databases are supported:

  • Apache Derby
  • Borland Interbase
  • Borland JDataStore
  • Empress
  • Firebird
  • H2 Database Engine
  • Informix Dynamic Server
  • InterSystems Cache
  • Microsoft Access
  • Microsoft Visual FoxPro
  • Pointbase
  • Sybase Adaptive Server Enterprise

In addition to the databases listed above, the standard OpenCms internal SQL drivers such as MySQL, Oracle, PostgreSQL, Microsoft SQL Server, HSQLDB and IBM DB2 are also available as JPA implementations.

Benefits, configuration and implementation of this JPA driver will be described in this session. Moreover, performance tests comparisons with the standard OpenCms internal SQL drivers are presented. Also included is a short description how to develop database independent modules with JPA.

Latest News

  • OpenCms 18 available

    Oct 8, 2024 - OpenCms 18 adds a new "Place element" mode in the page editor that allows precise element placement as an alternative to drag & drop. Reused content is now clearly marked. Automatic typographical correction of quotation marks has been added to all of the editors. “Dead links” in content that is entered in a WYSIWYG editor are now automatically disabled. Our Mercury template includes several new features, such as setting different image formats for mobile and desktop and many more.

  • OpenCms 18 Release Notes

    Oct 8, 2024 - The OpenCms 18 release notes contain detailed information about the new features and fixes in this version.

  • Alkacon OCEE 18

    Oct 8, 2024 - Alkacon OCEE 18 is the latest OCEE release for OpenCms 18. This version features a license key mechanism that allows to share the license key on several servers in a cloud installation.

  • Documentation website for the Mercury template

    Jul 8, 2024 - The Mercury template from Alkacon Software is a comprehensive, modular template based on Bootstrap 5 for OpenCms. This feature-rich template now has a complete and exhaustive documentation website.

Try the OpenCms Live Demo