Configuration
Element | Type | Default | Description |
---|---|---|---|
rdbLocation | String | rdb | The component path within the system of the RDB connection pool component. Used for fetching database connections. |
output | String | None | The name of the element in the AspireObject to write the data. |
output/@row | String | None | Turn on Multiple Row mode and use the given element name as the sub element for a row. |
output/@rowDelim | String | None | Turn on Compress Multiple Row mode and use the the given character as the delimiter. |
extract | None | The SQL to run to extract data. See below. | |
extract/sql | String | None | The SQL to be run to extract data. The SQL may include ? as place holders for parameters. These will then be substituted in in order. |
extract/param/@index | Integer | None | The parameter number of this parameter, with parameter one replacing the first ? in the SQL, parameter two replacing the second ? in the SQL etc. |
extract/param/@type | String | Integer | The type of this parameter - either String or Integer. |
extract/param/@docPath | String | None | The xpath in the AspireObject to the element that holds the value for this parameter. |
Example Configurations
Simple Configuration
<component name="EM3getPGTitles" subType="rdbRowExtractor" factoryName="aspire-rdbfeeder"> <rdbLocation>/common/EM3rdb</rdbLocation> <output row="pgTitle">pgTitles</output> <extract> <param index="1" type="Integer" docPath="/doc/PG_ID"/> <sql><![CDATA[ select pgt.title as TITLE, tt.name as TITLE_TYPE from em3.product_group_title pgt, em3.title_type tt where pgt.product_group_id = ? and pgt.title_type_id = tt.id ]]></sql> </extract> </component>
Overview
Content Tools