...
| Configuration Property | Type | Required (Driver) | Required (Datasource) | Definition |
|---|---|---|---|---|
| JDBC Driver | String | X | X | The JDBC Driver class name.
|
| JDBC URL Template | String | X (%h,%p, and %d) | The JDBC connection URL Template with %h, %p, and %d wild-cards.
| |
| 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. | |
| Data-source | String | X | Datasource name for datasource-managed connections. | |
| JNDI Properties | String | Optional 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 | Optional name of the password column where the account's passwords are stored. | ||
| Change Log Column | String | Optional 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 | Column quoting property (such as None, Single, Double, Back, or Brackets) that best fits your resource. Default is None. Column names display between single quotes, double quotes, back quotes, or brackets in the generated SQL when access the database. | ||
| Enable Empty String | Boolean | 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 | If false (default), 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. Select to throw exceptions when the ErrorCode is 0. Note: No other SQLExceptions are influenced by this property. | ||
| Native Timestamps | Boolean | If false (default), 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 | If false (default), 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 | If false (default), the connection is validated by switching the auto commit mode. For example, you might have select 1 from dummy, which might be more efficient on some databases. |
...