Adding more than 1 Additional JDBC connection string options

1

I have tried multiple ways to do this and can’t figure out how to delimit multiple values. This is for a Postgres database.

1 Like
2

Hi @mhollibaugh
It’s & (ampersand) for most databases, but there’s a few that uses ; (semicolon).
https://jdbc.postgresql.org/documentation/head/connect.html (just for reference, Metabase might deviate a tiny bit)
Probably easier if you post what you’re trying to use here.

3

We have a long running query for a question that times out at 60 seconds with the metabase log showing cancelling statement due to user request. We have verify that the same question run as a query outside of metabase is not timing out from postgres so we are trying to figure out what to do to set the timeout higher. Any suggestions would be greatly appreciated.

4

@mhollibaugh
Okay, it has nothing to do with what you’re messing with.
That’s because you are using a proxy that closes the connection between the user and Metabase. Change your proxy timeout settings.
Read this for more context: https://github.com/metabase/metabase/issues/12423

5

Thank you, NGINX settings fixed it.

6

Hi,
I think I have exactly the same problem. Could you please tell me which file you changed in Nginx?

Thanks

7

Please check nginx documentation

1 Like