Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI SQL Client JDBC

TABLE OF CONTENTS

Driver properties

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedJan 04, 2023
  • 2 minute read

Driver properties are used to specify details for making a connection to the underlying database. PI SQL Client JDBC has only optional properties. The properties are not case sensitive.

These driver properties can only be specified if exposed by the JDBC client or from a development environment. For example, driver properties can be exposed by DBVisualizer.

Driver properties

The following driver properties can be used with PI SQL Client JDBC:

Driver property

Description

Examples

User

Username for PI SQL DAS (RTQP) login.

Password

Password for PI SQL DAS (RTQP) login.

Trusted Connection

Specifies whether Kerberos authentication is used to establish the connection.

Values:

  • True or Yes - user and password are not required and ignored if specified.

  • False or No - user and password are required.

    Note: If you do not specify either Trusted Connection or User and Password, Trusted Connection is used.

Trusted Connection = False

Log File

Full path and file name for the log file.

Log File = C:\Temp\Log\PIJDBC.log

Log to Console

Print log messages to console.

Values:

  • True or Yes - Log messages are written to the console.

  • False or No - Log messages are not written to the console (Default).

Log to Console = False

Log Level

Specifies granularity of messages to be logged. Values: 0-5

See Standard logging levels for what is logged at each level.

Log Level = 3

Use Keytab

Specifies whether to use Java KeyTab to get a Kerberos ticket when Trusted Connection is set to True. Has no effect when Trusted Connection is set to False.

Values:

  • True or Yes - Uses the KeyTab for Kerberos connection. Requires PISQLJDBCLogin.conf, krb5.keytab, and krb5.ini/krb5.conf. See Kerberos configuration for details.

  • False or No - Does not use the KeyTab for Kerberos connection (Default).

Use Keytab = False

Initial Catalog

Specifies the initial catalog.

Note: By default, the data model for PI SQL Client consists of one catalog - Master. This catalog contains a set of tables and table-valued functions. To create other catalogs, after successful connection, execute the create catalog query (CREATE Catalog <CatalogName>).

Initial Catalog = Master

Command Timeout

Specifies the command timeout in seconds. Enforces the default query timeout for all statements originated from this connection. Can be overwritten per statement. Defaults to 0 (no timeout).

Command Timeout = 20

Time Zone

Defaults to Local. You can select a specific time zone used for parsing of timestamp literals and for rendering of timestamp column values. Supports IANA time zone format.

Note: PI SQL Client JDBC uses the local time zone of the client (not the server)

Time Zone = Europe/Berlin

Query Date

Defaults to Latest. You can enter any PI time expression. See the PI Server topic, PI Time.

Query Date = Latest

TitleResults for “How to create a CRG?”Also Available in