JMS CSV Input Adapter

Adapter type: jms_csv_in. The JMS CSV Input adapter subscribes to text messages formatted as a delimited list of values, and writes them as stream records.

If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.

When the delimiter is set to a comma (,) and the expectStreamNameOpcode is set to true, the JMS CSV Input adapter expects the input stream to be formatted as:

aaa,11,111,1.100000,2008-03-13T08:19:30,111.1111,2008-03-13T08:19:30.123,false,FF00FE05FF,2008-03-13T08:19:30.123456,64000,922.0,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>

Property Label	Description
Delimiter	Property ID: delimiter Type: `string` (Required for adapter operation and schema discovery) Field delimiter. Default value is a comma (,).
Connection Factory	Property ID: connectionFactory Type: `string` (Required for adapter operation and schema discovery) Connection factory class name. Consult your third-party vendor documentation for specific formats. Here are some examples: ActiveMQ – ConnectionFactory TIBCO – QueueConnectionFactory WebSphere MQ – MyMQConnFactory No default value.
JNDI Context Factory	Property ID: jndiContextFactory Type: `string` (Required for adapter operation and schema discovery) Context factory for JNDI context initialization. Consult your third-party vendor documentation for specific formats. Here are some examples: ActiveMQ – org.apache.activemq.jndi.ActiveMQInitialContextFactory TIBCO – com.tibco.tibjms.naming.TibjmsInitialContextFactory WebSphere MQ – com.sun.jndi.fscontext.RefFSContextFactory No default value.
JNDI URL	Property ID: jndiURL Type: `string` (Required for adapter operation and schema discovery) JNDI URL. Consult your third-party vendor documentation for specific formats. Here are some examples: ActiveMQ – tcp://server:61616 TIBCO – tibjmsnaming://server:7222 WebSphere MQ – file:/var/mqm/jndi/ WebSphere MQ is different as it requires a separate naming server to be configured with it. By default, WebSphere MQ only provides a file-based naming server. No default value.
Destination Type	Property ID: destinationType Type: `choice` (Required for adapter operation and schema discovery) Destination type. Valid values are: QUEUE TOPIC Default value is QUEUE.
Destination Name	Property ID: destinationName Type: `string` (Required for adapter operation and schema discovery) 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 a JMS client. Required for creating a 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.
Stream Name Opcode Expected	Property ID: expectStreamNameOpcode Type: `boolean` (Advanced) If true, the first two fields in CSV records are interpreted as stream name, and opcode. An empty string is a valid value. 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.
PropertySet	Property ID: propertyset Type: `string` (Advanced) Specifies the name of the property set. Property sets are reusable sets of properties that are stored in the project configuration file. Using these sets allows you to move adapter configuration properties out of the CCL file and into the CCR 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.

Known limitations:

If the connection to the message broker is lost, the adapter does not attempt to reconnect.