This project contains the H2 implementation of the R2DBC SPI. This implementation is not intended to be used directly, but rather to be used as the backing implementation for a humane client library.
This driver provides the following features:
-
Filesystem or in-memory instances
-
Explict transactions
-
Execution of prepared statements with bindings
-
Execution of batch statements without bindings
-
Read and write support for all data types except LOB types (e.g.
BLOB,CLOB)
|
Warning
|
Since this driver runs on top of the internals of H2, there is risk of change.
r2dbc-h2 does not guarantee compatibility except against the version of H2 found in the build file.
Because various parts of H2 are blocking, like file and network access, the only non-blocking assurances are in the layers above H2.
Nevertheless, r2dbc-h2 is a great way to warm up to the usage of R2DBC with a small footprint.
|
This project is governed by the R2DBC Code of Conduct. By participating, you are expected to uphold this code of conduct. Please report unacceptable behavior to info@r2dbc.io.
Here is a quick teaser of how to use R2DBC H2 in Java:
URL Connection Factory Discovery for In-Memory Databases
ConnectionFactory connectionFactory = ConnectionFactories.get("r2dbc:h2:mem:///testdb");
Publisher<? extends Connection> connectionPublisher = connectionFactory.create();URL Connection Factory Discovery for File Databases
ConnectionFactory connectionFactory = ConnectionFactories.get("r2dbc:h2:file///my/relative/path");
Publisher<? extends Connection> connectionPublisher = connectionFactory.create();Programmatic Connection Factory Discovery
ConnectionFactoryOptions options = builder()
.option(DRIVER, "h2")
.option(PROTOCOL, "...") // file, mem
.option(HOST, "…")
.option(USER, "…")
.option(PASSWORD, "…")
.option(DATABASE, "…")
.build();
ConnectionFactory connectionFactory = ConnectionFactories.get(options);
Publisher<? extends Connection> connectionPublisher = connectionFactory.create();
// Alternative: Creating a Mono using Project Reactor
Mono<Connection> connectionMono = Mono.from(connectionFactory.create());Supported ConnectionFactory Discovery Options
| Option | Description |
|---|---|
|
Must be |
|
Must be |
|
Only for |
|
Only for |
|
Login username. |
|
Login password. |
|
Database to use. For |
|
Pass-thru of well-known H2 options such as |
|
A semicolon-delimited list of H2 configuration options( |
Programmatic Configuration
H2ConnectionFactory connectionFactory = new H2ConnectionFactory(H2ConnectionConfiguration.builder()
.inMemory("...")
.option(H2ConnectionOption.DB_CLOSE_DELAY, "-1")
.build());
Mono<Connection> connection = connectionFactory.create();Programmatic In-Memory Database Configuration
CloseableConnectionFactory connectionFactory = H2ConnectionFactory.inMemory("testdb");
Mono<Connection> connection = connectionFactory.create();Artifacts can be found on Maven Central.
<dependency>
<groupId>io.r2dbc</groupId>
<artifactId>r2dbc-h2</artifactId>
<version>${version}</version>
</dependency>If you’d rather like the latest snapshots of the upcoming major version, use our Maven snapshot repository and declare the appropriate dependency version.
<dependency>
<groupId>io.r2dbc</groupId>
<artifactId>r2dbc-h2</artifactId>
<version>${version}.BUILD-SNAPSHOT</version>
</dependency>
<repository>
<id>sonatype-nexus-snapshots</id>
<name>Sonatype OSS Snapshot Repository</name>
<url>https://oss.sonatype.org/content/repositories/snapshots</url>
</repository>H2 uses index parameters that are prefixed with $.
The following SQL statement makes use of parameters:
INSERT INTO person (id, first_name, last_name) VALUES ($1, $2, $3)Parameters are referenced using the same identifiers when binding these:
connection
.createStatement("INSERT INTO person (id, first_name, last_name) VALUES ($1, $2, $3)")
.bind("$1", 1)
.bind("$2", "Walter")
.bind("$3", "White")
.execute()r2dbc-h2 will automatically register support for JTS Toplogy Suite and handle it’s Geometry types if org.locationtech.jts:jts-core is on the classpath.
To enable, add this to your build:
<dependency>
<groupId>org.locationtech.jts</groupId>
<artifactId>jts-core</artifactId>
<version>${jts.version}</version>
</dependency>|
Important
|
Be sure to plug in your version of JTS! |
Also read H2’s reference documentation on GEOMETRY types.
-
index
bind(1, "Walter"). Notice that passing an integer means index (zero-based) references. -
$ symbol
bind("$2", "Walter"). H2 supports postgres params notation. -
Object (Integer)
bind(yourIntegerAsObject, "Walter"). If you index (int) was converted into object by a framework
Having trouble with R2DBC? We’d love to help!
-
Check the spec documentation, and Javadoc.
-
If you are upgrading, check out the changelog for "new and noteworthy" features.
-
Ask a question - we monitor stackoverflow.com for questions tagged with
r2dbc. You can also chat with the community on Gitter -
Report bugs with R2DBC H2 at github.com/r2dbc/r2dbc-h2/issues.
R2DBC uses GitHub as issue tracking system to record bugs and feature requests. If you want to raise an issue, please follow the recommendations below:
-
Before you log a bug, please search the issue tracker to see if someone has already reported the problem.
-
If the issue doesn’t already exist, create a new issue.
-
Please provide as much information as possible with the issue report, we like to know the version of R2DBC H2 that you are using and JVM version.
-
If you need to paste code, or include a stack trace use Markdown ``` escapes before and after your text.
-
If possible try to create a test-case or project that replicates the issue. Attach a link to your code or a compressed file containing your code.
You don’t need to build from source to use R2DBC H2 (binaries in Maven Central), but if you want to try out the latest and greatest, R2DBC H2 can be easily built with the maven wrapper. You also need JDK 1.8.
$ ./mvnw clean installIf you want to build with the regular mvn command, you will need Maven v3.5.0 or above.
Also see CONTRIBUTING.adoc if you wish to submit pull requests.
Commits require Signed-off-by (git commit -s) to ensure Developer Certificate of Origin.
To stage a release to Maven Central, you need to create a release tag (release version):
-
ci/create-release.sh <release-version> <next-snapshot-version>(e.g.ci/create-release.sh 0.8.5.RELEASE 0.8.6.BUILD-SNAPSHOT) -
git checkout release -
git reset --hard v<release-version>(e.g.git reset --hard v0.8.5.RELEASE, observe thevprefix) -
git push --force
This push will trigger a Maven staging build (see build-and-deploy-to-maven-central.sh).
This project is released under version 2.0 of the Apache License.