Basic

Database

databaseName

string

The name of the database to connect to in multi-tenant database container systems.

Text Box

Basic

User

user

string

The user name. Optional, depending on the authentication method used.

Text Box

Basic

Password

password

password

The user password. Optional, depending on the authentication method used.

Text Box

Basic

Schema

currentschema

string

Sets the current schema, which is used for identifiers without schema.

Defaults to current user name

Text Box

Basic

Read Only

readOnly

boolean

When enabled, only read-only statements are permitted. Attempting to execute DLL or DML causes an exception.

false

Toggle

Advanced

Autocommit

autocommit

boolean

When in autocommit mode, every statement is automatically committed. Otherwise, commits and/or rollbacks must be done manually.

true

Toggle

Advanced

Close handles on finalize

closeHandlesOnFinalize

boolean

When enabled, connections, statements, and result sets are automatically closed when their Java finalizers are run.

true

Toggle

Advanced

Connection timeout

communicationTimeout

int

Connection timeout in milliseconds. Setting this option to 0 disables the timeout.

0

Text Box

Advanced

Distribution

distribution

enum

OFF,CONNECTION, STATEMENT, ALL

Choose the distribution mode. Specifying STATEMENT does not include CONNECTION distribution.

STATEMENT

Radio Button

Advanced

Empty Timestamp is NULL

emptyTimestampIsNull

boolean

When enabled, DAYDATE, SECONDTIME, SECONDDATE, and LONGDATE values inserted as empty strings are returned as NULLs. When disabled, these values are returned as out-of-band values.

false

Toggle

Advanced

Encryption

encrypt

boolean

When enabled, all communication is encrypted via SSL.

false

Toggle

Advanced

Ignore topology

ignoreTopology

 boolean

true = Use the topology unless port-forwarding is detected

true = Always ignore the topology

false

Toggle

Advanced

Transaction isolation

isolation

enum

READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, SERIALIZABLE

Sets the isolation level for the connection.

READ_COMMITTED

Radio Button

Advanced

HDB User Key

key

string

The key for the HdbUserStore.

Text Box

Advanced

Locale

locale

string

ISO locale code

The client locale

Text Box

Advanced

Packet size

packetsize

int

Sets the maximum size of a request packet sent from the client to the server in bytes. The minimum is 130, 000 bytes.

130000

Text Box

Advanced

Reconnect

reconnect

boolean

When enabled, the system automatically reconnects to the database instance after a command timeout or a when the connection was broken and reconnecting restores the old state (for example, if no transaction was open).

true

Toggle

Advanced

Split Batch Commands

splitBatchCommands

boolean

Allow split and parallel execution of batch commands on partitioned tables.

false

Toggle

Advanced

Virtual Host Name

virtualHostName

string

The virtual host name. This value is ignored if no HdbUserStore key is specified.

Text Box

BOOLEAN

Schema.Type.BOOLEAN

TINYINT

Schema.Type.INT

SMALLINT

Schema.Type.INT

INTEGER

Schema.Type.INT

BIGINT

Schema.Type.LONG

SMALLDECIMAL

Schema.Type.DECIMAL

DECIMAL

Schema.Type.DECIMAL

REAL

Schema.Type.FLOAT

DOUBLE

Schema.Type.DOUBLE

VARCHAR

Schema.Type.STRING

NVARCHAR

Schema.Type.STRING

ALPHANUM

Schema.Type.STRING

SHORTTEXT

Schema.Type.STRING

DATE

Schema.Type.DATE

TIME

Schema.Type.DATE

SECONDDATE

Schema.Type.DATE

TIMESTAMP

Schema.Type.TIMESTAMP_MICRO

VARBINARY

Schema.Type.BYTES

BLOB

Schema.Type.BYTES

CLOB

Schema.Type.BYTES

Not sure about BYTES or STRING

NCLOB

Schema.Type.BYTES

TEXT

Schema.Type.STRING

ARRAY

Schema.Type.ARRAY