Field | Description/Action |
Table Name | Select a table name. The default for the associated catalog name is current catalog. The default for the associated schema name is current schema. The table name must not contain a period. If the table name does contain a period, Designer will throw an error. Note: Informix databases do not allow you to specify a catalog and database name because you can only access the current catalog. |
Type | The table type displays automatically based on the table you select. |
Field | Description/Action |
Column | The UPDATE column name in the database table. |
Column Type | The UPDATE column data type in the database table. |
JDBC Type | The JDBC type of the corresponding Input Field. |
Expression | The default value is ?, which acts as a placeholder for the variable so that you can set the input variable for that column at run time, or get input external to this adapter service. It adds one row with the same column name to the table. You can also type a fixed value in this field now or at run time. If you type a fixed value, be sure that it is valid, or an exception will be generated at run time. |
Field | Description/Action |
Column | The UPDATE column name in the database table. |
Column Type | The column data type defined in the database table. |
Input Field | The input field name. You can change this name if needed. |
Input Field Type | The data type of the input field. You can change this type if needed. Note: If you use WmFlatFile services to generate the document list as input, the input field type must be java.lang.String. This is because fields from WmFlatFile services generate documents are have String fields. |
Field | Description/Action |
Query Time Out | The query time out value in seconds. This value is the amount of time Adapter for JDBC waits for the service to execute before stopping the SQL operation. The time out specified in the Query Time Out field is not guaranteed but depends on the implementation specific to the driver vendor. The JDBC standard Statement.SetQueryTimeout() method relies on the Statement.cancel() method. When execution takes longer than the specified time-out interval, the monitor thread calls Statement.cancel(). In some cases, because of a limitation in the Statement.cancel() method, the time out does not free the thread that invoked the Statement.execute() method and this may lead to higher waiting times. The default value is -1. Use the default value to have the service use the value indicated on the watt.adapter.JDBC.QueryTimeout property as the time out. If you specify a value equal to 0, or if the watt.adapter.JDBC.QueryTimeout property is not set, the service executes without a time out. If you specify a value greater than 0, the service executes with the specified value as the time out. Note: -1 is the only permissible negative value for this field. For more information about the watt.adapter.JDBC.QueryTimeout property, see
Forcing a Timeout During Long-Running SQL
Operations in Services and Notifications. |
Field | Description/Action |
AND/OR | The logical operator. |
Column | The name of the column you want to use in the WHERE clause. |
Operator | The operator used with the Column and Input Field. |
Input Field | The default value is ?, which acts as a placeholder for the variable so that you can set the input variable for that column at run time, or get input external to this adapter service. You can also type a fixed value in this field now or at run time. If you type a fixed value, be sure that it is valid, or an exception will be generated at run time. |
JDBC Type | The JDBC type of the corresponding Input Field. |
Input Field Type | The corresponding input field's Java type. For a list of JDBC type to Java type mappings, see
JDBC Data Type to Java Data Type
Mappings. |
Input Field (second occurrence of this field) | Type the name of the input field. If you use the default ? variable placeholder as the Input Field value in the where clause, be sure to enter the corresponding Input Field and its JDBC Field Type in the same order as they appear on the top portion of the WHERE tab. |