JMS XML Input Adapter

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.

Sample record format for the data file:
< 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" />
The stream contains these columns:
  • stringCol
  • int32Col
  • int64Col
  • doubleCol
  • dateCol
  • moneyCol
  • timestampCol
  • booleanCol
  • binaryCol
  • bigdatetimeCol
  • intervalCol
  • money1Col
  • money15Col
<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 Property ID Type Description
Connection Factory connectionFactory string (Required) Connection factory class name. No default value.
JNDI Context Factory jndiContextFactory string (Required) Context Factory for JNDI context initialization. No default value.
JNDI URL jndiURL string (Required) JNDI URL. No default value.
Destination Type destinationType choice (Required) Destination type.
Valid values are:
  • QUEUE
  • TOPIC
Default value is QUEUE.
Destination Name destinationName string (Required) Destination name. No default value.

Subscription Mode

subscriptionMode choice

(Optional) Specifies the subscription mode for TOPIC. Default value is NONDURABLE. Valid values are DURABLE and NONDURABLE.

Client ID

clientID string

(Optional) Specifies the client identifier for the connection that is identifying durable subscription. No default value.

Subscription Name

subscriptionName string

(Optional) Specifies a unique name identifying a durable subscription. No default value.

Batch Size

batchsize uint

(Optional) Specifies number of records in a batch to commit in durable subscription mode. Default value is 1.

PropertySet

propertyset 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 matchStreamName boolean (Advanced) Ignore message if the XML element name does not match the source stream name. Default value is false.
Date Format dateFormat string (Advanced) Date format. Default value is YYYY-MM-DDTHH:MM:SS.SSS.
Timestamp Format timestampFormat string (Advanced) Timestamp format. Default value is YYYY-MM-DDTHH:MM:SS.SSS.

Known limitations:

Related concepts
Guaranteed Delivery
Related reference
Adapter Support for Schema Discovery