CICSJDBCWriter

The CICSJDBCWriter data stream is used to write data to a database using a Java™ Database Connectivity (JDBC) connection.

Note: You must use the CICSJDBCWriter class that is provided with this feature pack. The JDBCWriter class that is provided by WebSphere® Application Server is not supported.

Required properties

Table 1. Required properties
Property	Description
IMPLCLASS	Class implementing JDBCWriterPattern

Optional properties

Table 2. Optional properties
Property	Value
debug	true or false (default is false)	Enables detailed tracing on this batch data stream.
EnablePerformanceMeasurement	true or false (default is false)	Calculates the total time that is spent in the batch data-streams and the processRecord method, if you are using the GenericXDBatchStep.
EnabledDetailedPerformanceMeasurement	true or false (default is false)	Provides a more detailed breakdown of time that is spent in each method of the batch data-streams.
batch_interval	Default value is 20. Make the value less than the checkpoint interval for record-based checkpointing.	The number of SQL updates made to batch before you commit the changes.

xJCL example

            <bds>
                <logical-name>outputStream</logical-name>
                <props>
                    <prop name="IMPLCLASS"
                        value="com.ibm.websphere.batch.samples.tests.bds.EchoWriter" />
                    <prop name="batch_interval" value="2" />
                    <prop name="EnablePerformanceMeasurement" value="${enablePerf}" />
                    <prop name="debug" value="${debugEnabled}" />
                </props>
                <impl-class>com.ibm.cics.batch.bds.patterns.CICSJDBCWriter</impl-class>
            </bds>

For more information, see JDBCWriterPattern in the WebSphere Application Server product documentation.