The Vertica Database Forums

I need to set multipleActiveResultSets property using JDBC url and I have set it like below
jdbc:vertica://xxxx:5433/yyyy?searchPath=public&multipleActiveResultSets=true

but it is not working. how can I solve this problem?
Note: My DB connections are created by third party tool, so I can't add this property directly to VerticaConnection object.

Hi,

Maybe try the ConnSettings connection property? ConnSettings can contain a SQL statements that the JDBC driver automatically runs after it connects to the database. You can use this property to set the locale or schema search path, or perform other configuration that the connection requires.

Example:
jdbc:vertica://xxxx:5433/yyyy?ConnSettings=SET search_path=public;SET multipleactiveresultsets=ON