Hello everyone, I’m new to DAML, and trying to integrate PostgreSQL server. When, I try execute below command, “The API server was unable to bind to port 6865. Terminate the process occupying the port, or choose a different one.” exception is thrown. java -jar daml-on-sql-1.18.2.jar --ledgerid=t…

There should be something along the lines of a --port CLI option, although I don’t remember exactly the name. Can you have a look if java -jar daml-on-sql-1.18.2.jar --help (documented here ) gives you some meaningful pointer?

It is indeed --port, though -p also works: Daml-on-SQL version 1.18.2 Usage: daml-on-sql [options] [<archive>...] <archive>... Daml archives to load in .dar format. Only Daml-LF v1 Archives are currently supported. Can be mixed in with optional arguments. -a, --address <value> S…

Thanks for the quick responses @stefanobaghino-da & @Gary_Verhaegen !! One more question though, how do I configure my DAML project to connect to the specified ledger-id on the new port

Use --ledgerid as you used above, like so java -jar daml-on-sql-1.18.2.jar --port <your_port_number> --ledgerid=test --sql-backend-jdbcurl="jdbc:postgresql://mydbserver.com:5432/test_db?user=test_db_user&password=userPass123&currentSchema=public"

DAML database integration

App Development

Stephen June 3, 2022, 1:48pm 6

Since you are using SDK 2.1.1, I recommend that you move away from Daml-on-SQL, to a Canton setup with Postgres as backend, as soon as possible. Daml-on-SQL is no longer supported. See this previous thread:

Topic		Replies	Views
What's the difference between Daml Driver for Postgres and Daml Sandbox w/ Postgres? App Development daml , sandbox , daml-on-sql	6	947	March 31, 2021
Cannot connect to the ledger server, error: io.grpc.StatusRuntimeException: UNAVAILABLE: io exception App Development	6	741	December 9, 2020
DAML server App Development daml , daml-sdk , ledger-api	8	302	December 15, 2021
Json API and postgres App Development ledger-api	4	374	April 25, 2022
How to use daml-on-sql App Development	1	363	December 22, 2020

DAML database integration

Related topics