This project adds the ability to work with databases in your stagediver.fx projects. It is based on the stagediver.fx project.

This project introduces additional features to the stagediver.fx platform:

• Connection service to manage connections to different database systems
• Build in HyperSQL for rapid development
• Connection pooling with c3p0
• Experimental Hibernate support

The project can be deployed as a bundle into your stagediver.fx application.

Please note this is a very simple project. It's initial intention is to learn OSGi, learn how to deploy additional bundles into a stagediver.fx project and to sum up my knowledge about non Spring projects :-)

The following assumes you have used the stagediver.fx archetype to create your application.

• Github checkout

• mvn clean install

• Add the following to the top level pom.xml of your stagediver.fx application. Please change the version to the one you want to use.

        <dependency>
            <groupId>de.iew.stagediver.fx</groupId>
            <artifactId>database-api</artifactId>
            <version>2.0.0-SNAPSHOT</version>
        </dependency>
        <dependency>
            <groupId>de.iew.stagediver.fx</groupId>
            <artifactId>database-core</artifactId>
            <version>2.0.0-SNAPSHOT</version>
        </dependency>
        <dependency>
            <groupId>de.iew.stagediver.fx</groupId>
            <artifactId>database-hibernate</artifactId>
            <version>2.0.0-SNAPSHOT</version>
        </dependency>
  

• Add the following to the dependencies section of the modules which want to use the database module. It adds the database-api module as a compile time dependency for development. The dependency is not shipped with your module.

        <dependency>
            <groupId>de.iew.stagediver.fx</groupId>
            <artifactId>database-api</artifactId>
        </dependency>
  

• In your maven-bundle-plugin configuration of the modules add the import de.iew.stagediver.fx.database.* to the Import-Package configuration. It should look similar to:

        <Import-Package>
            ... Many other includes and excludes of the module,
            de.iew.stagediver.fx.database.*
        </Import-Package>
  

• Add the following to your stagediver.fx main application module. Normally this module should have the -application suffix.

        <dependency>
            <groupId>de.iew.stagediver.fx</groupId>
            <artifactId>database-full</artifactId>
            <version>2.0.0-SNAPSHOT</version>
            <type>pom</type>
            <scope>provided</scope>
        </dependency>
  

Please note: the hibernate support is very experimental. I have only tested the basic features of hibernate. Extended second level cache (such as Ehcache) is currently not supported.

To use hibernate in your application you must add the following dependency to your module.

        <dependency>
            <groupId>de.iew.stagediver.fx</groupId>
            <artifactId>database-hibernate</artifactId>
        </dependency>

It's important you also add the following two imports to your module. Otherwise the hibernate packages are not found in an OSGi application.

        org.hibernate.proxy;resolution:=optional,
        javassist.util.proxy;resolution:=optional,

Your module must provide a hibernate.cfg.xml file in the root package or in a maven project just put it into the resources folder of your application.

This project is licensed under the terms of the Apache 2.0 license.