DataSource (Vertica JDBC API Documentation)

java.lang.Object
- com.vertica.jdbc.common.BaseConnectionFactory
- - com.vertica.jdbc.common.AbstractDataSource
  - - com.vertica.jdbc.hybrid.HybridAbstractDataSource
    - - com.vertica.jdbc.DataSource

All Implemented Interfaces:

java.sql.Wrapper, javax.sql.CommonDataSource, javax.sql.ConnectionPoolDataSource, javax.sql.DataSource
```
public class DataSource
extends com.vertica.jdbc.hybrid.HybridAbstractDataSource
implements javax.sql.DataSource
```

Field Summary
- Fields inherited from class com.vertica.jdbc.common.BaseConnectionFactory
  CONNECTION_LOCALE_KEY, s_Messages, URL_SEPARATOR

Constructor Summary

Constructors
Constructor and Description

DataSource()

Constructors
Constructor and Description
`DataSource()`

Method Summary

Methods
Modifier and Type	Method and Description
`boolean`	`areBatchInsertsDirect()` Get if batch inserts are direct for the data source.
`java.lang.String`	`getBackupServerNode()` Get list of backup server nodes.
`boolean`	`getBinaryTransfer()` Get whether or not connection uses binary transfer
`java.lang.String`	`getConnSettings()` Returns the session initialization sql that will run when a connection is established.
`java.lang.String`	`getDatabase()` Get the database for the data source.
`boolean`	`getDisableCopyLocal()` Gets the value of the connection setting that determines whether file-based COPY LOCAL operations are disabled.
`boolean`	`getEnableRoutableQueries()` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`boolean`	`getFailOnMultiNodePlans()` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`java.lang.String`	`getHost()` Get the host for the data source.
`java.lang.String`	`getHostNameVerifier()` Get if TLS Mode for the data source.
`java.lang.String`	`getJAASConfigName()` Gets the name of the JAAS configuration entry that will the driver will use when performing GSS authentication.
`java.lang.String`	`getKerberosHostName()` Gets the host name portion of the kerberos service principal that identifies the Vertica server.
`java.lang.String`	`getKerberosServiceName()` Gets the service name portion of the kerberos service principal that identifies the Vertica server.
`java.lang.String`	`getKeyStorePassword()` Gets the password for the keystore file.
`java.lang.String`	`getKeyStorePath()` Gets the path to the keystore file, or "" if not specified.
`java.lang.String`	`getLocale()` Get the locale for the data source.
`java.lang.String`	`getLogDirectory()` Gets the directory used to store log files
`int`	`getLoginTimeout()` Get the login timeout for the data source.
`com.vertica.support.LogLevel`	`getLogLevel()` Gets current level of logging
`java.lang.String`	`getLogNameSpace()` Gets package that logging is restricted to
`boolean`	`getMarsEnabled()`
`int`	`getMaxPooledConnections()` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`int`	`getMaxPooledConnectionsPerNode()` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`int`	`getMaxPooledConnectionUses()` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`int`	`getMetadataCacheLifetime()` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`int`	`getNodeDownWaitTime()` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`java.util.logging.Logger`	`getParentLogger()` Get parent Logger of all the Loggers used by this data source.
`short`	`getPort()` Get the port for the data source.
`int`	`getPortInt()` Get the port for the data source as an inteter.
`java.lang.String`	`getPreferredAddressFamily()` Gets the preferred address family type to be used when resolving hostnames.
`long`	`getResultBufferSize()` Get the maximum size of the client side ResultSet cache for the data source.
`java.lang.String`	`getSearchPath()` Get the schema search path for this data source.
`java.lang.String`	`getSessionLabel()` Get the session label for the data source.
`java.lang.String`	`getSocketFactoryName()` Get the custom socket factory name for the data source.
`java.lang.String`	`getSSLSocketFactoryName()` Get the custom SSL socket factory name for the data source.
`boolean`	`getStreamingBatchInsert()` Gets the value of the connection setting that determines whether the streaming or non-streaming batch insert model is used.
`java.lang.String`	`getTLSMode()` Get TLS Mode for the data source.
`int`	`getTransactionIsolation()` Get the transaction isolation for the data source.
`java.lang.String`	`getTrustStorePassword()` Gets the password for the truststore file.
`java.lang.String`	`getTrustStorePath()` Gets the path to the truststore file, or "" if not specified.
`boolean`	`isAutoCommitOnByDefault()` Get if autocommit is enabled by default for the data source.
`boolean`	`isReadOnly()` Get if the data source is read only.
`boolean`	`isSslEnabled()` Deprecated. `getTLSMode` method provide finer information.
`boolean`	`isWrapperFor(java.lang.Class<?> iface)`
`void`	`setAutoCommitOnByDefault(boolean isAutoCommit)` Set if autocommit is enabled by default for the data source.
`void`	`setBackupServerNode(java.lang.String backupServerNode)` Sets the list of backup server nodes for this data source.
`void`	`setBatchInsertsDirect(boolean isDirect)` Set if batch inserts should go directly to the ROS for the data source.
`void`	`setBinaryTransfer(boolean enabled)` Sets the flag that indicates whether or not to use binary transfer
`void`	`setConnectionLoadBalance(boolean useConnectionLoadBalance)` Sets the flag that indicates whether or not to use native load balancing.
`void`	`setConnSettings(java.lang.String sql)` ConnSettings are sql statements that the driver will execute when a connection is made.
`void`	`setDatabase(java.lang.String database)` Set the database for the data source.
`void`	`setDisableCopyLocal(boolean disabled)` Sets the value of the connection setting that determines whether file-based COPY LOCAL operations are disabled.
`void`	`setEnableRoutableQueries(boolean enabled)` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`void`	`setFailOnMultiNodePlans(boolean enabled)` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`void`	`setHost(java.lang.String host)` Set the host for the data source.
`void`	`setHostNameVerifier(java.lang.String hvn)` Set user defined HostnameVerifier.
`void`	`setJAASConfigName(java.lang.String name)` Sets the name of the JAAS configuration entry that will be used when performing GSS-Kerberos authentication.
`void`	`setKerberosHostName(java.lang.String name)` Sets the host name portion of the kerberos service principal that identifies the Vertica server.
`void`	`setKerberosServiceName(java.lang.String name)` Sets the service name portion of the kerberos service principal that identifies the Vertica server.
`void`	`setKeyStorePassword(java.lang.String paramString)` Sets the password protecting the keystore file.
`void`	`setKeyStorePath(java.lang.String paramString)` Sets the path to a keystore file (typically in .jks format) to be used for TLS connections.
`void`	`setLocale(java.lang.String locale)` Set the locale for the data source.
`void`	`setLogDirectory(java.lang.String paramString)` Sets the directory used to store log files.
`void`	`setLoginTimeout(int loginTimeout)` Set the login timeout for the data source.
`void`	`setLogLevel(java.lang.String paramString)` Sets the log level Valid values: OFF (no logging) INFO WARNING TRACE ERROR DEBUG (most verbose) An invalid value will set log level to OFF
`void`	`setLogNameSpace(java.lang.String value)` Sets the package that logging is restricted to.
`void`	`setMarsEnabled(boolean value)`
`void`	`setMaxPooledConnections(int max)` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`void`	`setMaxPooledConnectionsPerNode(int max)` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`void`	`setMaxPooledConnectionUses(int uses)` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`void`	`setMetadataCacheLifetime(int lifetime)` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`void`	`setNodeDownWaitTime(int waitTime)` Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
`void`	`setPort(int port)` Set the port for the data source as an integer.
`void`	`setPort(short port)` Set the port for the data source.
`void`	`setPreferredAddressFamily(java.lang.String value)` Sets the address family type to prefer when the driver resolves hostnames.
`void`	`setReadOnly(boolean readOnly)` Set if the data source is read only.
`void`	`setResultBufferSize(long size)` Set the maximum amount of data to cache in bytes when streaming ResultSet data.
`void`	`setSearchPath(java.lang.String searchPath)` Sets the schema search path for this data source.
`void`	`setSessionLabel(java.lang.String label)` Set the session label for the data source.
`void`	`setSocketFactoryName(java.lang.String socketFactoryName)` Set the custom socket factory name for the data source.
`void`	`setSslEnabled(boolean isSslEnabled)` Deprecated. `setTLSMode` provides finer grained control over the TLS connection process
`void`	`setSSLSocketFactoryName(java.lang.String sslSocketFactoryName)` Set the custom SSL socket factory name for the data source.
`void`	`setStreamingBatchInsert(boolean enabled)` Sets the value of the connection setting that determines whether the streaming or non-streaming batch insert model is used.
`void`	`setThreePartNaming(boolean useThreePartNaming)` Set three part naming for the data source.
`void`	`setTLSMode(java.lang.String mode)` Set TLS Mode for data source.
`void`	`setTrustStorePassword(java.lang.String paramString)` Sets the password protecting the truststore file.
`void`	`setTrustStorePath(java.lang.String paramString)` Sets the path to a truststore file (typically in .jks format) to be used for TLS connections.
`<T> T`	`unwrap(java.lang.Class<T> iface)`
`boolean`	`useConnectionLoadBalance()` Get whether or not connection load balancing is in use.
`boolean`	`useThreePartNaming()` Get if three-part naming is used for the data source.

