Input
Description
Required
<adapter name>
Specifies the name of the adapter to use for this process
Default value: SQLAdapter
No
<sql>
Specifies the SQL query statement to be executed
Yes
<target>
Identifies the target defined in the SQL actor adapter configuration in Grid Manager
No
<host>
Specifies the host name or the IP address of the database server
No
<port>
Specifies the port on which the database server listens
No
<user name>
Specifies the user name used for database authentication
No
<password>
Specifies the password that corresponds to the user name provided
No
<subprotocol>
Specifies the driver-specified subprotocol used to build a connection
The adapter prepends to the provided value.
No
<database>
Specifies the name of the database to which the adapter connects
No
<driver>
Specifies the fully qualified JDBC driver classname
Valid values: com.sybase.jdbc3.jdbc.SybDriver, oracle.jdbc.driver.OracleDriver.
No
<character-set>
Specifies the supporting charset
Also called character set, it includes identifiers describing a series of universal characters.
You must specify the <character-set> element only if the target database is MySql.
No
<url>
Specifies the complete connection URL for the target database
No
<max wait>
Specifies the maximum time, in milliseconds, to wait before timing out while establishing a connection to a database
No
<max connection idle time millis>
Specifies the maximum time, in milliseconds, that a connection can remain idle before being evaluated for termination
No
<min connection idle time millis>
Specifies the minimum time, in milliseconds, that a connection can remain idle before being evaluated for termination
No
<evictor idle time millis>
Specifies the frequency, in milliseconds, at which a thread closes an idle connection that is running
No
<max active connections>
Specifies the maximum number of connections allowed in the connection pool
No
<initial active connections>
Specifies the minimum number of connections created during adapter startup
No
<max idle connections>
Specifies the maximum number of allowed idle connections allowed at any time
No
<min idle connections>
Specifies the minimum number of idle connections allowed at any time
No
<validate query>
Specifies the query statement used to validate the connection
No
<validate connections on return>
Indicates whether a connection is validated when returned to the pool
With a value of true, the connection is evaluated to determine the status and, if not alive, the connection is removed from the pool.
No
<validate idle connections>
Indicates whether periodic checks are done on idle connections in the pool With a value of true, the connection is evaluated to determine the status and, if not alive, the connection is removed from the pool.
No
<connection name>
Specifies the reference name of a connection to the specified target
No
<ktgt cache file>
Specifies the location of a valid Kerberos Ticket Granting Ticket (TGT) to obtain a connection through the Kerberos tunnel
For the Windows OS, the path should be a fully qualified path
using double slashes ('\\') instead of a single slash ('\')
to the krb ticket file.Example:
C:\\testFolder\\ticketFile <ktgt-cache-file>/tmp/krb5cc_0 </ktgt-cache-file>
No
<krb service principal>
Specifies the name of the service principal registered with the Sybase database to allow Kerberos authentication
This element is required if the <ktgt-cache-file> element is used.
For example:
<krb-service-principal>
</krb-service-principal>
Conditional
