# Interface Spanner (6.118.0)

6.118.0 (latest) 6.116.0 6.111.1 6.108.0 6.107.0 6.103.0 6.102.1 6.101.1 6.100.0 6.99.0 6.98.1 6.97.1 6.96.1 6.95.1 6.94.0 6.93.0 6.89.0 6.88.0 6.87.0 6.86.0 6.85.0 6.83.0 6.82.0 6.80.1 6.79.0 6.77.0 6.74.1 6.72.0 6.71.0 6.69.0 6.68.0 6.66.0 6.65.1 6.62.0 6.60.0 6.58.0 6.57.0 6.56.0 6.55.0 6.54.0 6.53.0 6.52.1 6.51.0 6.50.1 6.49.0 6.25.1 6.24.0 6.23.4 6.22.0 6.21.2 6.20.0 6.19.1 6.18.0 6.17.4 6.14.1

    public interface Spanner extends Service<SpannerOptions>, AutoCloseable

An interface for Cloud Spanner. Typically, there would only be one instance of this for the
lifetime of the application which must be closed by invoking [#close()](https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.Spanner#com_google_cloud_spanner_Spanner_close__) when it is no
longer needed. Failure to do so may result in leaking session resources and exhausting session
quota.

## Implements

com.google.cloud.Service\<com.google.cloud.spanner.SpannerOptions\>, [AutoCloseable](https://docs.oracle.com/javase/8/docs/api/java/lang/AutoCloseable.html)

## Methods

### close()

    public abstract void close()

Closes all the clients associated with this instance and frees up all the resources. This
method will block until it can clean up all the resources. Specifically, it deletes all the
underlying sessions (which involves rpcs) and closes all the gRPC channels. Once this method
called, this object is no longer usable. It is strongly advised to call this method when you
are done with the `Spanner` object, typically when your application shuts down. There is
a hard limit on number of sessions in Cloud Spanner and not calling this method can lead to
unused sessions piling up on the backend.

### createDatabaseAdminClient()

    public default DatabaseAdminClient createDatabaseAdminClient()

Returns a [com.google.cloud.spanner.admin.database.v1.DatabaseAdminClient](https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.admin.database.v1.DatabaseAdminClient) to execute
admin operations on Cloud Spanner databases. This method always creates a new instance of
[com.google.cloud.spanner.admin.database.v1.DatabaseAdminClient](https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.admin.database.v1.DatabaseAdminClient) which is an [AutoCloseable](https://docs.oracle.com/javase/8/docs/api/java/lang/AutoCloseable.html) resource. For optimising the number of clients, caller may choose to cache the
clients instead of repeatedly invoking this method and creating new instances.

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.admin.database.v1.DatabaseAdminClient` | [com.google.cloud.spanner.admin.database.v1.DatabaseAdminClient](https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.admin.database.v1.DatabaseAdminClient) |

### createInstanceAdminClient()

    public default InstanceAdminClient createInstanceAdminClient()

Returns a [com.google.cloud.spanner.admin.instance.v1.InstanceAdminClient](https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.admin.instance.v1.InstanceAdminClient) to execute
admin operations on Cloud Spanner databases. This method always creates a new instance of
[com.google.cloud.spanner.admin.instance.v1.InstanceAdminClient](https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.admin.instance.v1.InstanceAdminClient) which is an [AutoCloseable](https://docs.oracle.com/javase/8/docs/api/java/lang/AutoCloseable.html) resource. For optimising the number of clients, caller may choose to cache the
clients instead of repeatedly invoking this method and creating new instances.

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.admin.instance.v1.InstanceAdminClient` | [com.google.cloud.spanner.admin.instance.v1.InstanceAdminClient](https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.admin.instance.v1.InstanceAdminClient) |

### getAsyncExecutorProvider()

    public abstract ExecutorProvider getAsyncExecutorProvider()

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/gax/latest/com.google.api.gax.core.ExecutorProvider.html` | the [ExecutorProvider](https://docs.cloud.google.com/java/docs/reference/gax/latest/com.google.api.gax.core.ExecutorProvider.html) that is used for asynchronous queries and operations. |

### getBatchClient(DatabaseId db)

    public abstract BatchClient getBatchClient(DatabaseId db)

Returns a `BatchClient` to do batch operations on Cloud Spanner databases. Batch client
is useful when one wants to read/query a large amount of data from Cloud Spanner across
multiple processes, even across different machines. It allows to create partitions of Cloud
Spanner database and then read/query over each partition independently yet at the same
snapshot.

For all other use cases, `DatabaseClient` is more appropriate and performant.


     SpannerOptions options = SpannerOptions.newBuilder().build();
     Spanner spanner = options.getService();
     final String project = "test-project";
     final String instance = "test-instance";
     final String database = "example-db";
     DatabaseId db =
         DatabaseId.of(project, instance, database);
     BatchClient batchClient = spanner.getBatchClient(db);
     
| **Parameter** ||
|---|---|
| **Name** | **Description** |
| `db` | `https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.DatabaseId` |

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.BatchClient` |   |

### getDatabaseAdminClient()

    public abstract DatabaseAdminClient getDatabaseAdminClient()

Returns a `DatabaseAdminClient` to execute admin operations on Cloud Spanner databases.

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.DatabaseAdminClient` | `DatabaseAdminClient` |

### getDatabaseClient(DatabaseId db)

    public abstract DatabaseClient getDatabaseClient(DatabaseId db)

Returns a `DatabaseClient` for the given database. It uses a pool of sessions to talk to
the database.


     SpannerOptions options = SpannerOptions.newBuilder().build();
     Spanner spanner = options.getService();
     final String project = "test-project";
     final String instance = "test-instance";
     final String database = "example-db";
     DatabaseId db =
         DatabaseId.of(project, instance, database);
     DatabaseClient dbClient = spanner.getDatabaseClient(db);
     
| **Parameter** ||
|---|---|
| **Name** | **Description** |
| `db` | `https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.DatabaseId` |

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.DatabaseClient` |   |

### getInstanceAdminClient()

    public abstract InstanceAdminClient getInstanceAdminClient()

Returns an `InstanceAdminClient` to execute admin operations on Cloud Spanner instances.

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.InstanceAdminClient` | `InstanceAdminClient` |

### isClosed()

    public abstract boolean isClosed()

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `https://docs.oracle.com/javase/tutorial/java/nutsandbolts/datatypes.html` | `true` if this [Spanner](https://docs.cloud.google.com/java/docs/reference/google-cloud-spanner/latest/com.google.cloud.spanner.Spanner) object is closed. |