JPA driver – extended database support for OpenCms

Track: Technical
Speaker: Georgi Naplatanov (Oles Biz)


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

    Sep 26, 2016 - OpenCms 10.5 Beta provides a feature complete look at OpenCms 10.5. This will be the only pre-release version before OpenCms 10.5.0 is published, which is expected by the end of November. Only minor GUI updates, as well as improvements to the demo template, will be made for the final release.

  • OpenCms 10.5 Beta Release Notes

    Sep 26, 2016 - The OpenCms 10.5 Beta release notes contain detailed information about the new features and fixes in this beta version.

  • OpenCms 10.0.1 available

    Jun 14, 2016 - Being the greatest OpenCms update for years, version 10 brings a vastly improved user experience that combines the intuitive "Direct Edit" approach of OpenCms with a new, well integrated Lauchpad app center. OpenCms 10.0.1 is a maintenance update for 10.0.0 installations. It fixes several issues that persisted in previous releases. This version focuses on performance and stability.

  • OpenCms 10.0.1 Release Notes

    Jun 14, 2016 - The OpenCms 10.0.1 release notes contain detailed information about the updates and fixes in this version.

Try the OpenCms Live Demo