search

j143 / query-spanner-with-java

Querying cloud spanner with Java with testing CI on emulator
https://j143.github.io/query-spanner-with-java/
Apache License 2.0
1 stars 0 forks source link

Access emulator database from Java client library #6

Closed j143 closed 3 years ago

j143 commented 3 years ago

https://github.com/j143/query-spanner-with-java/blob/c85902d722188f83a3e2fc244c51e1b68f7356a7/.github/workflows/spanner-test.yml#L79-L86

The solution should look like,


- run: java -jar target/spanner-google-cloud-samples-jar-with-dependencies.jar  createdatabase test-instance example-db
  env:
      SPANNER_EMULATOR_HOST: localhost:9010
j143 commented 3 years ago

image

j143 commented 3 years ago

ERROR: (gcloud.spanner.databases.execute-sql) HTTPError 400: {"error":"Statement not supported: CreateTableStmt [at 1:1]\nCREATE TABLE Songs { SongId INT64 NOT NULL, Title STRING(1024), Year INT64, P...\n^","code":3,"message":"Statement not supported: CreateTableStmt [at 1:1]\nCREATE TABLE Songs { SongId INT64 NOT NULL, Title STRING(1024), Year INT64, P...\n^"} Error: Process completed with exit code 1.

j143 commented 3 years ago

Result:

7f4d2d2f-9b08-4d28-91e4-580bba2ca9f5 Gone 2021
84164d2b-0446-4be7-9d6c-c7389a684573 Fly to My Room 2020
926ff9c2-eede-44f6-8b9d-9dd545fa35ff Baby Shark 2020
9ebf3e68-03d7-4c06-b53f-fcf0513acb0d In the Morning 2021
ab506260-a9de-4ed1-b369-4ead2d92ca77 Celebrity 2021
ba7b69e5-0f19-4b58-a769-65179639d1a1 Lovesick Girls 2020
c7ed1b40-f632-4dec-b9a3-1e4aa3c85b43 Next Level 2021
ec2f9b2e-90f4-46d2-a273-26fd955d5701 Ice Cream 2020
ff4909d0-56a2-4f39-8875-07e76fc8327a On the Ground 2021
0941756d-213a-4bc5-8b06-c7e828cee0c2 Boy with Luv 2020
159b4571-25d0-499e-88d8-5ac219a8d456 Dynamite 2020
21fb6f31-ed83-4581-a289-b7b5c79005dd Ddu 2020
269aa8c7-e0c1-4d9c-bfb5-ac33870e0203 Black Mamba 2020
2c9feb5a-2007-4573-aa80-0018dc48ca41 Pretty Savage 2020
4c7cfeb9-1382-463b-84a6-ff548c4288ff Dis 2020
5e543a2d-bb12-4a58-ac32-1de873f9f13a Hot Sauce 2021
656912ea-a9f2-470b-ae21-c54f957db16c Not Shy 2020
7cbf43c4-2a0d-4c83-89a0-cce1ddf2fcbe Crazy Over You 2020
837f33dd-d09e-4ce8-bf3c-52639dba4d2f Stay 2020
84846c61-f2bd-46d9-be36-d91d11aa9d29 I Can 2020
94303d85-a50b-44ae-9a8b-c26019dae56a More 2020
9f67b1e4-4941-455f-bc80-e4d63b7ff1ee I Love You 2020
b2a715e3-1320-4c84-90df-5edc3d37c2ca How You Like That 2020
bc67a89c-f14d-44b7-949a-ebb3219aea0c Telepathy 2020
ce63185a-03ac-465d-8a64-c05681a46662 You Never Know 2020
f078c6d3-281a-4ab4-be9e-05602ce79de0 Love to Hate Me 2020