[JDBC] Vertica JDBC Driver Properties

Vertica JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
autocommit	If false, the connection will start with autocommit disabled	false	false true	null
backupservernode	A comma separated list of host:port pairs to use if primary server is unavailable	false	?	null
connectionloadbalance	If true, use native load balancing	false	false true	null
connsettings	SQL to run after a connection is established to change session properties on the server	false	?	null
directbatchinsert	If true, batch insert data is written directly to the ROS	false	false true	null
enableroutablequeries	If true, connections returned will implement VerticaRoutableConnection and provide access to the VGet API	false	false true	null
failonmultinodeplans	If true, VGet operations that require more than a single node's resources are disallowed	false	false true	null
jaasconfigname	The name of a JAAS configuration that the driver should use when performing GSS authentication	false	?	null
kerberoshostname	The host name portion of the kerberos service principal that identifies the Vertica server	false	?	null
kerberosservicename	The service name portion of the kerberos service principal that identifies the Vertica server	false	?	null
logintimeout	The amount of time to spend establishing a connection before giving up	false	?	null
loglevel	The amount of detail to include in log messages	false	error trace off debug warning info	null
lognamespace	A package name to restrict logging to	false	?	null
logpath	The directory to store the log file in	false	?	null
maxpooledconnections	The maximum number of connections allowed in the VerticaRoutableConnection's connection pool	false	?	null
maxpooledconnectionspernode	The maximum number of connections allowed to a single node in the VerticaRoutableConnection's connection pool	false	?	null
maxpooledconnectionuses	The maximum number of times to use a pooled connection before closing it	false	?	null
metadatacachelifetime	Time in seconds to cache table and projection metadata used during VGet operations	false	?	null
nodedownwaittime	Time in seconds to wait before attemptng a new connection to a node after a connection failure occurs	false	?	null
preferredaddressfamily	The address family type to prefer when resolving hostnames	false	ipv6 ipv4 none	null
readonly	If true, commands that modify the database in any way will result in an error	false	false true	null
resultbuffersize	The size in bytes of the client side result cache (one per ResultSet)	false	?	null
sessionlabel	A string to identify the JDBC connection's session on the server	false	?	null
ssl	If true, connect using SSL	false	false true	null
streamingbatchinsert	If true, send PreparedStatement batch insert data to the server as it arrives via addBatch() instead of holding in memory until executeBatch(). Streaming is faster and uses less memory, but while a streaming batch insert is in progress PreparedStatement.clearBatch() is disabled and other connection operations are not allowed	false	false true	null
threepartnaming	If true, use the database name as the catalog name when reporting metadata	false	false true	null
transactionisolation	The default transaction isolation level to use	false	2 0 8	null