Parameters of the JDBC Connection URL¶
The table Parameters of the JDBC driver and their default value lists the optional configuration parameters of the URL and their default value:
Parameter of the URL |
Description |
---|---|
autoCommit |
If This is useful to make sure that an application does not start transactions inadvertently. Even with this parameter set to
true, an application can start and
finish transactions by executing the
statements If the client invokes
If the client invokes
See more about the limits on the duration of transaction in the section Transactions in Virtual DataPort of the VQL Guide. Default value: none. |
chunkSize |
The results of a query can be divided into blocks (chunks), so the Server does not have to wait for the query to finish, in order to begin sending part of the results to the client. This parameter establishes the maximum number of results that a block can contain. When the Server obtains enough results to complete a block, it sends this block to the driver and continues processing the next results. In an application that uses this
driver, you can either add this
parameter to the connection URL
and/or before executing the query,
invoke the method Default value: |
chunkTimeout |
This parameter establishes the
maximum time (in milliseconds) the
Server waits before returning a new
block to the driver. When this time
is exceeded, the Server sends the
current block to the driver, even if
it does not contain the number of
results specified in the
Note: if
Default value: |
describeNationalCharTypesAsBasicTypes |
If Default value: |
i18n |
This parameter establishes the internationalization (i18n) configuration of the connection with the Server. If not present, the driver assumes the i18n of the database that you are connecting to. The parameter Default value: I18N of the database that you are connecting to |
identifiersUppercase |
If The default value is Default value: |
initSize |
Number of connections that the driver will establish with the server during the initialization process. These connections will remain idle, ready to be used. Default value: |
maxActive |
When the parameter Default value: |
maxIdle |
When the parameter Default value: |
password |
Password used to authenticate
against Virtual DataPort. When using
this parameter, also provide the
value of the parameter Default value: N/A |
poolEnabled |
Note: this parameter is
deprecated and has been removed in
Denodo 7.0 The parameters
If If this property is Default value: |
publishViewsAsTables |
If If Some third-party tools require the
JDBC metadata to publish all the
views as tables in order to
recognize the associations created
between views. For these
applications, add this parameter to
the URL with the value Default value: |
queryTimeout |
Maximum time (in milliseconds) the driver will wait for a query to finish. After this period, it will throw an Exception. This parameter is optional. If it is not set, the query timeout has the default value (900000 milliseconds). If 0, the driver will wait indefinitely until the query finishes. This parameter sets the default timeout for all the queries. In addition, you can change the timeout for a single query by adding the parameter ‘QUERYTIMEOUT’ = ‘<value>’ to the CONTEXT clause of the query. See more about this in the section CONTEXT Clause of the Advanced VQL Guide. Default value: |
reuseRegistrySocket, pingQuery and pingQueryTimeout |
Parameters needed when connecting to Virtual DataPort through a load balancer. The section Connecting to Virtual DataPort Through a Load Balancer explains how to use them. Default value: None |
ssl |
By default, the driver tries to establish a non-SSL connection with the Server. If SSL is enabled on the Server, the connection fails and immediately, the driver tries to establish an SSL connection. If If Default value: None |
user |
User name used to authenticate
against Virtual DataPort. When using
this parameter, also provide the
value of the parameter Default value: N/A |
userAgent |
Sets the user agent of the connection. The section “Setting the User Agent of an Application” of the Administration Guide explains why we recommend setting this parameter. Default value: <empty> |
userGSSCredential |
Java object of the class
Use this parameter to pass a Kerberos credential, which the driver will use to connect to Denodo. See more about this property in the section Connecting to Virtual DataPort Using Kerberos Authentication Default value: none. |
wanOptimizedCalls |
If Setting this property to Default value: |
Autocommit
By default, the connections opened by the Denodo JDBC driver have the
property “autocommit” set to true
. This is the recommended value and
its effect is that the queries are not performed inside a transaction.
You should not change this property to false
unless you need the
statements to be executed inside the same transaction. The reason is
that Virtual DataPort uses a distributed transaction manager, which uses
a 2-phase commit protocol. This protocol introduces some overhead over
the queries. Therefore, if you set this property to false
without
needing it, your queries will run unnecessarily slower.