Wes,
Matt is correct. XPL follows a lazy evaluation execution model. If a processor has one output and nobody is reading it, the processor won't run at all.
You have the following solutions:
1. Read the output ;-)
2. Force the output to be read, for example by connecting it to an oxf:null-serializer.
I hope this helps,
-Erik
Wes Smoak wrote:
I am trying to tie together a series of SQL processors that are processing a query then an update and using Xupdate to update the instance with the key from the query and the status of the insert.
If on the XUpdate processor, I set the input named 'data' to the instance and 2 additional inputs to be the outputs of the SQL processors, the SQL processors are not executing according to the debug events within the Studio.
If I change the 'data' input to the output of the first SQL processor and 'newKey' to the instance The first SQL processor executes and returns a valid key. But now the output of my processor is only the key and not the updated instance with the key.
<p:otherwise> <p:processor name="oxf:sql"> <p:input name="data" href="#instance" /> <p:input name="config"> <sql:config> <sql:connection> <sql:datasource> DB</sql:datasource> <sql:execute> <sql:query> .... </sql:query> <sql:results> <sql:row-results> <info> <key> <sql:get-column type= "xs:string" column="Key"/> </key> </info> </sql:row-results> </sql:results> </sql:execute> </sql:connection> </sql:config> </p:input> <p:output name="data" id="newKey"/> </p:processor>
<p:processor name="oxf:sql"> <p:input name="data" href="#newKey"/> <p:input name="config"> <sql:config> <sql:connection> <sql:datasource> DB</sql:datasource> <sql:execute> <sql:update> .... </sql:update> </sql:execute> <status>Inserted new</status> </sql:connection> </sql:config> </p:input> <p:output name="data" id="insertOutput" /> </p:processor>
<p:processor name="oxf:xupdate" xmlns:p="http://www.orbeon.com/oxf/pipeline";> <p:input name="config"> ... </p:input>
<p:input name="data" href="#instance"/> <p:input name="newKey" href="#newKey"/> <p:input name="insertStatus" href="#insertOutput"/>
<p:output name="data" ref="data" debug= "instanceWithKeyAndStatus"/> </p:processor> </p:otherwise>
Thanks
Wes Smoak Computer Scientist Exceed Development CSC 803 333 6025
----------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ----------------------------------------------------------------------------------------
------------------------------------------------------- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 _______________________________________________ orbeon-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/orbeon-user
------------------------------------------------------- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 _______________________________________________ orbeon-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/orbeon-user
