OpenCms database layer with JPA

Initial Development of JPA driver done by Georgi Naplatanov. All test cases should be passed with this driver.

 Available files:

• JPA Driver patch (use 'save as...' functions to download)
• JPA Driver test case results

Sprint Work:

• Install patch
• Test JPA functionality by running tests
• Review JPA patch
• Required jar files:
  • http://apache.mirroring.de/commons/lang/binaries/ commons-lang-2.4-bin.zip
    • Copy the jar file to the OpenCms project /lib/runttime/.
  • http://downloads.sourceforge.net/hibernate/hibernate- distribution-3.3.0.SP1-dist.zip?modtime=1219174170&big_mirror=1
    • Copy the jar files from subfolder /lib/required/ to a new folder within the OpenCms project folder /lib/runtime/.
  • http://sourceforge.net/project/downloading.php?group_id=40712 &use_mirror=heanet&filename=hibernate-entitymanager-3.4.0.GA.zip &25150087
    •  Copy the jar files from subfolder /lib/  to a new folder within the OpenCms project folder /lib/runtime/. Delete the jar files (without version number) from this copy operations for all jar files from the 1st copy operation.
  • http://apache.mirror.iphh.net/openjpa/1.2.0/ apache-openjpa-1.2.0-binary.zip (ant task needed).
    • Copy the files
      
      • serp-1.13.1.jar
      • openjpa-1.2.0.jar
        
        to the OpenCms project folder /lib/runtime/. Under eclipse preferences set a global entry for the ant runtime classpath for this file to have the required openjpac task known by ant. Also commons-collections.jar from the /lib/runtime/ folder of the OpenCms project is now needed.
    • Copy the files
      • geronimo-jpa_3.0_spec-1.0.jar
      • geronimo-jta_1.1_spec-1.1.jar
        
        to the OpenCms project folder /lib/compile/. Under eclipse preferences set a global entry for the ant runtime classpath for this file to have the required openjpac task known by ant. Also commons-collections.jar from the /lib/runtime/ folder of the OpenCms project is now needed.
• Java 1.5 is required for the build due to the use of annotations for persistance mapping configuration. Some build files (*.xml) have to be modified: search for hardcoded 1.4 and change to 1.5 in javac tasks. For this task also the commons-lang-2.4.jar is needed and has to be set in the ant classpath.

 

Refactored Patch

The initial patch was eclipse workpspace specific and required to have a certain project name. It was created with svn, so files had to be moved. Finally some compile errors had to be removed. OpenCms 7.0.5 was checked out from cvs. The following patch is the result of the integration of the first patch. Please start with this one. 

JPA Driver Patch Refactored.

The required libraries are not in the patch. Use the following zip file. Deflate it and copy it over <eclipse-project>/lib/: jar libraries.

Results 

• Some work had to be done before the patch could be applied, compiled and installed.
• Installation was successful. The installations wizard showed changes in the UI which are subject to discussion (e.g. all JPA - supported DMBS are listed next to a checkbox for choice of JPA).
• After the installation the proper drivers are not contained in the OpenCms configuration (opencms.properties): OpenCms will start with a standard driver set instead of using JPA.
• The database structure created during setup does not require scripts. At a first glance it looks so as if there is no difference to the previous non-JPA database structure.
• The Junit test cases would not run due to missing folders and the fact that the current test architecture requires to run scripts for creating and dropping the database. Further work on the tests has to be done.