I am experimenting with the JSON-API and experimenting an error I am using POSTMAN for testing and connecting to a local Postgress DB Post / localhost:7575/v1/query Body { “templateIds”: [“Main:CitizenInvitation”], “query” : {“citizen”: “Alice”} } Response: { “result”: , “errors”: [ “…

Createschema changes fixed it. Thanks for the help

Which parameters are you supplying to the JSON API? In particular what are you passing to --query-store-jdbc-config?

Found the resolution Switching from “POST” to “GET” resolves the issue Please update the documentation https://docs.daml.com/json-api/index.html#id14

POST is correct here please don’t just switch to GET. The GET request ignores the body and doesn’t perform any filtering which is probably why it doesn’t hit the postgres backend which is used for queries.

Yes. I noticed that just a minute ago Here is my JSON-API Command daml json-api --ledger-host localhost --ledger-port 6865 --http-port 7575 --max-inbound-message-size 4194304 --package-reload-interval 5s --application-id HTTP-JSON-API-Gateway --static-content “prefix=static,directory=./static-co…

Remove the ssl=true part (and the comma afterwards) if your postgres instance is not running with TLS.

[image] bartcant: –query-store-jdbc-config “driver=org.postgresql.Driver,url=jdbc:postgresql://localhost:5432/test?&ssl=true,user=Bart,password=password,createSchema=false” yes, this error is coming from the postgres JDBC driver. Just start json-api with --query-store-jdbc-config “driver=org…

removing it created errors on starting up the json-api so I changed it ssl=false new error { “result”: , “errors”: [ “Endpoints.ServerError: org.postgresql.util.PSQLException: ERROR: relation "template_id" does not exist\n Position: 18” ], “status”: 501 }

Looks like you didn’t create the schema so change it to createSchema=true run it once and then go back to createSchema=false

Here is the error when removing ssl=true it is complaining it requires a user field although it is present Error: Invalid JdbcConfig, must contain ‘user’ field Try --help for more information. daml-helper: Received ExitFailure 100 when running Raw command: java “-Dlogback.configurationFile=C:\…

createSchema -- boolean flag, if set to true, the process will re-create database schema and terminate immediately.

DAML JSON-API Query error " Endpoints.ServerError: org.postgresql.util.PSQLException: The server does not support SSL."

App Development

Topic		Replies	Views
Cannot connect to the ledger server, error: io.grpc.StatusRuntimeException: UNAVAILABLE: io exception App Development	6	743	December 9, 2020
Running JSON API in the container App Development daml , canton	5	312	June 6, 2023
Issue enabling TLS for DAML JSON Api App Development sandbox , json-api , ledger-api	8	1433	April 17, 2023
OpenSSL error when connecting json api jar to daml-on-sql jar with TLS App Development	2	967	April 27, 2021
API POST v1/query results in "Endpoints.ServerError: java.sql.BatchUpdateException: App Development daml-sdk , ledger-api , features and bugs	8	837	November 17, 2020

DAML JSON-API Query error " Endpoints.ServerError: org.postgresql.util.PSQLException: The server does not support SSL."

Related topics