# 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

Related Packages
Package
Description
com.google.cloud.spanner
com.google.cloud.spanner.connection
Class
Description
CloudSpannerJdbcConnection
JDBC connection with a number of additional Cloud Spanner specific methods.
CloudSpannerJdbcPartitionedQueryResultSet
Result set that is returned for partitioned queries, e.g.
CloudSpannerJdbcPreparedStatement
This interface is implemented by `PreparedStatement`s that are created on Cloud Spanner JDBC connections.
CloudSpannerJdbcStatement
This interface is implemented by `Statement`s that are created on Cloud Spanner JDBC connections.
JdbcConstants
Constants for special values used by the Cloud Spanner JDBC driver.
JdbcDataSource
`DataSource` implementation for Google Cloud Spanner.
JdbcDriver
JDBC `Driver` for Google Cloud Spanner.
JdbcSqlException
Base interface for all Cloud Spanner `SQLException`s.
JdbcSqlExceptionFactory
Factory class for creating `SQLException`s for Cloud Spanner
JdbcSqlExceptionFactory.JdbcAbortedDueToConcurrentModificationException
Specific `SQLException` that is thrown when a transaction was aborted and could not be retried due to a concurrent modification.
JdbcSqlExceptionFactory.JdbcAbortedException
Specific `SQLException` that is thrown when a transaction was aborted and could not be successfully retried.
JdbcSqlExceptionFactory.JdbcSqlBatchUpdateException
Specific `SQLException` that is thrown when a `SpannerBatchUpdateException` occurs.
JdbcSqlExceptionFactory.JdbcSqlClientInfoException
Specific `SQLException` that is thrown when setting client info on a connection
JdbcSqlExceptionFactory.JdbcSqlExceptionImpl
Base `SQLException` for Cloud Spanner
JdbcSqlExceptionFactory.JdbcSqlFeatureNotSupportedException
Specific `SQLException` that is thrown for unsupported methods and values
JdbcSqlExceptionFactory.JdbcSqlTimeoutException
Specific `SQLException` that is thrown when a statement times out
JsonType
Custom SQL type for Spanner JSON data type.
PgJsonbType
SpannerPool
Deprecated.
TransactionRetryListener
Deprecated.
TransactionRetryListener.RetryResult
Deprecated.