JDBC Driver

String

X

The JDBC Driver class name.

• Oracle is oracle.jdbc.driver.OracleDriver.

• MySQL is org.gjt.mm.mysql.Driver.

• H2 is org.h2.Driver

• Derby is org.apache.derby.jdbc.ClientDriver

JDBC URL Template

String

X

(%h,%p, and %d)

The JDBC connection URL Template with %h, %p, and %d wild-cards.

• Oracle template is jdbc:oracle:thin:@%h:%p:%d.

• MySQL template is jdbc:mysql://%h:%p/%d.

• H2 template is jdbc:h2:tcp://%h:%p/%d. 
  
  

• Derby template is jdbc:derby://%h:%p/%d. For more information, consult your JDBC driver documentation.

Host

String

when %h

Resource host. Used in place of the %h wild card in the URL Template.

Port

String

when %p

Resource port. Used in place of the %p wild card in the URL Template.

Database

String

when %d

Resource database. Used in place of the %d wild card in the URL template.

User

String

X 

Name of the resource admin user with rights to do SELECT, INSERT, UPDATE, or DELETE.

Password

String

X 

Resource admin user's password.

Datasource

String

X

Datasource name for datasource-managed connections.

JNDI Properties

String

Naming of datasource look-up properties.

Table

String

X 

X 

Name of the single table where the accounts are stored.

Key Column

String

X 

X 

Name of the column where the account's names are stored.

Password Column

String

Name of the password column where the account's passwords are stored.

Status Column

String

Name of the status column where the account's status (enabled/disabled/...) are stored.

Disabled Status Value

String

false

Value of 'status column' indicating disabled users.

Enabled Status Value

String

true

Value of 'status column' indicating enabled users.

Default Status Value

String

true

Default value for 'status column' in case of value not provided.

Change Log Column

String

Name of the column where the last update-related, non-decreasing, value is stored. This value can be a number or a timestamp value.

Quoting

String

Select whether database column names for this resource should be quoted, and the quoting characters. By default, database column names are not quoted (None). For other selections (Single, Double, Back, or Brackets), column names will appear between single quotes, double quotes, back quotes, or brackets in the SQL generated to access the database.

Enable Empty String

Boolean

false

Select to enable support for writing an empty string instead of a NULL value. By default empty strings are written as a NULL values.

Rethrow All SQL Exceptions

Boolean

true

If false, the SQLExceptions with a 0 ErrorCode are considered a success, or not an error, and they are caught and suppressed by the connector. For example, some databases return an exception for an empty result set. Note: No other SQLExceptions are influenced by this property.

Native Timestamps

Boolean

false

If false, timestamp data are read as Strings, which can cause the loss of time milliseconds. Select to retrieve the data as java.sql.Timestamp type, and have the connector perform the conversion.

All Native

Boolean

false

If false, the attribute data are converted to Strings using the JDBC driver. Select to use the appropriate JDBC types and force the connector perform the conversion as needed.

Valid Connection Query

String

The new connection validation query. The query can be empty. Then the auto commit true/false command is applied by default.

Password cipher algorithm

String

CLEARTEXT

Cipher algorithm used to encode password before to store it onto the database table. Specify one of the values among CLEARTEXT, AES, MD5, SHA1, SHA256 or a custom implementation identified by its class name.

Password cipher key

String

Specify key in case of reversible algorithm.

Force password encoding to upper case

Boolean

false

Specify if encoded password must be converted to use uppercase letters. Please, consider that by using this feature password won't be reversible any more, neither using reversible algorithm.

Force password encoding to lower case

Boolean

false

Specify if encoded password must be converted to use lowercase letters. Please, consider that by using this feature password won't be reversible any more, neither using reversible algorithm.

Retrieve password

Boolean

false

Specify if password must be retrieved by default.

Password Charset

String

UTF-8

The password character set used by resource to encode clear password specified as required by java.nio.Charset

"column name"

This attribute is required when "column" is NOT NULL. Blobs, clobs, and binaries are not returned by default.

All columns ...

PASSWORD

This attribute is required for a Password Column and it is not readable or returned by default.

NAME

This attribute is required.