google-cloud-spanner-jdbc overview (2.11.4)

com.google.cloud.spanner.jdbc

A JDBC driver for Cloud Spanner - A no-compromise relational database service.

Example for creating a JDBC connection to Cloud Spanner.

   
 String 
  
 projectId 
  
 = 
  
 "my-project" 
 ; 
  
 String 
  
 instanceId 
  
 = 
  
 "my-instance" 
 ; 
  
 String 
  
 databaseId 
  
 = 
  
 "my-database" 
 ; 
  
 try 
  
 ( 
 Connection 
  
 connection 
  
 = 
  
 DriverManager 
 . 
 getConnection 
 ( 
  
 String 
 . 
 format 
 ( 
  
 "jdbc:cloudspanner:/projects/%s/instances/%s/databases/%s" 
 , 
  
 projectId 
 , 
  
 instanceId 
 , 
  
 databaseId 
 ))) 
  
 { 
  
 try 
  
 ( 
 Statement 
  
 statement 
  
 = 
  
 connection 
 . 
 createStatement 
 ()) 
  
 { 
  
 try 
  
 ( 
 ResultSet 
  
 rs 
  
 = 
  
 statement 
 . 
 executeQuery 
 ( 
 "SELECT CURRENT_TIMESTAMP()" 
 )) 
  
 { 
  
 while 
  
 ( 
 rs 
 . 
 next 
 ()) 
  
 { 
  
 System 
 . 
 out 
 . 
 printf 
 ( 
  
 "Connected to Cloud Spanner at [%s]%n" 
 , 
  
 rs 
 . 
 getTimestamp 
 ( 
 1 
 ). 
 toString 
 ()); 
  
 } 
  
 } 
  
 } 
  
 } 
  
 

See Also: Cloud Spanner JDBC Driver , JdbcDriver java doc for all supported connection URL properties.

Design a Mobile Site
View Site in Mobile | Classic
Share by: