Class ConnectionOptions

public class ConnectionOptions

Internal connection API for Google Cloud Spanner. This class may introduce breaking changes without prior notice.

Options for creating a Connection to a Google Cloud Spanner database.

Usage:

 
 
 ConnectionOptions options = ConnectionOptions.newBuilder()
       .setUri("cloudspanner:/projects/my_project_id/instances/my_instance_id/databases/my_database_name?autocommit=false")
       .setCredentialsUrl("/home/cloudspanner-keys/my-key.json")
       .build();
 try(Connection connection = options.getConnection()) {
   try(ResultSet rs = connection.executeQuery(Statement.of("SELECT SingerId, AlbumId, MarketingBudget FROM Albums"))) {
     while(rs.next()) {
       // do something
     }
   }
 }

Inheritance

java.lang.Object > ConnectionOptions

Inherited Members

Object.clone()

Object.equals(Object)

Object.finalize()

Object.getClass()

Object.hashCode()

Object.notify()

Object.notifyAll()

Object.toString()

Object.wait()

Object.wait(long)

Object.wait(long,int)

Fields

AUTOCOMMIT_PROPERTY_NAME

public static final String AUTOCOMMIT_PROPERTY_NAME

Name of the 'autocommit' connection property.

Field Value

Type	Description
String

CREDENTIALS_PROPERTY_NAME

public static final String CREDENTIALS_PROPERTY_NAME

Name of the 'credentials' connection property.

Field Value

Type	Description
String

ENCODED_CREDENTIALS_PROPERTY_NAME

public static final String ENCODED_CREDENTIALS_PROPERTY_NAME

Name of the 'encodedCredentials' connection property.

Field Value

Type	Description
String

LENIENT_PROPERTY_NAME

public static final String LENIENT_PROPERTY_NAME

Name of the 'lenientMode' connection property.

Field Value

Type	Description
String

MAX_SESSIONS_PROPERTY_NAME

public static final String MAX_SESSIONS_PROPERTY_NAME

Name of the 'numChannels' connection property.

Field Value

Type	Description
String

MIN_SESSIONS_PROPERTY_NAME

public static final String MIN_SESSIONS_PROPERTY_NAME

Name of the 'minSessions' connection property.

Field Value

Type	Description
String

NUM_CHANNELS_PROPERTY_NAME

public static final String NUM_CHANNELS_PROPERTY_NAME

Name of the 'numChannels' connection property.

Field Value

Type	Description
String

OAUTH_TOKEN_PROPERTY_NAME

public static final String OAUTH_TOKEN_PROPERTY_NAME

OAuth token to use for authentication. Cannot be used in combination with a credentials file.

Field Value

Type	Description
String

READONLY_PROPERTY_NAME

public static final String READONLY_PROPERTY_NAME

Name of the 'readonly' connection property.

Field Value

Type	Description
String

RETRY_ABORTS_INTERNALLY_PROPERTY_NAME

public static final String RETRY_ABORTS_INTERNALLY_PROPERTY_NAME

Name of the 'retry aborts internally' connection property.

Field Value

Type	Description
String

RPC_PRIORITY_NAME

public static final String RPC_PRIORITY_NAME

Name of the 'rpcPriority' connection property.

Field Value

Type	Description
String

VALID_PROPERTIES

public static final Set<ConnectionOptions.ConnectionProperty> VALID_PROPERTIES

All valid connection properties.

Field Value

Type	Description
Set<ConnectionProperty>

Methods

closeSpanner()

public static void closeSpanner()

Closes all Spanner instances that have been opened by connections during the lifetime of this JVM. Call this method at the end of your application to free up resources. You must close all Connections that have been opened by your application before calling this method. Failing to do so, will cause this method to throw a SpannerException.

