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

    May 17, 2018 - While the Alkacon team is currently working hard on OpenCms version 11, another maintenance release 10.5.4 for OpenCms 10.5 is now ready for download, fixing some security issues. A new version of Alkacon OCEE for 10.5.4 is also available.

  • OpenCms 10.5.4 Release Notes

    May 17, 2018 - The OpenCms 10.5.4 release notes contain detailed information about the new features and fixes in this version.

  • OpenCms 10.5.3 available

    Oct 18, 2017 - OpenCms 10.5.3 is a maintenance release for OpenCms 10.5. This version fixes an issue introduced with the Chrome 61 update that caused problems in the positioning of UI elements. A number of other issues have also been fixed. A new version of Alkacon OCEE is also available.

  • OpenCms 10.5.3 Release Notes

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

Try the OpenCms Live Demo