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 15 available

    Apr 25, 2023 - OpenCms 15 provides role-based control to restrict who is allowed to update the sitemap configuration, including an editor for modifying selected sitemap attributes by any content manager. The new launchpad app "Person data search" reveals personal user data stored in the VFS. The Mercury template adds more than 1800 optional icons from the Bootstrap collection and numerous further enhancements.

  • OpenCms 15 Release Notes

    Apr 25, 2023 - The OpenCms 15 release notes contain detailed information about the new features and fixes in this version.

  • Alkacon OCEE 15

    Apr 25, 2023 - Alkacon OCEE 15 is the latest OCEE release for OpenCms 15. This version features a new scheduled job for LDAP synchronization and fixes a number of issues that have been detected in Alkacon OCEE 14.

  • OpenCms 14 available

    Oct 11, 2022 - This version features XML schema versioning with automatic content rewrite. Also new is support for two factor authentication (2FA) in the user login. A source code editor widget is available for multi-line text input fields. The Mercury template has been updated to use Bootstrap 5.2.

Try the OpenCms Live Demo