Menu
▾
▴
Re: [Babeldoc-devel] Database Tables
|
From: <ek...@ba...> - 2003-03-28 20:32:45
|
I'm sorry I seem so dense on this matter, but I need to understand how to configure this. I will have two stages to do an XMLTransformation. 1. SQLEnrich 2. XslTransform I will need to do the SQLEnrich to get the Xsl logic, which will then be fed into the XslTranform step, right? SqlEnrich Enrich documents with values based on sql queries |------------+------------+-------> | Name | Type | number| |------------+------------+-------> >----------------------------------------------------------------------------------------------------------------------| | description | >----------------------------------------------------------------------------------------------------------------------| |------------+------------+-------> | sqlScript | string | 0..1 | |------------+------------+-------> >----------------------------------------------------------------------------------------------------------------------| | Error getting the resource | >----------------------------------------------------------------------------------------------------------------------| |------------+------------+-------> | ignored | boolean | 0..1 | |------------+------------+-------> >----------------------------------------------------------------------------------------------------------------------| | Is this stage ignored | >----------------------------------------------------------------------------------------------------------------------| |------------+------------+-------> | stageType | service-nam| 1..n | | | e | | |------------+------------+-------> >----------------------------------------------------------------------------------------------------------------------| | Type of pipeline stage | >----------------------------------------------------------------------------------------------------------------------| |------------+------------+-------> | tracked | boolean | 0..1 | |------------+------------+-------> >----------------------------------------------------------------------------------------------------------------------| | Is this stage tracked | >----------------------------------------------------------------------------------------------------------------------| |------------+------------+-------> | attributeSq| complex | 0..1 | | l | | | |------------+------------+-------> >----------------------------------------------------------------------------------------------------------------------| | List of scripts that can return multiple columns (but single row). An atttribute will get created for each column. | | The name of the attribute will be the same as the column name and the value will be the column value | >----------------------------------------------------------------------------------------------------------------------| |------------+------------+-------> | nextStage | string | 1..n | |------------+------------+-------> >----------------------------------------------------------------------------------------------------------------------| | Type of scanner | >----------------------------------------------------------------------------------------------------------------------| |------------+------------+-------> | resourceNam| string | 0..1 | | e | | | |------------+------------+-------> >----------------------------------------------------------------------------------------------------------------------| | Name of the resource that contains Database Connection | >----------------------------------------------------------------------------------------------------------------------| Is "sqlScript" a SELECT statement in this case? What goes in "attributeSql"? Is this Stage capable of reading a Long VarChar / CLOB? Can "resourceName" be pointed to a Weblogic Database Connection Pool? XslTransform Transform the document using XSL |------------------+--------------+-------+------------------------------------| | Name | Type | number| description | |------------------+--------------+-------+------------------------------------| | ignored | boolean | 0..1 | Is this stage ignored | |------------------+--------------+-------+------------------------------------| | stageType | service-name | 1..n | Type of pipeline stage | |------------------+--------------+-------+------------------------------------| | bufferSize | integer | 0..1 | The buffer size to use | |------------------+--------------+-------+------------------------------------| | tracked | boolean | 0..1 | Is this stage tracked | |------------------+--------------+-------+------------------------------------| | transformationFil| directory-pat| 1..n | The name of the XSL to convert the | | e | h | | document | |------------------+--------------+-------+------------------------------------| | nextStage | string | 1..n | Type of scanner | |------------------+--------------+-------+------------------------------------| So, this is where I would use "transformationScript"? What value do I give it, the value given in "attributeSql" for the SqlEnrich Stage? Also, "transformationFile" becomes a 0..n, right? << I would prefer it not to change the sql configuration tables. We can do everything you need with the SqlEnrichPipelineStage selecting the XSL data from another table of your choice, placing that data in an attribute and then getting that data using the new configuration parameter. >> |
