Real Time Information Director User Documentation

RTID Message Format and Programmatic Interfaces

Hewlett-Packard Company 7 529618 - 002

The guiding principle in all these cases is that where the input specifies a value (even if it

consists of spaces), the Director inserts that value. Where the input does not specify a

value (where the element is absent or empty), the Director uses a default value in the case

of an insert and retains the value in the data store in the case of an update. The next

several paragraphs show how this principle applies, case by case.

An element included in the document definition is not present in the input document.

If the document is an insert and the element has a default value, that value is inserted into

the data store. If no default exists, a null is inserted. If the column cannot have a null

value, the Director inserts a default value of space for a character element, 0 for a

numeric element, or 1999-12-31 for a date.

If the document is an update, the previous value of the field is retained in the database

record.

The value part of the element consists of white space(s).

If the document is an insert, the white space or spaces are treated as a valid value and

inserted into the data store.

If the document is an update, white spaces are trimmed. The element is set to a blank

string, which translates to spaces for a character field. A blank date field causes an

InvalidInputException.

The element is empty. That is, it has no value.

Whether the document is an insert or an update, if the element has a default value, that

value is inserted into the data store. If no default exists, a null is inserted. If the column

cannot have a null value, the Director inserts a default value of space for a character

element, 0 for a numeric element, or 1999-12-31 for a date.

Director Exceptions

If a request to the Director cannot be completed successfully, the output document will be

an error response document. This XML document indicates the exception class and

includes text describing the error that occurred. In the case of an SQL exception, the

response also includes the SQL state and error code, as in the following error response to

a request with invalid input:

<?xml version="1.0" encoding="ISO-8859-1" ?>

<NAME>class com.hp.rtid.exception.InvalidInputException</NAME>

<TEXT>Error inserting into SLS_ORD_EVENT

</TEXT>

<NAME>class java.sql.SQLException</NAME>

<TEXT>String data right-truncated </TEXT>