how to set multipleActiveResultSets property

Moderator: NorbertKrupa

Post Reply
koteswar
Newbie
Newbie
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
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.

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

Re: how to set multipleActiveResultSets property

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

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
Jim Knicely

Image

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

Post Reply

Return to “General”