Methods inherited from class com.vertica.jdbc.common.AbstractDataSource
getConnection, getConnection, getCustomProperty, getLogWriter, getPassword, getPooledConnection, getPooledConnection, getUserID, initialize, removeCustomProperty, setCustomProperty, setLogWriter, setPassword, setURL, setUserID

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface javax.sql.DataSource
getConnection, getConnection

Methods inherited from interface javax.sql.CommonDataSource
getLogWriter, setLogWriter

- Constructor Detail
  - DataSource
```
public DataSource()
```
- Method Detail
  - areBatchInsertsDirect
```
public boolean areBatchInsertsDirect()
```
    Get if batch inserts are direct for the data source.
    
    Returns:
    true if batch inserts go directly into the ROS for the data source.
  - getDatabase
```
public java.lang.String getDatabase()
```
    Get the database for the data source.
    
    Returns:
    The database for the data source.
  - getHost
```
public java.lang.String getHost()
```
    Get the host for the data source.
    
    Returns:
    The host for the data source.
  - getLocale
```
public java.lang.String getLocale()
```
    Get the locale for the data source.
    
    Returns:
    The locale for the data source.
  - getLoginTimeout
```
public int getLoginTimeout()
```
    Get the login timeout for the data source.
    
    Specified by:
    
    getLoginTimeout in interface javax.sql.CommonDataSource
    
    Overrides:
    
    getLoginTimeout in class com.vertica.jdbc.common.AbstractDataSource
    
    Returns:
    The login timeout for the data source.
  - getSocketFactoryName
