how to set multipleActiveResultSets property

Moderator: NorbertKrupa

Post Reply
Posts: 1
Joined: Wed Aug 02, 2017 12:15 pm

how to set multipleActiveResultSets property

Post by koteswar » Wed Aug 02, 2017 12:30 pm

I need to set multipleActiveResultSets property using JDBC url and I have set it like below

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.

User avatar
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am

Re: how to set multipleActiveResultSets property

Post by JimKnicely » Wed Aug 02, 2017 3:49 pm


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.

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


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “General”