jdbc-storage

A Spine Event Engine storage port for JDBC-compliant databases. It connects a Spine-based application to the RDBMS of choice.

At this point, this library is experimental, and its API is subject to change.

For production use, consider NoSQL storage implementations such as Google Cloud Datastore. See gcloud-java for Google Cloud support.

For the details on setting up the server environment, please refer to the Spine Bootstrap Gradle plugin and Spine core modules documentation.

Adding to your build

Stable version

The stable version requires Java 8+.

Use the following dependency in your Gradle build scripts:

dependencies {
    implementation("io.spine:spine-rdbms:1.9.0")
}

2.x

Version 2.x is still in development, but as of now, it fully supports all major features brought by the Spine 2.x family.

It requires Java 17+.

Use the following dependency in your Gradle build scripts:

dependencies {
    implementation("io.spine:spine-rdbms:$version")
}

⚠️ The exact snapshot version for version 2.x is listed in version.gradle.kts.

Documentation

The usage documentation lives in the docs directory:

• Configuration — building a JdbcStorageFactory and plugging it into the ServerEnvironment.
• SQL type mapping — how data types map to SQL types, and how to customize the mapping.
• RDBMS tables — table naming and structure, adding new columns, indexes, and customization.
• Queries — default queries, RDBMS engine detection, and customization.

License

This library is released under the Apache License, Version 2.0.