<p:config xmlns:p="http://www.orbeon.com/oxf/pipeline"
          xmlns:oxf="http://www.orbeon.com/oxf/processors"
          xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
          xmlns:sql="http://orbeon.org/oxf/xml/sql">


    
      <!-- rechercher un utilisateur avec le login et le password saisis -->
    <p:param name="instance" type="input"/>
    <p:param name="data" type="output"/>
    <p:processor name="oxf:sql">
          <p:input name="data" href="#instance" />
        <p:input name="datasource" href="oxf:/FormationOrbeon/TestMigration/Datasource/datasource.xml" />
          <p:input name="config">
               <sql:config>
                  <sql:connection>
                      <personnes>
                          <sql:execute>
                             <sql:query>
                                 SELECT * FROM users.user u, users.informations f where f.id_informations=u.id;
                             </sql:query>
                     
                          <sql:results>
                             <sql:row-results>
                                <personne>
                                    <sql:get-columns format="xml" />
                                </personne>
                             </sql:row-results>
                             </sql:results> 
                    
                           </sql:execute>
                          </personnes>  
                          
                  </sql:connection>
              </sql:config>

          </p:input>
        <p:output name="data" ref="data" />
     </p:processor>
    
    
    
   
    

</p:config>
