JDBC connection strings
To connect to a JDBC data source, you must create a connection string.
A Netezza JDBC connection string consists of the following parts in the following order:
jdbc:netezza://
(mandatory).- A host name (mandatory) and a port number (optional if you are using port 5480), followed by a forward slash (/). If you specify a port number, separate it from the host name with a colon (:).
- A database name followed by a semicolon (;) (mandatory).
- Property names and their values, specified as name=value pairs (optional). Separate a name=value pair from the next name=value pair by using a semicolon (;).
main
is the host name, and
sales
is the database name.
jdbc:netezza://main:5490/sales;user=admin;password=password;loglevel=2;logdirpath=C:\
The following table contains the properties and values that you can specify when
creating the connection string. The properties and values are not case sensitive.
Property | Description |
---|---|
applicationName | Specifies the application name. |
autocommit | Specifies whether autocommit applies to the connection. Valid values are true (the default) and false. |
batchSize | Specifies the number of rows to be fetched in a cycle. The default is 256. |
caCertFile | Specifies the name of the certificate authority (CA) file that is used to authenticate connections. If you use a CA for authentication, the name of the CA file must match the name that the security administrator defined for the database to which you are attempting to connect. For more information about security and authentication, see the IBM® Netezza® System Administrator’s Guide. |
clientHostName | Specifies the client host name. |
clientUser | Specifies the client user. |
database | Specifies the database name. |
DatabaseMetaData | Specifies whether you can get metadata information that is not restricted to the current catalog and schema. Valid values are false (the default, meaning that the information is restricted to the current catalog and schema) and true. |
description | Specifies the description for the data source. |
dsn | Specifies a data source name. If you specify this property, the connection string properties
and values in the nzjdbc.ini file that are associated with that data source are
used, unless you specify those properties and values directly in the connection string. For example,
if you specify the connection string jdbc:netezza//localhost/dsn=nzsql , the
properties and values that are associated with the nzsql data source name in the
nzjdbc.ini file are used, unless you specify the properties and values directly
in the connection string. You can create the nzjdbc.ini file by using a GUI on Windows operating systems or command-line prompts on Linux and UNIX operating systems. For information about creating the nzjdbc.ini file, see Configuring the JDBC data source by using an nzjdbc.ini file (Windows) or Configuring the JDBC data source by using an nzjdbc.ini file (UNIX and Linux). |
host | Specifies the name of the host to connect to. |
ignoreUpdateCount | Specifies whether the JDBC driver is allowed to export more than two billion rows (the maximum int value). Valid values are off (the default) and on. |
krbLoginModule | Specifies the entry module name of the set of Kerberos properties from the login.conf file. The JDBC driver uses the login module class to create authentication tickets. |
krbSSODelegation | Specifies that if you configure an IBM Cognos Business Intelligence application in Kerberos SSO mode, the JDBC driver uses the authentication ticket that the Cognos product provides. |
logDirPath | Specifies the log directory into which the log files are written. |
loggerType | Specifies the type to be used for logging. Valid values are TEXT (the default) and HTML. |
loginTimeout | Specifies the maximum wait time to make a connection. The default is infinite. |
logLevel | Specifies the log level for the connection. The default is OFF. |
port | Specifies the port number. |
readonly | Specifies whether the connection is read only. Valid values are false (the default) and true. |
securityLevel | Specifies the security level. Values are as follows:
|
schema | Specifies the name of the schema within the specified database on the Netezza Performance Server system. This property is used for
Netezza Performance Server systems that support multiple
schemas within a database. If you do not specify a schema, you connect to the default schema of the
database. Important: Calling the setSchema method to
specify a new schema causes all future queries, including those using previously created or prepared
Statement objects, to use the new schema. This behavior is different from that
documented in the Oracle JDBC specification.
|
user | Specifies the user name to connect to the database. |
password | Specifies the password for authentication. |