Hibernate and NuoDB

This is a fork of Hibernate ORM (http://github.com/hibernate/hibernate-orm) to allow testing of NuoDB's Hibernate dialect. The tests of interest are the matrix tests (which allow testing against multiple databases). Unfortunately the section on Matrix testing (in the original README below) is yet to be written.

Running Tests

To run the matrix tests for NuoDB:

1. You must have Java JDK 8 installed. Java 11 won't work.

2. Next, make sure you have our Hibernate 5 dialect jar available:

   • clone https://github.com/nuodb/HibernateDialect5
   • Run mvn install - see project README
   • Check the version in the POM - it will be of the form 20.x.x-hib5
     • You will need to set DIALECT_VERSION to `20.x.x``to match - see below

3. This project's gradle build file assumes you have your maven repository in the default location (.m2 in your home directory). If so, skip this step.

   Otherwise you must tell gradle where this dependency can be found. For example suppose you use m2 instead of .m2:

   export ADDITIONAL_REPO=~/m2/repository/com/nuodb/hibernate/nuodb-hibernate/20.x.x-hib5               (Linux/MacOS)
   
   set ADDITIONAL_REPO=c:\Users\yourname\m2\repository\com\nuodb\hibernate\nuodb-hibernate/20.x.x-hib5  (Windows)
   

4. Set the Hibernate dialect - this must match the Hibernate 5 dialect you installed earlier.

   • Note: the value you set does not have -hib5 in the end:

     export DIALECT_VERSION=20.x.x      (Linux/MacOS)
     set DIALECT_VERSION=20.x.x         (Windows)

   Alternatively, non-Windows user may prepend it to any command: DIALECT_VERSION=20.x.x ./gradlew ...

5. Compile the code: ./gradlew clean compile

6. Tell the tests about your NuoDB database:

   1. cp databases/nuodb/resources/hibernate.properties hibernate-core/target/resources/test.
   2. Edit hibernate-core/target/resources/test/hibernate.properties and set the database URL, username and password as required.

7. Run tests:

   • Execute ./gradlew clean hibernate-core:matrix_nuodb. On Windows run gradlew (which will invoke gradlew.bat). To setup gradle, see original readme content below. The expected output is:

     6935 tests completed, 114 failed, 822 skipped

   • Warnings:

     • If you run the tests without the clean option you may get a weird internal error in the compiler.

     • Not all tests clean up after themselves. You may need to drop the DBO schema used by the tests by running "DROP SCHEMA DBO CASCADE".

     • If you get this error, the easiest solution is to delete and reclone the entire repository.

       FAILURE: Build failed with an exception.
       
       * What went wrong:
       Execution failed for task ':hibernate-core:jar'.
       > Could not add MANIFEST.MF to ZIP '/.../hibernate-orm/hibernate-core/target/libs/hibernate-core-5.4.1-SNAPSHOT.jar'.

​ ```

1. Run individual tests

   Example commands:

   ./gradlew clean :hibernate-core:test --tests org.hibernate.jpa.test.packaging.PackagedEntityManagerTest
   ./gradlew clean :hibernate-core:test --tests *.PackagedEntityManagerTest
   ./gradlew clean :hibernate-core:test --tests org.hibernate.jpa.test.packaging.*
   

2. Pull Jar from Sonatype Once our jar is put up at Sonatype, its URL is something like https://oss.sonatype.org/content/repositories/comnuodb-NNNN/com/nuodb/hibernate/nuodb-hibernate/20.x.x-hib5/nuodb-hibernate-20.x.x-hib5.jar. Note the build number - NNNN (a 4 digit number such as 1050). To use this dependency run as follows:

   SONATYPE_VERSION=NNNN gradle clean ...   (Linux)
   
   set SONATYPE_VERSION=NNNN                (Windows)
   gradle clean ...
   

Please note that even if NuoDB is not available, 3603 tests complete, 1922 fail, and 801 are skipped. So 880 tests pass without using the database because the tests are intended for testing Hibernate not the underlying database. We are just piggybacking on them for convenience.

Upgrade Hibernate Dialect

If the Hibernate dialect has a new version number:

1. Update the environment variable: SET DIALECT_VERSION=20.x.x

This variable is used in three places and should get picked up by all of them:

• build.gradle
• databases/nuodb/matrix.gradle
• hibernate-core/hibernate-core.gradle

Upgrade NuoDB JDBC Driver

This must be changed manually in two places:

1. databases/nuodb/matrix.gradle: jdbcDependency "com.nuodb.jdbc:nuodb-jdbc:20.0.0"
2. hibernate-core/hibernate-core.gradle: testRuntime( "com.nuodb.jdbc:nuodb-jdbc:20.0.0" )

Changes Made to Project

To use NuoDB

1. Added databases/nuodb to define dependencies and configuration required to use NuoDB.

2. Added references to the NuoDB dialect and/or NuoDB JDBC jars to:

   • build.gradle
   • databases/nuodb/matrix.gradle
   • hibernate-core/hibernate-core.gradle

To configure NuoDB

1. Set the versions of NuoDB's JDBC and Dialect Jars in databases/nuodb/matrix.gradle
2. To configure the NuoDB data source modify databases/nuodb/resources/hibernate.properties
3. Make same modifications to hibernate-core/src/test/resources/hibernate.properties - this is the one that actually gets used.

To Run in IntelliJ

It is possible to run the tests in IntelliH (Eclipse's gradle support can't handle this project).

Open as a gradle project in IntelliJ in the usual way.

To force it to use NuoDB: cp databases/nuodb/resources/hibernate.properties hibernate-core/out/test/resources/hibernate.properties.

Original README

Hibernate ORM is a library providing Object/Relational Mapping (ORM) support to applications, libraries and frameworks.

It also provides an implementation of the JPA specification, which is the standard Java specification for ORM.

This is the repository of its source code: see Hibernate.org for additional information.

Building from sources

The build requires a Java 8 JDK as JAVA_HOME.

You will need Git to obtain the source.

Hibernate uses Gradle as its build tool. See the Gradle Primer section below if you are new to Gradle.

Contributors should read the Contributing Guide.

See the guides for setting up IntelliJ or Eclipse as your development environment.

Check out the Getting Started section in CONTRIBUTING.md for getting started working on Hibernate source.

Continuous Integration

Hibernate makes use of Jenkins for its CI needs. The project is built continuous on each push to the upstream repository. Overall there are a few different jobs, all of which can be seen at http://ci.hibernate.org/view/ORM/

Gradle primer

This section describes some of the basics developers and contributors new to Gradle might need to know to get productive quickly. The Gradle documentation is very well done; 2 in particular that are indispensable:

• Gradle User Guide is a typical user guide in that it follows a topical approach to describing all of the capabilities of Gradle.
• Gradle DSL Guide is quite unique and excellent in quickly getting up to speed on certain aspects of Gradle.

Using the Gradle Wrapper

For contributors who do not otherwise use Gradle and do not want to install it, Gradle offers a very cool features called the wrapper. It lets you run Gradle builds without a previously installed Gradle distro in a zero-conf manner. Hibernate configures the Gradle wrapper for you. If you would rather use the wrapper and not install Gradle (or to make sure you use the version of Gradle intended for older builds) you would just use the command gradlew (or gradlew.bat) rather than gradle (or gradle.bat) in the following discussions. Note that gradlew is only available in the project's root dir, so depending on your working directory you may need to adjust the path to gradlew as well.

Examples use the gradle syntax, but just swap gradlew (properly relative) for gradle if you wish to use the wrapper.

Another reason to use gradlew is that it uses the exact version of Gradle that the build is defined to work with.

Executing Tasks

Gradle uses the concept of build tasks (equivalent to Ant targets or Maven phases/goals). You can get a list of available tasks via

gradle tasks

To execute a task across all modules, simply perform that task from the root directory. Gradle will visit each sub-project and execute that task if the sub-project defines it. To execute a task in a specific module you can either:

1. cd into that module directory and execute the task
2. name the "task path". For example, in order to run the tests for the hibernate-core module from the root directory you could say gradle hibernate-core:test

Common Java related tasks

• build - Assembles (jars) and tests this project
• buildDependents - Assembles and tests this project and all projects that depend on it. So think of running this in hibernate-core, Gradle would assemble and test hibernate-core as well as hibernate-envers (because envers depends on core)
• classes - Compiles the main classes
• testClasses - Compiles the test classes
• compile (Hibernate addition) - Performs all compilation tasks including staging resources from both main and test
• jar - Generates a jar archive with all the compiled classes
• test - Runs the tests
• publish - Think Maven deploy
• publishToMavenLocal - Installs the project jar to your local maven cache (aka ~/.m2/repository). Note that Gradle never uses this, but it can be useful for testing your build with other local Maven-based builds.
• eclipse - Generates an Eclipse project
• idea - Generates an IntelliJ/IDEA project (although the preferred approach is to use IntelliJ's Gradle import).
• clean - Cleans the build directory

Testing and databases

Testing against a specific database can be achieved in 2 different ways:

Using the "Matrix Testing Plugin" for Gradle.

Coming soon...

Using "profiles"

The Hibernate build defines a number of database testing "profiles" in databases.gradle. These profiles can be activated by name using the db build property which can be passed either as a JVM system prop (-D) or as a Gradle project property (-P). Examples below use the Gradle project property approach.

gradle clean build -Pdb=pgsql

To run a test from your IDE, you need to ensure the property expansions happen. Use the following command:

gradle clean compile -Pdb=pgsql

NOTE : If you are running tests against a JDBC driver that is not available via Maven central (generally due to license nonsense - Oracle, DB2, etc) be sure to add these drivers to your local Maven repo cache (~/.m2/repository) or (better) add it to a personal Maven repo server

Running database-specific tests from the IDE using "profiles"

You can run any test on any particular database that is configured in a databases.gradle profile.

All you have to do is run the following command:

gradlew setDataBase -Pdb=pgsql

or you can use the shortcut version:

gradlew sDB -Pdb=pgsql

You can do this from the module which you are interested in testing or from the hibernate-orm root folder.

Afterward, just pick any test from the IDE and run it as usual. Hibernate will pick the database configuration from the hibernate.properties file that was set up by the setDataBase Gradle task.