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

Static Fields

AUTOCOMMIT_PROPERTY_NAME

public static final String AUTOCOMMIT_PROPERTY_NAME

Name of the 'autocommit' connection property.

Field Value
TypeDescription
String

CREDENTIALS_PROPERTY_NAME

public static final String CREDENTIALS_PROPERTY_NAME

Name of the 'credentials' connection property.

Field Value
TypeDescription
String

ENCODED_CREDENTIALS_PROPERTY_NAME

public static final String ENCODED_CREDENTIALS_PROPERTY_NAME

Name of the 'encodedCredentials' connection property.

Field Value
TypeDescription
String

LENIENT_PROPERTY_NAME

public static final String LENIENT_PROPERTY_NAME

Name of the 'lenientMode' connection property.

Field Value
TypeDescription
String

MAX_SESSIONS_PROPERTY_NAME

public static final String MAX_SESSIONS_PROPERTY_NAME

Name of the 'numChannels' connection property.

Field Value
TypeDescription
String

MIN_SESSIONS_PROPERTY_NAME

public static final String MIN_SESSIONS_PROPERTY_NAME

Name of the 'minSessions' connection property.

Field Value
TypeDescription
String

NUM_CHANNELS_PROPERTY_NAME

public static final String NUM_CHANNELS_PROPERTY_NAME

Name of the 'numChannels' connection property.

Field Value
TypeDescription
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
TypeDescription
String

READONLY_PROPERTY_NAME

public static final String READONLY_PROPERTY_NAME

Name of the 'readonly' connection property.

Field Value
TypeDescription
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
TypeDescription
String

RPC_PRIORITY_NAME

public static final String RPC_PRIORITY_NAME

Name of the 'rpcPriority' connection property.

Field Value
TypeDescription
String

VALID_PROPERTIES

public static final Set<ConnectionOptions.ConnectionProperty> VALID_PROPERTIES

All valid connection properties.

Field Value
TypeDescription
Set<ConnectionProperty>

Static 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.

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
NameDescription
credentialscom.google.auth.Credentials

The credentials to use to get the default project-id if none could be found in the environment.

Returns
TypeDescription
String

the default project-id.

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
TypeDescription
ConnectionOptions.Builder

a new Builder

Methods

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
TypeDescription
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
TypeDescription
com.google.auth.Credentials

getCredentialsUrl()

public String getCredentialsUrl()

The credentials URL of this ConnectionOptions

Returns
TypeDescription
String

getDatabaseId()

public DatabaseId getDatabaseId()

The Spanner DatabaseId that this ConnectionOptions will connect to

Returns
TypeDescription
DatabaseId

getDatabaseName()

public String getDatabaseName()

The Spanner database name that this ConnectionOptions will connect to

Returns
TypeDescription
String

getHost()

public String getHost()

The host and port number that this ConnectionOptions will connect to

Returns
TypeDescription
String

getInstanceId()

public String getInstanceId()

The Spanner Instance ID that this ConnectionOptions will connect to

Returns
TypeDescription
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
TypeDescription
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
TypeDescription
Integer

getNumChannels()

public Integer getNumChannels()

The number of channels to use for the connection.

Returns
TypeDescription
Integer

getProjectId()

public String getProjectId()

The Google Project ID that this ConnectionOptions will connect to

Returns
TypeDescription
String

getSessionPoolOptions()

public SessionPoolOptions getSessionPoolOptions()
Returns
TypeDescription
SessionPoolOptions

getUri()

public String getUri()

The URI of this ConnectionOptions

Returns
TypeDescription
String

getWarnings()

public String getWarnings()

Any warnings that were generated while creating the ConnectionOptions instance.

Returns
TypeDescription
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
TypeDescription
boolean

isAutocommit()

public boolean isAutocommit()

The initial autocommit value for connections created by this ConnectionOptions

Returns
TypeDescription
boolean

isReadOnly()

public boolean isReadOnly()

The initial readonly value for connections created by this ConnectionOptions

Returns
TypeDescription
boolean

isRetryAbortsInternally()

public boolean isRetryAbortsInternally()

The initial retryAbortsInternally value for connections created by this ConnectionOptions

Returns
TypeDescription
boolean

isReturnCommitStats()

public boolean isReturnCommitStats()

Whether connections created by this ConnectionOptions return commit stats.

Returns
TypeDescription
boolean

toString()

public String toString()
Returns
TypeDescription
String
Overrides