Setting session variables like SYNCHRONOUS_COMMIT in connection url

[pct960]

Hi everyone!

I was wondering how to set session variables like SYNCHRONOUS_COMMIT in the connection URL. Tried using &synchronous_commit=off and sessionVariables=SYNCHRONOUS_COMMIT=OFF in the URL, but neither worked. Would greatly appreciate any help on this :)

Regards,
Tej

[davecramer]

From the docs https://jdbc.postgresql.org/documentation/use/

Properties props = new Properties();
props.setProperty("options", "-c search_path=test,public,pg_catalog -c statement_timeout=90000");
Connection conn = DriverManager.getConnection(url, props);

String url = "jdbc:postgresql://localhost:5432/postgres?options=-c%20search_path=test,public,pg_catalog%20-c%20statement_timeout=90000";
Connection conn = DriverManager.getConnection(url);

[pct960]

Thanks!