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.
how to set multipleActiveResultSets property
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: how to set multipleActiveResultSets property
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
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.