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 SpannerSQLExceptions.TransactionRetryListener Deprecated. -
Class Summary Class Description JdbcConstants Constants for special values used by the Cloud Spanner JDBC driver.JdbcDataSource DataSourceimplementation for Google Cloud Spanner.JdbcDriver JDBCDriverfor Google Cloud Spanner.JdbcSqlExceptionFactory Factory class for creatingSQLExceptions 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 SpecificSQLExceptionthat is thrown when a transaction was aborted and could not be retried due to a concurrent modification.JdbcSqlExceptionFactory.JdbcAbortedException SpecificSQLExceptionthat is thrown when a transaction was aborted and could not be successfully retried.JdbcSqlExceptionFactory.JdbcSqlBatchUpdateException SpecificSQLExceptionthat is thrown when aSpannerBatchUpdateExceptionoccurs.JdbcSqlExceptionFactory.JdbcSqlClientInfoException SpecificSQLExceptionthat is thrown when setting client info on a connectionJdbcSqlExceptionFactory.JdbcSqlExceptionImpl BaseSQLExceptionfor Cloud SpannerJdbcSqlExceptionFactory.JdbcSqlFeatureNotSupportedException SpecificSQLExceptionthat is thrown for unsupported methods and valuesJdbcSqlExceptionFactory.JdbcSqlTimeoutException SpecificSQLExceptionthat is thrown when a statement times out