Google Cloud Spanner

Google Cloud Spanner Open-Source JDBC Driver

DataSource

Transaction Type DataSource Class
NO_TRANSACTION, LOCAL_TRANSACTION 
com.google.cloud.spanner.jdbc.JdbcDataSource

Other Properties

Specify the server URL and the user credentials in the Other Properties field:

Parameter Description
url URL for Google Cloud Spanner database. Format for user credentials: 
Relative path to the credentials=<path 
to service account credential json file>
For example: 
url=jdbc:cloudspanner:/projects/<project id>/
instances/<instance id>/databases/<database name>;
For more information on Google Cloud Spanner connection properties, see Google Cloud Spanner open-source JDBC driver documentation.

Required Connection Property Fields

Driver Name Server Name User Password Database Name Port Number Network Protocol
Google Cloud Spanner Open-Source JDBC Driver No No No No No No

For more information about limitations, see Limitations.

Limitations

Driver Database/

Adapter IS Operating System/

Platform Affected

Limitation Description
Google Cloud Spanner Open-Source JDBC Driver Google Cloud Spanner This driver does not support:
  • Services: StoredProcedure, StoredProcedureWithSignature.
  • Notifications: InsertNotifications, UpdateNotifications, DeleteNotifications, StoredProcedureNotifications, StoredProcedureNotificationsWithSignature, OrderedNotifications.
  • XA_TRANSACTION connections.
  • DDL statements in LOCAL_TRANSACTION