If referencing an external relational database from the complex event processing rules using RDB collaboration, consider the following points:
Notes on using multibyte characters
Multibyte characters cannot be used for definition names in a relational database such as table names and table item names to be referenced from the complex event processing language. The same applies to other names such as database names, schema names, and user names specified in an RDB reference definition.
Multibyte characters can be used for item values. In this case, set unicode as the character encoding (or character set) of the relational database. Refer to the manual for the collaboration destination RDB for details.
Characters and maximum length of user names (or access IDs in an RDB reference definition)
Depending on the type of relational database to be used, there may be restrictions on user names (access IDs).
For example, if using Symfoware Server with the native interface, specify the user name (access ID) to be set when connecting from the CEP Server in up to 36 alphanumeric characters starting with an alphabetic character. You cannot use a period (.) or multibyte characters.
Similarly, there are restrictions on the characters and length of database names, schema names, database URLs, and access passwords. Refer to "9.2.4 RDB Reference Definition File" for information on the characters and length of each item.
Format of relational database tables
The tables of the relational database to be used must conform to the prescribed format.
If using an existing relational database, ensure that it matches "5.5.4.1 Supported RDB Table Formats".
Initial data of a relational database
If preparing a new relational database, you must prepare initial data.
You need not prepare initial data if using an existing relational database.
The format of initial data must conform to the specifications for the RDB commands to be used for storing data. Refer to the manual for the collaboration destination RDB for details.
Enter the table names and table item names of the relational database in an alphanumeric string containing up to 36 characters and starting with an alphabetic character.
The table below lists the types that can be used in each item of a relational database table. Refer to the manual for the collaboration destination RDB for information on each type.
CHAR | VARCHAR | NCHAR | NCHAR VARYING |
NUMERIC | DECIMAL | INTEGER | SMALLINT |
FLOAT | REAL | DOUBLE PRECISION | DATE |
TIME | TIMESTAMP | BLOB |
Note
Multibyte characters cannot be used for definition names in a relational database such as table names and table item names to be referenced from the complex event processing language. Multibyte characters can be used for item values.
