Authenticate Script

String

Authenticate groovy script

Authenticate Script File Name

String

Path of authenticate groovy script file

Name 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.

Delete Script

String

Delete groovy script

Search Script

String

Search groovy script

Update Script File Name

String

Path of update groovy script file

Create Script

String

Create groovy script

Auto commit

Boolean

With this parameter set to true, each SQL statement is treated as a transaction. It is automatically committed right after it is executed.

Search Script File Name

String

Path of search groovy script file

Create Script File Name

String

Path of create groovy script file

Clear Text Password To Script

Boolean

Should password be passed to scripts in clear text?

Delete Script File Name

String

Path of delete groovy script file

Schema Script File Name

String

Path of schema groovy script file

Reload Script On Execution

Boolean

By default, scripts are loaded and compiled when a connector instance is created and initialized.
Setting this parameter to true will make the connector load and compile the script every time it is called.

Use only for test/debug purpose since this can have a significant impact on performance.

Test Script

String

Test groovy script

Test Script File Name

String

Path of test groovy script file

Update Script

String

Update groovy script

Scripting Language

String

The scripting language; only default value GROOVY is currently supported.

Sync Script File Name

String

Path of sync groovy script file

Sync Script

String

Sync groovy script

Host

String

Enter the name of the host where the database is running.

Port

String

Enter the port number the database server is listening on.

User

String

Enter the name of the mandatory Database user with permission to account table.

User Password

GuardedString

Enter a user account that has permission to access accounts table.

Database

String

Enter the name of the database on the database server that contains the table.

JDBC Driver

String

Specify the JDBC Driver class name. Oracle is oracle.jdbc.driver.OracleDriver. MySQL is org.gjt.mm.mysql.Driver. Could be empty if datasource is provided.

JDBC Connection URL

String

Specify the JDBC Driver Connection URL. Oracle template is jdbc:oracle:thin:@[host]:[port(1521)]:[DB].  MySQL template is jdbc:mysql://[host]:[port(3306)]/[db], for more info, read the JDBC driver documentation. Could be empty if datasource is provided.

Enable writing empty string

Boolean

Select to enable support for writing an empty strings, instead of a NULL value, in character based columns defined as not-null in the table schema. This option does not influence the way strings are written for Oracle based tables. By default empty strings are written as a NULL value.

Rethrow all SQLExceptions

Boolean

If this is not checked, SQL statements which throw SQLExceptions with a 0 ErrorCode will be have the exception caught and suppressed. Check it to have exceptions with 0 ErrorCodes rethrown.

Native Timestamps

Boolean

Select to retrieve Timestamp data type of the columns in java.sql.Timestamp format from the database table.

All native

Boolean

Select to retrieve all data type of the columns in a native format from the database table.

Validate Connection Query

String

There can be specified the check connection alive query. If empty, default implementation will test it using the switch on/off the autocommit. Some select 1 from dummy table could be more efficient.

Datasource Path

String

Enter the JDBC Data Source Name/Path to connect to the Oracle server. If specified, connector will only try to connect using Datasource and ignore other resource parameters specified. The example value is: jdbc/SampleDataSourceName

Initial JNDI Properties

String

Could be empty or enter the JDBC JNDI Initial context factory, context provider in a format: key = value.