<sql:result-set> is not allowed

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

<sql:result-set> is not allowed

sj.sjain
hi,

i have xpl file

<!--
    Copyright (C) 2004 Orbeon, Inc.
 
    This program is free software; you can redistribute it and/or modify it under the terms of the
    GNU Lesser General Public License as published by the Free Software Foundation; either version
    2.1 of the License, or (at your option) any later version.
 
    This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
    without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
    See the GNU Lesser General Public License for more details.
 
    The full text of the license is available at http://www.gnu.org/copyleft/lesser.html
-->
<p:config xmlns:p="http://www.orbeon.com/oxf/pipeline"
          xmlns:sql="http://orbeon.org/oxf/xml/sql"
          xmlns:xs="http://www.w3.org/2001/XMLSchema"
          xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
          xmlns:oxf="http://www.orbeon.com/oxf/processors">

    <p:param type="input" name="instance"/>
    <p:param type="output" name="data"/>

    <!-- Make sure database is initialized with the tables and data we are using -->
    <p:processor name="oxf:pipeline">
        <p:input name="config" href="initialization/init-database.xpl"/>
    </p:processor>
   
    <p:processor name="oxf:sql">
        <p:input name="data" href="#instance"/>
        <p:input name="datasource" href="/datasource-sql.xml"/>
        <p:input name="config">
            <sql:config>
                <MasterIds>
                   
                        <sql:connection>
                       
                            <sql:execute>
                                <sql:query>
                                   select * from Report
                                    </sql:query>  
                               

                                 <sql:result-set>
                                <sql:row-iterator>
                                    <masteriddetails>
                                        <id>
                                            <sql:get-column-value type="xs:int" column="id"/>
                                        </id>
                                  <requestid>
                                            <sql:get-column-value type="xs:string" column="requestid"/>
                                        </requestid>
                                       
                                        </masteriddetails>
                                </sql:row-iterator>
                            </sql:result-set>

                             
                            </sql:execute>
                          </sql:connection>
                                   
                    </MasterIds>
            </sql:config>
        </p:input>
        <p:output name="data" ref="data"/>
    </p:processor>

</p:config>


in this i am getting error:

Type class org.orbeon.oxf.common.ValidationException

Message oxf:/model.xpl, line 41, column 49 : Error tag name "sql:result-set" is not allowed. Possible tag names are: <copy-of>,<no-results>,<results>,<value-of>(schema: http://orbeon.org/oxf/xml/sql) : oxf:/model.xpl, line 41, column 49: Error tag name "sql:result-set" is not allowed. Possible tag names are: <copy-of>,<no-results>,<results>,<value-of>(schema: http://orbeon.org/oxf/xml/sql)
Location oxf:/model.xpl



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: <sql:result-set> is not allowed

Erik Bruchez
Administrator
This is really surprising, since it is exactly the same code that is
running for the Address Book example! You wouldn't have an OPS 2.8 JAR
file around, wouldn't you?

-Erik

[hidden email] wrote:

> hi,
>
> i have xpl file
>
> <!--
>     Copyright (C) 2004 Orbeon, Inc.
>  
>     This program is free software; you can redistribute it and/or modify it under the terms of the
>     GNU Lesser General Public License as published by the Free Software Foundation; either version
>     2.1 of the License, or (at your option) any later version.
>  
>     This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
>     without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
>     See the GNU Lesser General Public License for more details.
>  
>     The full text of the license is available at http://www.gnu.org/copyleft/lesser.html
> -->
> <p:config xmlns:p="http://www.orbeon.com/oxf/pipeline"
>           xmlns:sql="http://orbeon.org/oxf/xml/sql"
>           xmlns:xs="http://www.w3.org/2001/XMLSchema"
>           xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
>           xmlns:oxf="http://www.orbeon.com/oxf/processors">
>
>     <p:param type="input" name="instance"/>
>     <p:param type="output" name="data"/>
>
>     <!-- Make sure database is initialized with the tables and data we are using -->
>     <p:processor name="oxf:pipeline">
>         <p:input name="config" href="initialization/init-database.xpl"/>
>     </p:processor>
>    
>     <p:processor name="oxf:sql">
>         <p:input name="data" href="#instance"/>
>         <p:input name="datasource" href="/datasource-sql.xml"/>
>         <p:input name="config">
>             <sql:config>
>                 <MasterIds>
>                    
>                         <sql:connection>
>                        
>                             <sql:execute>
>                                 <sql:query>
>                                    select * from Report
>                                     </sql:query>  
>                                
>
> <sql:result-set>
>                                 <sql:row-iterator>
>                                     <masteriddetails>
>                                         <id>
>                                             <sql:get-column-value type="xs:int" column="id"/>
>                                         </id>
>                                   <requestid>
>                                             <sql:get-column-value type="xs:string" column="requestid"/>
>                                         </requestid>
>                                        
>                                         </masteriddetails>
>                                 </sql:row-iterator>
>                             </sql:result-set>
>
>                              
>                             </sql:execute>
>                           </sql:connection>
>                                    
>                     </MasterIds>
>             </sql:config>
>         </p:input>
>         <p:output name="data" ref="data"/>
>     </p:processor>
>
> </p:config>
>
>
> in this i am getting error:
>
> Type class org.orbeon.oxf.common.ValidationException
>
> Message oxf:/model.xpl, line 41, column 49 : Error tag name "sql:result-set" is not allowed. Possible tag names are: <copy-of>,<no-results>,<results>,<value-of>(schema: http://orbeon.org/oxf/xml/sql) : oxf:/model.xpl, line 41, column 49: Error tag name "sql:result-set" is not allowed. Possible tag names are: <copy-of>,<no-results>,<results>,<value-of>(schema: http://orbeon.org/oxf/xml/sql)
> Location oxf:/model.xpl
--
Orbeon - XForms Everywhere:
http://www.orbeon.com/blog/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws