You forgot the Null serializer that reads the data from the output of the SQL processor in the initial example:
<p:processor uri="oxf/processor/null-serializer">
<p:input name="data" href="#dummy"/>
</p:processor>You must also change the output of the SQL processor to declare an id:
<p:output name="data" id="dummy" debug="my-sql-result"/>
-Erik
Tony Tay wrote:
> hi Erik,
>
> Thanks for solving the debugging log issues. Now i can see the
> outputs to a local file. I have another question.
>
> i received this error message when i ran the following populate.xpl
> (see below). I replaced orbeon's example populate.xpl with my own
> sql selects. I just want to get some data from Oracle database and
> display it using populate.xpl for testing my connection to database.
>
> ==== Error message ====
>
> org.orbeon.oxf.common.ValidationException: oxf:/sql/populate.xpl, line 36, column 59 : Reference to undeclared output parameter id "data" : oxf:/sql/populate.xpl, line 36, column 59: Reference to undeclared output parameter id "data"
> at org.orbeon.oxf.processor.pipeline.PipelineBlock.connectProcessorToBottomInput(PipelineBlock.java:205)
>
> ===== end of error message =========
>
> <p:config xmlns:p="http://www.orbeon.com/oxf/pipeline";
> xmlns:sql="http://orbeon.org/oxf/xml/sql";>
>
> <p:processor uri="oxf/processor/sql">
> <p:input name="data"><dummy/></p:input>
> <p:input name="config">
> <sql:config xmlns:sql="http://orbeon.org/oxf/xml/sql";>
> <auctions>
> <sql:connection>
> <sql:datasource>db</sql:datasource>
> <sql:execute>
> <sql:query>
> select * from friends
> </sql:query>
> <sql:results>
> <sql:row-results>
> <row>
> <sql:get-columns format="xml"/>
> </row>
> </sql:row-results>
> </sql:results>
> </sql:execute>
> </sql:connection>
> </auctions>
> </sql:config>
> </p:input>
> <p:output name="data" ref="data" debug="my-sql-result"/>
> </p:processor>
> </p:config>
>
>
> Regards,
> Tony
_______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