```
public java.lang.String getSocketFactoryName()
```
    Get the custom socket factory name for the data source.
    
    Returns:
    The custom socket factory name for the data source.
  - getSSLSocketFactoryName
```
public java.lang.String getSSLSocketFactoryName()
```
    Get the custom SSL socket factory name for the data source.
    
    Returns:
    The custom socket factory name for the data source.
  - getResultBufferSize
```
public long getResultBufferSize()
```
    Get the maximum size of the client side ResultSet cache for the data source.
    
    Returns:
    The maximum size of the client side ResultSet cache for the data source.
  - getPort
```
public short getPort()
```
    Get the port for the data source.
    
    Returns:
    The port for the data source.
  - getPortInt
```
public int getPortInt()
```
    Get the port for the data source as an inteter.
    
    Returns:
    The port for the data source.
  - isReadOnly
```
public boolean isReadOnly()
```
    Get if the data source is read only.
    
    Returns:
    true if the data source is read only.
  - getSearchPath
```
public java.lang.String getSearchPath()
```
    Get the schema search path for this data source.
    
    Returns:
    A comma separated list of schemas.
  - getSessionLabel
```
public java.lang.String getSessionLabel()
```
    Get the session label for the data source.
    
    Returns:
    The session label for the data source.
  - getTransactionIsolation
```
public int getTransactionIsolation()
```
    Get the transaction isolation for the data source.
    
    Returns:
    The transaction isolation for the data source.
  - isAutoCommitOnByDefault
```
public boolean isAutoCommitOnByDefault()
```
    Get if autocommit is enabled by default for the data source.
    
    Returns:
    true if autocommit is enabled by default for the data source.
  - isSslEnabled
```
public boolean isSslEnabled()
```
    Deprecated. getTLSMode method provide finer information.
    
    Get if SSL is enabled for the data source.
    
    Returns:
    true if SSL is enabled (>= Require in TLSMode) for the data source.
  - getTLSMode
```
public java.lang.String getTLSMode()
```
    Get TLS Mode for the data source.
    
    Returns:
    Currently support Disable, Require, Verify-ca and Verify-full.
  - getHostNameVerifier
```
public java.lang.String getHostNameVerifier()
```
    Get if TLS Mode for the data source.
    
    Returns:
    Hostname verifer in use, default value is com.vertica.security.VerticaHostnameVerifier.
  - useConnectionLoadBalance
```
public boolean useConnectionLoadBalance()
```
    Get whether or not connection load balancing is in use.
    
    Returns:
    true if connection load balancing is enabled for the data source.
  - getBackupServerNode
```
public java.lang.String getBackupServerNode()
```
    Get list of backup server nodes.
    
    Returns:
    Comma-separated list of backup server nodes for this data source.
  - getParentLogger
```
public java.util.logging.Logger getParentLogger()
                                         throws java.sql.SQLFeatureNotSupportedException
```
    Get parent Logger of all the Loggers used by this data source.
    
    Specified by:
    
    getParentLogger in interface javax.sql.CommonDataSource
    
    Returns:
    the Logger farthest from the root Logger that is still an ancestor of all of the Loggers used by this data source
    
    Throws:
    
    java.sql.SQLFeatureNotSupportedException
  - setAutoCommitOnByDefault
```
public void setAutoCommitOnByDefault(boolean isAutoCommit)
```
    Set if autocommit is enabled by default for the data source.
    
    Parameters:
    isAutoCommit - true if autocommit is enabled by default for the data source.
  - setBatchInsertsDirect
```
public void setBatchInsertsDirect(boolean isDirect)
```
    Set if batch inserts should go directly to the ROS for the data source.
    
    Parameters:
    isDirect - true if batch inserts should go directly to the ROS. false to have batch inserts trickle through the WOS
  - setDatabase
```
public void setDatabase(java.lang.String database)
```
    Set the database for the data source.
    
    Parameters:
    database - The database for the data source.
  - setHost
```
public void setHost(java.lang.String host)
```
    Set the host for the data source.
    
    Parameters:
    host - The host for the data source.
  - setLocale
```
public void setLocale(java.lang.String locale)
```
    Set the locale for the data source.
    
    Parameters:
    locale - The locale for the data source.
  - setLoginTimeout
```
public void setLoginTimeout(int loginTimeout)
```
    Set the login timeout for the data source.
    
    Specified by:
    
    setLoginTimeout in interface javax.sql.CommonDataSource
    
    Overrides:
    
    setLoginTimeout in class com.vertica.jdbc.common.AbstractDataSource
    
    Parameters:
    loginTimeout - The login timeout for the data source.
  - setSSLSocketFactoryName
```
public void setSSLSocketFactoryName(java.lang.String sslSocketFactoryName)
```
    Set the custom SSL socket factory name for the data source. If set, this must be the name of a class that extends javax.net.ssl.SSLSocketFactory with a zero-argument constructor that is available on the class path. Typically the SSLSocketFactory will act as a wrapper for a raw socket, performing SSL/TLS encryption prior to forwarding the bytes to the underlying socket. If also using a cusom socket factory (via setSocketFactoryName(String socketFactoryName)), then that factory will create the raw socket and this factory will be passed that raw socket for I/O.
    
    Parameters:
    sslSocketFactoryName - The custom SSL socket factory name for the data source.
  - setSocketFactoryName
```
public void setSocketFactoryName(java.lang.String socketFactoryName)
```
    Set the custom socket factory name for the data source. If set, this must be the name of a class that extends javax.net.SocketFactory with a zero-argument constructor that is available on the class path.
    
    Parameters:
    socketFactoryName - The custom socket factory name for the data source.
  - setResultBufferSize
```
public void setResultBufferSize(long size)
```
    Set the maximum amount of data to cache in bytes when streaming ResultSet data.
    
    Parameters:
    size - A number of bytes.
  - setPort
```
public void setPort(int port)
```
    Set the port for the data source as an integer.
    
    Parameters:
    port - The port for the data source.
  - setPort
```
public void setPort(short port)
```
    Set the port for the data source.
    
    Parameters:
    port - The port for the data source.
  - setReadOnly
```
public void setReadOnly(boolean readOnly)
```
    Set if the data source is read only.
    
    Parameters:
    readOnly - true if the data source is read only.
  - setSessionLabel
```
public void setSessionLabel(java.lang.String label)
```
    Set the session label for the data source.
    
    Parameters:
    label - The session label for the data source.
  - setSslEnabled
```
public void setSslEnabled(boolean isSslEnabled)
```
    Deprecated. setTLSMode provides finer grained control over the TLS connection process
    
    Set if SSL is enabled for the data source.
    
    Parameters:
    isSslEnabled - true if SSL is enabled for the data source.
  - setTLSMode
```
public void setTLSMode(java.lang.String mode)
```
    Set TLS Mode for data source. value >= Require will enable TLS/SSL.
    
    Parameters:
    mode - Currently support Disable, Require, Verify-ca and Verify-full.
  - setHostNameVerifier
```
public void setHostNameVerifier(java.lang.String hvn)
```
    Set user defined HostnameVerifier. Only call this function when default hostnameverifier cannot fulfill the requirements.
    
    Parameters:
    hvn - String value of the customized hostnameverifier class location.
  - setThreePartNaming
```
public void setThreePartNaming(boolean useThreePartNaming)
```
    Set three part naming for the data source. When enabled, metadata ResultSets containing a catalog column will report the database name as the catalog, rather than NULL.
    
    Parameters:
    useThreePartNaming - true if three-part naming is enabled for the data source.
  - setSearchPath
```
public void setSearchPath(java.lang.String searchPath)
```
    Sets the schema search path for this data source.
    
    Parameters:
    searchPath - A comma separated list of schema names.
  - setBackupServerNode
```
public void setBackupServerNode(java.lang.String backupServerNode)
```
    Sets the list of backup server nodes for this data source.
    
    Parameters:
    backupServerNode - A comma separated list of vertica servers (host:port[,host:port...])
  - setConnectionLoadBalance
```
public void setConnectionLoadBalance(boolean useConnectionLoadBalance)
```
    Sets the flag that indicates whether or not to use native load balancing.
    
    Parameters:
    useConnectionLoadBalance - true if native load balancing is enabled for the data source.
  - useThreePartNaming
```
public boolean useThreePartNaming()
```
    Get if three-part naming is used for the data source. When enabled, metadata ResultSets containing a catalog column will report the database name as the catalog, rather than NULL.
    
    Returns:
    true if three-part naming is enabled for the data source.
  - getJAASConfigName
```
public java.lang.String getJAASConfigName()
```
    Gets the name of the JAAS configuration entry that will the driver will use when performing GSS authentication.
    
    Returns:
    A JAAS configuration name
  - setJAASConfigName
```
public void setJAASConfigName(java.lang.String name)
```
    Sets the name of the JAAS configuration entry that will be used when performing GSS-Kerberos authentication. The driver relies on JAAS to acquire a kerberos ticket-granting-ticket when the database server requests that the client uses GSS authentication. The JAAS configuration identified by this name can be used to customize this process.
    
    Parameters:
    name - The name of a configuration entry in a JAAS configuration file.
  - getKerberosServiceName
```
public java.lang.String getKerberosServiceName()
```
    Gets the service name portion of the kerberos service principal that identifies the Vertica server.
    
    Returns:
    The Vertica server's kerberos service name.
  - setKerberosServiceName
```
public void setKerberosServiceName(java.lang.String name)
```
    Sets the service name portion of the kerberos service principal that identifies the Vertica server. When the Vertica server requests that the client uses GSS authentication, the client uses this name to request a kerberos service ticket. The value of this property should match the database's KerberosServiceName config parameter.
    
    Parameters:
    name - The Vertica server's kerberos service name.
  - getKerberosHostName
```
public java.lang.String getKerberosHostName()
```
    Gets the host name portion of the kerberos service principal that identifies the Vertica server.
    
    Returns:
    The Vertica server's kerberos host name.
  - setKerberosHostName
```
public void setKerberosHostName(java.lang.String name)
```
    Sets the host name portion of the kerberos service principal that identifies the Vertica server. When the Vertica server requests that the client uses GSS authentication, the client uses this name to request a kerberos service ticket. The value of this property should match the database's KerberosHostName config parameter.
    
    Parameters:
    name - The Vertica server's kerberos host name.
  - getStreamingBatchInsert
```
public boolean getStreamingBatchInsert()
```
    Gets the value of the connection setting that determines whether the streaming or non-streaming batch insert model is used.
    
    Returns:
    true if batches are stored in memory, false if they are sent to the server immediately
  - setStreamingBatchInsert
```
public void setStreamingBatchInsert(boolean enabled)
```
    Sets the value of the connection setting that determines whether the streaming or non-streaming batch insert model is used.
    
    Parameters:
    enabled - True to store batches in memory, false to send them to the server immediately
  - getDisableCopyLocal
```
public boolean getDisableCopyLocal()
```
    Gets the value of the connection setting that determines whether file-based COPY LOCAL operations are disabled.
    
    Returns:
    true if file-based COPY LOCAL operations are disabled
  - setDisableCopyLocal
```
public void setDisableCopyLocal(boolean disabled)
```
    Sets the value of the connection setting that determines whether file-based COPY LOCAL operations are disabled.
    
    Parameters:
    disabled - True to disable file-based COPY LOCAL operations
  - getBinaryTransfer
```
public boolean getBinaryTransfer()
```
    Get whether or not connection uses binary transfer
    
    Returns:
    true if binary transfer is enabled
  - setBinaryTransfer
```
public void setBinaryTransfer(boolean enabled)
```
    Sets the flag that indicates whether or not to use binary transfer
    
    Parameters:
    enabled - True if binary transfer should be enabled
  - setConnSettings
```
public void setConnSettings(java.lang.String sql)
```
    ConnSettings are sql statements that the driver will execute when a connection is made. This is typically used to initialize session variables automatically with each connection.
    
    Parameters:
    sql - Semicolon-delimited sql statements that run when a connection is established.
  - getConnSettings
```
public java.lang.String getConnSettings()
```
    Returns the session initialization sql that will run when a connection is established. If no ConnSettings was specified, "" is returned.
    
    Returns:
    Semicolon-delimited sql thats that run when a connection is established.
  - getEnableRoutableQueries
```
@Deprecated
public boolean getEnableRoutableQueries()
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Get if VerticaRoutableConnections are returned by the data source.
    
    Returns:
    true if VerticaRoutableConnections are returned.
  - setEnableRoutableQueries
```
@Deprecated
public void setEnableRoutableQueries(boolean enabled)
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Set if VerticaRoutableConnections are returned by the data source.
    
    Parameters:
    enabled - true to enable VerticaRoutableConnections
  - getFailOnMultiNodePlans
```
@Deprecated
public boolean getFailOnMultiNodePlans()
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Get if non-local plans are allowed in VGet operations. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Returns:
    true if non-local plans are allowed.
  - setFailOnMultiNodePlans
```
@Deprecated
public void setFailOnMultiNodePlans(boolean enabled)
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Get if non-local plans are allowed in VGet operations. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Parameters:
    enabled - true to allow non-local plans, false to disable.
  - setMaxPooledConnectionUses
```
@Deprecated
public void setMaxPooledConnectionUses(int uses)
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Set the maximum number times to use a pooled connection before closing it. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Parameters:
    uses - The maximum number of times to use a pooled connection.
  - getMaxPooledConnectionUses
```
@Deprecated
public int getMaxPooledConnectionUses()
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Gets the maximum number times to use a pooled connection before closing it. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Returns:
    The maximum number of times to use a pooled connection.
  - setMaxPooledConnections
```
@Deprecated
public void setMaxPooledConnections(int max)
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Set the maximum number of pooled connections. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Parameters:
    max - The maximum number of pooled connections allowed open at a time.
  - getMaxPooledConnections
```
@Deprecated
public int getMaxPooledConnections()
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Gets the maximum number of pooled connections. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Returns:
    The maximum number pooled connections allowed open at a time.
  - setMaxPooledConnectionsPerNode
```
@Deprecated
public void setMaxPooledConnectionsPerNode(int max)
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Set the maximum number of pooled connections per node. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Parameters:
    max - The maximum number of pooled connections to a single node allowed open at a time.
  - getMaxPooledConnectionsPerNode
```
@Deprecated
public int getMaxPooledConnectionsPerNode()
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Gets the maximum number of pooled connections per node. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Returns:
    The maximum number pooled connections to a single node allowed at a time.
  - getMetadataCacheLifetime
