Home

Awesome

Google Google Cloud Spanner JDBC Client for Java

Java idiomatic client for Google Cloud Spanner JDBC.

Maven Stability

Quickstart

If you are using Maven, add this to your pom.xml file:

<!--- {x-version-update-start:google-cloud-spanner-jdbc:released} --> 
<dependency>
  <groupId>com.google.cloud</groupId>
  <artifactId>google-cloud-spanner-jdbc</artifactId>
  <version>2.24.2</version>
</dependency>
<!--- {x-version-update-end} -->

If you are using Gradle without BOM, add this to your dependencies

<!--- {x-version-update-start:google-cloud-spanner-jdbc:released} --> 
implementation 'com.google.cloud:google-cloud-spanner-jdbc:2.24.2'
<!--- {x-version-update-end} -->

If you are using SBT, add this to your dependencies

<!--- {x-version-update-start:google-cloud-spanner-jdbc:released} --> 
libraryDependencies += "com.google.cloud" % "google-cloud-spanner-jdbc" % "2.24.2"
<!--- {x-version-update-end} -->

Authentication

See the Authentication section in the base directory's README.

Authorization

The client application making API calls must be granted authorization scopes required for the desired Google Cloud Spanner JDBC APIs, and the authenticated principal must have the IAM role(s) required to access GCP resources using the Google Cloud Spanner JDBC API calls.

Getting Started

Prerequisites

You will need a Google Cloud Platform Console project with the Google Cloud Spanner JDBC [API enabled][enable-api].

Follow these instructions to get your project set up. You will also need to set up the local development environment by installing the Google Cloud SDK and running the following commands in command line: gcloud auth login and gcloud config set project [YOUR PROJECT ID].

Installation and setup

You'll need to obtain the google-cloud-spanner-jdbc library. See the Quickstart section to add google-cloud-spanner-jdbc as a dependency in your code.

About Google Cloud Spanner JDBC

Google Cloud Spanner JDBC

See the Google Cloud Spanner JDBC client library docs to learn how to use this Google Cloud Spanner JDBC Client Library.

Creating a JDBC Connection

The following example shows how to create a JDBC connection to Cloud Spanner and execute a simple query.

String projectId = "my-project";
String instanceId = "my-instance";
String databaseId = "my-database";

try (Connection connection =
    DriverManager.getConnection(
        String.format(
            "jdbc:cloudspanner:/projects/%s/instances/%s/databases/%s",
            projectId, instanceId, databaseId))) {
  try (Statement statement = connection.createStatement()) {
    try (ResultSet rs = statement.executeQuery("SELECT CURRENT_TIMESTAMP()")) {
      while (rs.next()) {
        System.out.printf(
            "Connected to Cloud Spanner at [%s]%n", rs.getTimestamp(1).toString());
      }
    }
  }
}

Connection URL Properties

The Cloud Spanner JDBC driver supports the following connection URL properties. Note that all of these can also be supplied in a Properties instance that is passed to the DriverManager#getConnection(String url, Properties properties) method.

Commonly Used Properties

Advanced Properties

Jar with Dependencies

A single jar with all dependencies can be downloaded from https://repo1.maven.org/maven2/com/google/cloud/google-cloud-spanner-jdbc/latest or be built with the command mvn package (select the jar that is named google-cloud-spanner-jdbc-<version>-single-jar-with-dependencies.jar).

Creating a Shaded Jar

A jar with all dependencies included is automatically generated when you execute mvn package. The dependencies in this jar are not shaded. To create a jar with shaded dependencies you must activate the shade profile like this:

mvn package -Pshade

Troubleshooting

To get help, follow the instructions in the shared Troubleshooting document.

Supported Java Versions

Java 8 or above is required for using this client.

Google's Java client libraries, Google Cloud Client Libraries and Google Cloud API Libraries, follow the Oracle Java SE support roadmap (see the Oracle Java SE Product Releases section).

For new development

In general, new feature development occurs with support for the lowest Java LTS version covered by Oracle's Premier Support (which typically lasts 5 years from initial General Availability). If the minimum required JVM for a given library is changed, it is accompanied by a semver major release.

Java 11 and (in September 2021) Java 17 are the best choices for new development.

Keeping production systems current

Google tests its client libraries with all current LTS versions covered by Oracle's Extended Support (which typically lasts 8 years from initial General Availability).

Legacy support

Google's client libraries support legacy versions of Java runtimes with long term stable libraries that don't receive feature updates on a best efforts basis as it may not be possible to backport all patches.

Google provides updates on a best efforts basis to apps that continue to use Java 7, though apps might need to upgrade to current versions of the library that supports their JVM.

Where to find specific information

The latest versions and the supported Java versions are identified on the individual GitHub repository github.com/GoogleAPIs/java-SERVICENAME and on google-cloud-java.

Versioning

This library follows Semantic Versioning.

Contributing

Contributions to this library are always welcome and highly encouraged.

See CONTRIBUTING for more information how to get started.

Please note that this project is released with a Contributor Code of Conduct. By participating in this project you agree to abide by its terms. See Code of Conduct for more information.

License

Apache 2.0 - See LICENSE for more information.

CI Status

Java VersionStatus
Java 8Kokoro CI
Java 8 OSXKokoro CI
Java 8 WindowsKokoro CI
Java 11Kokoro CI

Java is a registered trademark of Oracle and/or its affiliates.