This method is also automatically called by a shutdown hook (see Runtime#addShutdownHook(Thread)) when the JVM is shutdown gracefully.

getConnection()

public Connection getConnection()

Create a new Connection from this ConnectionOptions. Calling this method multiple times for the same ConnectionOptions will return multiple instances of Connections to the same database.

Returns

Type	Description
Connection	a new Connection to the database referenced by this ConnectionOptions

getCredentials()

public Credentials getCredentials()

The Credentials of this ConnectionOptions. This is either the credentials specified in the credentialsUrl or the default Google application credentials

Returns

Type	Description
com.google.auth.Credentials

getCredentialsUrl()

public String getCredentialsUrl()

The credentials URL of this ConnectionOptions

Returns

Type	Description
String

getDatabaseId()

public DatabaseId getDatabaseId()

The Spanner DatabaseId that this ConnectionOptions will connect to

Returns

Type	Description
DatabaseId

getDatabaseName()

public String getDatabaseName()

The Spanner database name that this ConnectionOptions will connect to

Returns

Type	Description
String

getDefaultProjectId(Credentials credentials)

public static String getDefaultProjectId(Credentials credentials)

Gets the default project-id for the current environment as defined by ServiceOptions#getDefaultProjectId(), and if none could be found, the project-id of the given credentials if it contains any.

Parameter

Name	Description
credentials	`com.google.auth.Credentials` The credentials to use to get the default project-id if none could be found in the environment.

Returns

Type	Description
String	the default project-id.

getHost()

public String getHost()

The host and port number that this ConnectionOptions will connect to

Returns

Type	Description
String

getInstanceId()

public String getInstanceId()

The Spanner Instance ID that this ConnectionOptions will connect to

Returns

Type	Description
String

getMaxSessions()

public Integer getMaxSessions()

The maximum number of sessions in the backing session pool of this connection. The session pool is shared between all connections in the same JVM that connect to the same Cloud Spanner database using the same connection settings.

Returns

Type	Description
Integer

getMinSessions()

public Integer getMinSessions()

The minimum number of sessions in the backing session pool of this connection. The session pool is shared between all connections in the same JVM that connect to the same Cloud Spanner database using the same connection settings.

Returns

Type	Description
Integer

getNumChannels()

public Integer getNumChannels()

The number of channels to use for the connection.

Returns

Type	Description
Integer

getProjectId()

public String getProjectId()

The Google Project ID that this ConnectionOptions will connect to

Returns

Type	Description
String

getSessionPoolOptions()

public SessionPoolOptions getSessionPoolOptions()

The SessionPoolOptions of this ConnectionOptions.

Returns

Type	Description
SessionPoolOptions

getUri()

public String getUri()

The URI of this ConnectionOptions

Returns

Type	Description
String

getWarnings()

public String getWarnings()

Any warnings that were generated while creating the ConnectionOptions instance.

Returns

Type	Description
String

isAutoConfigEmulator()

public boolean isAutoConfigEmulator()

Whether connections created by this ConnectionOptions will automatically try to connect to the emulator using the default host/port of the emulator, and automatically create the instance and database that is specified in the connection string if these do not exist on the emulator instance.

Returns

Type	Description
boolean

isAutocommit()

public boolean isAutocommit()

The initial autocommit value for connections created by this ConnectionOptions

Returns

Type	Description
boolean

isReadOnly()

public boolean isReadOnly()

The initial readonly value for connections created by this ConnectionOptions

Returns

Type	Description
boolean

isRetryAbortsInternally()

public boolean isRetryAbortsInternally()

The initial retryAbortsInternally value for connections created by this ConnectionOptions

Returns

Type	Description
boolean

isReturnCommitStats()

public boolean isReturnCommitStats()

Whether connections created by this ConnectionOptions return commit stats.

Returns

Type	Description
boolean

newBuilder()

public static ConnectionOptions.Builder newBuilder()

Create a Builder for ConnectionOptions. Use this method to create ConnectionOptions that can be used to obtain a Connection.

Returns

Type	Description
ConnectionOptions.Builder	a new Builder

toString()

public String toString()

Returns

Type	Description
String

Overrides

Object.toString()