```
@Deprecated
public int getMetadataCacheLifetime()
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Gets the number of seconds to reuse table and projection metadata during VGet operations. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Returns:
    Amount of time in seconds to keep metadata cached.
  - setMetadataCacheLifetime
```
@Deprecated
public void setMetadataCacheLifetime(int lifetime)
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Sets the number of seconds to reuse table and projection metadata during VGet operations. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Parameters:
    lifetime - Amount of time in seconds to keep metadata cached.
  - getNodeDownWaitTime
```
@Deprecated
public int getNodeDownWaitTime()
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Gets the number of seconds to wait before attempting a new connection to a node after detecting a connection failure. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Returns:
    Amount of time in seconds to wait before attempting another connection to a node.
  - setNodeDownWaitTime
```
@Deprecated
public void setNodeDownWaitTime(int waitTime)
```
    Deprecated. This feature is likely to stop working in a future release and to be removed as a result.
    
    Sets the number of seconds to wait before attempting a new connection to a node after detecting a connection failure. Only has an effect on VerticaRoutableConnections, i.e. when getEnableRoutableQueries() returns true.
    
    Parameters:
    waitTime - Amount of time in seconds to wait before attempting another connection to a node.
  - setPreferredAddressFamily
```
public void setPreferredAddressFamily(java.lang.String value)
```
    Sets the address family type to prefer when the driver resolves hostnames. When set to to "ipv6" the driver will attempt to use IPv6 type AAAA DNS records before IPv4 type A DNS records. When set to "ipv4", the driver will use IPv4 type A DNS records first. When set to "none" (the default), the driver will take no preference, and instead use the records in the order returned by the JRE.
    
    Parameters:
    value - The preferred address family to use. One of "ipv6", "ipv4" or "none"
  - getPreferredAddressFamily
```
public java.lang.String getPreferredAddressFamily()
```
    Gets the preferred address family type to be used when resolving hostnames.
    
    Returns:
    The preferred address family type for the data source.
  - setMarsEnabled
```
public void setMarsEnabled(boolean value)
```
  - getMarsEnabled
```
public boolean getMarsEnabled()
```
  - getLogNameSpace
```
public java.lang.String getLogNameSpace()
```
    Gets package that logging is restricted to
    
    Returns:
    Namespace for logging
  - setLogNameSpace
```
public void setLogNameSpace(java.lang.String value)
```
    Sets the package that logging is restricted to. Valid values:
    - com.vertica (all messages generated by the JDBC driver)
    - com.vertica.jdbc (all messages generated by the top-level JDBC API)
    - com.vertica.jdbc.core (connection and statement settings)
    - com.vertica.jdbc.io (client/server protocol messages)
    - com.vertica.jdbc.util (miscellaneous utilities)
    - com.vertica.jdbc.dataengine (query execution and result set iteration).
    Parameters:
    value - Namespace for logging
  - setLogLevel
```
public void setLogLevel(java.lang.String paramString)
```
    Sets the log level Valid values:
    - OFF (no logging)
    - INFO
    - WARNING
    - TRACE
    - ERROR
    - DEBUG (most verbose)
    An invalid value will set log level to OFF
    Overrides:
    
    setLogLevel in class com.vertica.jdbc.common.AbstractDataSource
    
    Parameters:
    paramString - String indicating the log level. Can also be numbers 1 to 6
  - getLogLevel
```
public com.vertica.support.LogLevel getLogLevel()
```
    Gets current level of logging
    
    Overrides:
    
    getLogLevel in class com.vertica.jdbc.common.AbstractDataSource
    
    Returns:
    The level of logging
  - setLogDirectory
```
public void setLogDirectory(java.lang.String paramString)
```
    Sets the directory used to store log files. The directory will be created if it does not exist.
    
    Overrides:
    
    setLogDirectory in class com.vertica.jdbc.common.AbstractDataSource
    
    Parameters:
    paramString - String indicating the directory to log to
  - getLogDirectory
```
public java.lang.String getLogDirectory()
```
    Gets the directory used to store log files
    
    Overrides:
    
    getLogDirectory in class com.vertica.jdbc.common.AbstractDataSource
    
    Returns:
    The log directory
  - setKeyStorePath
```
public void setKeyStorePath(java.lang.String paramString)
```
    Sets the path to a keystore file (typically in .jks format) to be used for TLS connections. If not specified, the JVM-global keystore is used.
    
    Parameters:
    paramString - String with a path to a keystore file
  - getKeyStorePath
```
public java.lang.String getKeyStorePath()
```
    Gets the path to the keystore file, or "" if not specified.
    
    Returns:
    The path to the keystore file
  - setTrustStorePath
```
public void setTrustStorePath(java.lang.String paramString)
```
    Sets the path to a truststore file (typically in .jks format) to be used for TLS connections. If not specified, the JVM-global truststore is used.
    
    Parameters:
    paramString - String with a path to a truststore file
  - getTrustStorePath
```
public java.lang.String getTrustStorePath()
```
    Gets the path to the truststore file, or "" if not specified.
    
    Returns:
    The path to the truststore file
  - setTrustStorePassword
```
public void setTrustStorePassword(java.lang.String paramString)
```
    Sets the password protecting the truststore file. Only used if a custom truststore path is specified.
    
    Parameters:
    paramString - The password to the truststore file
  - getTrustStorePassword
```
public java.lang.String getTrustStorePassword()
```
    Gets the password for the truststore file.
    
    Returns:
    The password for the truststore file.
  - setKeyStorePassword
```
public void setKeyStorePassword(java.lang.String paramString)
```
    Sets the password protecting the keystore file. Only used if a custom keystore path is specified. If both the keystore and the keys within the keystore are password protected, they must use the same password specified here.
    
    Parameters:
    paramString - The password to the keystore file
  - getKeyStorePassword
```
public java.lang.String getKeyStorePassword()
```
    Gets the password for the keystore file.
    
    Returns:
    The password for the keystore file.
  - unwrap
```
public <T> T unwrap(java.lang.Class<T> iface)
         throws java.sql.SQLException
