Update process

<adapter name>

Specifies the name of the adapter to use for this process

Default value: SQLAdapter

No

<table>

Specifies the table to update

Yes

<column>

Specifies the column to update

Yes

<value>

Specifies the value to place in the updated column

Yes

<where>

Specifies the conditional expression used to determine the rows to be updated

If you do not specify a value for this input, all the rows are updated. Do not include the where command in the expression; it is supplied by the process.

No

<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

<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 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>REALOPSLINUX1@SYNAPSE.COM</krb-service-principal>

Conditional

<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