Sandbox persistence

Questions
1

Hello daml community,

I am trying to set persistence to my ledger and, at the same time, run my json api.
Using DAML Driver for Postgres i can accomplish persistence:

java -jar daml-on-sql-1.17.1.jar --ledgerid=test --sql-backend-jdbcurl=“jdbc:postgresql://localhost/damltest?user=daml&password=daml”

Then i run json api:
daml json-api --ledger-host localhost --ledger-port 6865 --http-port 7575

I try to create my contracts with my Java aplication and i get this error:

HTTP 500 Internal Server Error

However, when i dont use persistence (following commands), i can create contracts, with my java aplication, and view them in navigator. RESPONSE: HTTP 200 OK

daml sandbox --wall-clock-time --ledgerid test_ledger ./.daml/dist/test-0.0.1.dar

daml json-api --ledger-host localhost --ledger-port 6865 --http-port 7575

2

Can you share the logs for both daml on SQL and for the JSON API?
Note also that 1.17.1 is fairly old at this point. I recommend switch to 2.1 although your setup should work on 1.17 as wlel.

3

java postgres
java postgres1456×571 58.6 KB

POSTGRES

4

json api error
json api error1903×672 77.5 KB

JSON API ERROR

5

Command: daml start

daml start1
daml start11900×958 77 KB

daml start2
daml start21905×676 87.7 KB

JSON API RESPONDING 200 OK

6

Ok i did it, i used this commands, now i can store my ledger in postgres while running json api:

daml deploy --host localhost --port 6865

daml json-api --ledger-host localhost --ledger-port 6865 --http-port 7575 --allow-insecure-tokens

java -jar daml-on-sql-1.17.1.jar --ledgerid=test_ledger --sql-backend-jdbcurl=“jdbc:postgresql://localhost/test2?user=test2&password=test2”

daml navigator server --port 7500

1 Like
7

Ah right that’s expected, you need to upload the package first. I believe if you look at the full error returned by the JSON API it should tell you that it couldn’t find the template or something along those lines.

1 Like