I am trying to connect to cockroachdb using the postgresql jdbc driver and hikaricp. I would also like to set certain session variables when doing so.
As mentioned in this issue - https://github.com/pgjdbc/pgjdbc/issues/1495#issuecomment-500781059, it can be done by passing the
options property. But if i execute the SHOW command immediately after doing so, i dont see the session variable value being reflected.
Is this expected? if so, how can i setup the session variables when initializing the backend server connection?