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
-
Interface Summary Interface Description CloudSpannerJdbcConnection JDBC connection with a number of additional Cloud Spanner specific methods.JdbcSqlException Base interface for all Cloud SpannerSQLException
s.TransactionRetryListener Deprecated. -
Class Summary Class Description JdbcConstants Constants for special values used by the Cloud Spanner JDBC driver.JdbcDataSource DataSource
implementation for Google Cloud Spanner.JdbcDriver JDBCDriver
for Google Cloud Spanner.JdbcSqlExceptionFactory Factory class for creatingSQLException
s for Cloud SpannerJsonType Custom SQL type for Spanner JSON data type.PgJsonbType SpannerPool Deprecated. -
Enum Summary Enum Description TransactionRetryListener.RetryResult Deprecated. -
Exception Summary Exception Description JdbcSqlExceptionFactory.JdbcAbortedDueToConcurrentModificationException SpecificSQLException
that is thrown when a transaction was aborted and could not be retried due to a concurrent modification.JdbcSqlExceptionFactory.JdbcAbortedException SpecificSQLException
that is thrown when a transaction was aborted and could not be successfully retried.JdbcSqlExceptionFactory.JdbcSqlBatchUpdateException SpecificSQLException
that is thrown when aSpannerBatchUpdateException
occurs.JdbcSqlExceptionFactory.JdbcSqlClientInfoException SpecificSQLException
that is thrown when setting client info on a connectionJdbcSqlExceptionFactory.JdbcSqlExceptionImpl BaseSQLException
for Cloud SpannerJdbcSqlExceptionFactory.JdbcSqlFeatureNotSupportedException SpecificSQLException
that is thrown for unsupported methods and valuesJdbcSqlExceptionFactory.JdbcSqlTimeoutException SpecificSQLException
that is thrown when a statement times out