JDBC Drivers for Cloud Spanner

Google has partnered with Simba Technologies Inc, a Magnitude Software Company to provide JDBC drivers that leverage the power of Cloud Spanner's Query Syntax.

The intent of these drivers is to help users connect the power of Cloud Spanner with existing tooling and infrastructure that does not have native integration.

Current JDBC Driver Releases

Known Issues and FAQ

Can I use these drivers to issue Data Manipulation Language (DML) and Data Definition Language (DDL) statements?

At present, the drivers do not support DML or DDL statements.

How do the drivers deal with Cloud Spanner parent-child or interleaved table relationships?

Interleaved table relationships are mapped to foreign key relationships in JDBC. In Cloud Spanner, a record in the child table interleaved with a parent has its primary key dependent on the associated parent table record's primary key. Cloud Spanner defines the child table's parent primary key portion of its primary key as the foreign key, referencing the parent table's primary key. Thus the interleaved table relationships can be navigated using the foreign key metadata calls in DatabaseMetaData. For more information about Cloud Spanner's data model, see Schema and Data Model.

Are all Cloud Spanner data types supported by the driver?

The Cloud Spanner STRUCT data type is mapped to a SQL VARCHAR data type, accessible through the driver as String types. All other types have appropriate mappings.

Are indexes supported by the driver?

Indexes are supported in SELECT queries. The SQL syntax is described in Query Syntax. At present, there is no way to create or modify indexes with the driver. Information about particular indexes can be accessed through DatabaseMetaData.getIndexInfo().

Do the drivers support parameterized queries?

Yes, the drivers support positional parameterization.

Are there other limitations to consider when using the driver?

The driver's capabilities have limits defined by the underlying system. For information about Cloud Spanner limits, see Limits.

How do I get support for these drivers?

Consult our support page for support options.

Monitor your resources on the go

Get the Google Cloud Console app to help you manage your projects.

Send feedback about...

Cloud Spanner Documentation