The following properties in a SQL form handler component control mapping between the SQL table and the form:

Property

Function

columns

The names of columns to look up, update, and insert. If this property is not set, all columns in the table are used.

connectionURL

JDBC URL of the database connection to use. Typically, this is the URL of a connection pool in the form:

jdbc:atgpool:pool-name

keyColumns

Names of columns to use to find the row on which to perform lookup, update, and delete operations.

metaDataCatalogName

String representing a catalog name. If the active database user does not own the tables accessed by the SQL repository, this property is referenced once during initialization of the logger in a call to determine the column types.

metaDataSchemaPattern

String representing a schema name pattern. If the active database user does not own the tables accessed by the SQL Repository, this property is referenced once during initialization of the repository in a call to determine the column types. Set this property to the username of the database owner in the case required by your database for object identifiers.

state

The current state of the SimpleSQLFormHandler component, expressed by one of the following integer/constants:

1 / STATE_NOTSET
The bean does not represent a valid item in the table. Any attempt to get properties of the value returns only the properties explicitly set.

2 / STATE_INVALID
The key properties are set, but no record was found for a lookup, update, or delete.

3 / STATE_VALID
Values for the key properties are set and a query has successfully returned one or more items.

4 / STATE_CONFIG_ERROR
A database operation failed due to a configuration error: a lookup, update, or delete operation failed because one of the specified key properties is not set; or an update operation failed because no key properties are defined or a value for a specified column property is missing.

5 / STATE_DB_ERROR
A database error occurred.

tableName

Database table used for this form handler.

tablePrefix

String that can be prepended to the tableName value. If the active database user does not own the table where log entries are saved, this property constructs a qualified table name. This property is not used during the initial metadata query, but if present is prepended to the table name when inserts or updates are made.

valid

Indicates whether or not the last operation succeeded.

value

Dictionary that stores the values of the current row. These values are split into two groups: those in the keyColumns list, and those in the columns list. keyColumns properties are used to look up the row for lookup, update, and delete operations. columns properties specify the columns that are the targets of lookup, update and insert operations.