```
    Specified by:
    
    unwrap in interface java.sql.Wrapper
    
    Overrides:
    
    unwrap in class com.vertica.jdbc.common.AbstractDataSource
    
    Throws:
    
    java.sql.SQLException
  - isWrapperFor
```
public boolean isWrapperFor(java.lang.Class<?> iface)
                     throws java.sql.SQLException
```
    Specified by:
    
    isWrapperFor in interface java.sql.Wrapper
    
    Overrides:
    
    isWrapperFor in class com.vertica.jdbc.common.AbstractDataSource
    
    Throws:
    
    java.sql.SQLException

Class DataSource

Field Summary

Fields inherited from class com.vertica.jdbc.common.BaseConnectionFactory

Constructor Summary

Method Summary

Methods inherited from class com.vertica.jdbc.common.AbstractDataSource

Methods inherited from class java.lang.Object

Methods inherited from interface javax.sql.DataSource

Methods inherited from interface javax.sql.CommonDataSource

Constructor Detail

DataSource

Method Detail

areBatchInsertsDirect

getDatabase

getHost

getLocale

getLoginTimeout

getSocketFactoryName

getSSLSocketFactoryName

getResultBufferSize

getPort

getPortInt

isReadOnly

getSearchPath

getSessionLabel

getTransactionIsolation

isAutoCommitOnByDefault

isSslEnabled

getTLSMode

getHostNameVerifier

useConnectionLoadBalance

getBackupServerNode

getParentLogger

setAutoCommitOnByDefault

setBatchInsertsDirect

setDatabase

setHost

setLocale

setLoginTimeout

setSSLSocketFactoryName

setSocketFactoryName

setResultBufferSize

setPort

setPort

setReadOnly

setSessionLabel

setSslEnabled

setTLSMode

setHostNameVerifier

setThreePartNaming

setSearchPath

setBackupServerNode

setConnectionLoadBalance

useThreePartNaming

getJAASConfigName

setJAASConfigName

getKerberosServiceName

setKerberosServiceName

getKerberosHostName

setKerberosHostName

getStreamingBatchInsert

setStreamingBatchInsert

getDisableCopyLocal

setDisableCopyLocal

getBinaryTransfer

setBinaryTransfer

setConnSettings

getConnSettings

getEnableRoutableQueries

setEnableRoutableQueries

getFailOnMultiNodePlans

setFailOnMultiNodePlans

setMaxPooledConnectionUses

getMaxPooledConnectionUses

setMaxPooledConnections

getMaxPooledConnections

setMaxPooledConnectionsPerNode

getMaxPooledConnectionsPerNode

getMetadataCacheLifetime

setMetadataCacheLifetime