Adapter type: jms_xml_in. The JMS XML Input adapter subscribes to XML-formatted text messages from a JMS queue or topic, and writes the messages as stream records.
Ensure that each message consists of an XML element. If opted, the element name corresponds to the stream name.
If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.
< StreamOut ESP_OPS="u" stringCol="aaa" int32Col="22" int64Col="222" doubleCol="2.200000" dateCol="2008-03-13T08:19:30" moneyCol="222.2222" timestampCol="2008-03-13T08:19:30.123" booleanCol="true" binaryCol="FF00FE05FF" bigdatetimeCol="2008-03-13T08:19:30.123456" intervalCol="64000" money1Col="922.0" money15Col="337.000000000000000" />
<RecordType name="StreamIn_rec"> <Column datatype="string" key="true" name="stringCol" /> <Column datatype="integer" key="false" name="int32Col" /> <Column datatype="long" key="false" name="int64Col" /> <Column datatype="float" key="false" name="doubleCol" /> <Column datatype="date" key="false" name="dateCol" /> <Column datatype="money" key="false" name="moneyCol" /> <Column datatype="timestamp" key="false" name="timestampCol" /> <Column datatype="boolean" key="false" name="booleanCol" /> <Column datatype="binary" key="false" name="binaryCol" /> <Column datatype="bigdatetime" key="false" name="bigdatetimeCol" /> <Column datatype="interval" key="false" name="intervalCol" /> <Column datatype="money(1)" key="false" name="money1Col" /> <Column datatype="money(15)" key="false" name="money15Col" /> </RecordType>
The ESP-OPS attribute is optional. If omitted, the message is interpreted as an upsert. Ensure that the rest of the attributes have the same names as the corresponding stream columns, and that the columns with null values are omitted. This adapter supports schema discovery.
| Property Label | Description |
|---|---|
| Connection Factory |
Property ID: connectionFactory Type: string (Required) Connection factory class name. No default value. |
| JNDI Context Factory | Property ID: jndiContextFactory Type: string (Required) Context Factory for JNDI context initialization. No default value . |
| JNDI URL | Property ID: jndiURL Type: string (Required) JNDI URL. No default value . |
| Destination Type |
Property ID: destinationType Type: choice (Required) Destination type. Valid values are:
|
| Destination Name |
Property ID: destinationName Type: string (Required) Destination name. No default value. |
|
Subscription Mode |
Property ID: subscriptionMode Type: choice (Optional) Specifies the subscription mode for TOPIC. Default value is NONDURABLE. Valid values are DURABLE and NONDURABLE. |
|
Client ID |
Property ID: clientID Type: string (Optional) Specifies the client identifier for the connection that is identifying durable subscription. No default value. |
|
Subscription Name |
Property ID: subscriptionName Type: string (Optional) Specifies a unique name identifying a durable subscription. No default value. |
|
Batch Size |
Property ID: batchsize Type:uint (Optional) Specifies number of records in a batch to commit in durable subscription mode. Default value is 1. |
|
PropertySet |
Property ID: propertyset Type: string (Advanced) Specifies the name of the property set from the project configuration file. If you specify the same properties in the project configuration file and the ATTACH ADAPTER statement, the values in the property set override the values defined in the ATTACH ADAPTER statement. No default value. |
| Match Stream Name |
Property ID: matchStreamName Type: boolean (Advanced) Ignore message if the XML element name does not match the source stream name. Default value is false. |
| Date Format |
Property ID: dateFormat Type: string (Advanced) Date format. Default value is YYYY-MM-DDTHH:MM:SS.SSS. |
| Timestamp Format | Property ID: timestampFormat Type: string (Advanced) Timestamp format. Default value is YYYY-MM-DDTHH:MM:SS.SSS. |
Known limitations: