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

    Oct 2, 2023 - OpenCms 16 brings the new app "Unused contents" that allows to find and delete content that is not actively used on any container page. It is now possible to select between several individual detail pages in the same website based on categories of the detail content. It can now be enforced that all content managers must set a new password after the next login. The default Mercury template brings several new features, e.g. the "Image tile display" formatter for the "Tabs / accordion" element.

  • OpenCms 16 Release Notes

    Oct 2, 2023 - The OpenCms 16 release notes contain detailed information about the new features and fixes in this version.

  • Alkacon OCEE 16

    Oct 2, 2023 - Alkacon OCEE 16 is the latest OCEE release for OpenCms 16. This version fixes an issue where deleting a user/group didn't flush the ACL cache.

  • 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.

Try the OpenCms Live Demo