Package com.google.cloud.spanner.jdbc
package com.google.cloud.spanner.jdbc
A JDBC driver for Cloud Spanner - A no-compromise relational database service.
Example for creating a JDBC connection to Cloud Spanner.
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());
}
}
}
}
- See Also:
-
- JdbcDriver java doc for all supported connection URL properties.
- Cloud Spanner JDBC Driver
-
ClassDescriptionJDBC connection with a number of additional Cloud Spanner specific methods.Result set that is returned for partitioned queries, e.g.This interface is implemented by
PreparedStatement
s that are created on Cloud Spanner JDBC connections.This interface is implemented byStatement
s that are created on Cloud Spanner JDBC connections.Constants for special values used by the Cloud Spanner JDBC driver.DataSource
implementation for Google Cloud Spanner.JDBCDriver
for Google Cloud Spanner.Base interface for all Cloud SpannerSQLException
s.Factory class for creatingSQLException
s for Cloud SpannerSpecificSQLException
that is thrown when a transaction was aborted and could not be retried due to a concurrent modification.SpecificSQLException
that is thrown when a transaction was aborted and could not be successfully retried.SpecificSQLException
that is thrown when aSpannerBatchUpdateException
occurs.SpecificSQLException
that is thrown when setting client info on a connectionBaseSQLException
for Cloud SpannerSpecificSQLException
that is thrown for unsupported methods and valuesSpecificSQLException
that is thrown when a statement times outCustom SQL type for Spanner JSON data type.Deprecated.Deprecated.Deprecated.