cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carlos Maté <cm...@tid.es>
Subject Re: ESQL QUERY
Date Fri, 12 Jul 2002 08:33:50 GMT
This is what I can see in core.log


DEBUG   (2002-07-12) 09:25.27:272   [core] (/sg/perfil:administradorn/NuevoMotivosSolicitud)
Thread-197/XIncludeTransformer: Parse type is XML
DEBUG   (2002-07-12) 09:25.27:273   [core] (/sg/perfil:administradorn/NuevoMotivosSolicitud)
Thread-197/LogKitLogger: Retrieving a org.apache.cocoon.components.parser.JaxpParser from
the pool
DEBUG   (2002-07-12) 09:25.27:274   [core] (/sg/perfil:administradorn/NuevoMotivosSolicitud)
Thread-197/LogKitLogger: Returning a org.apache.cocoon.components.parser.JaxpParser to the
pool
DEBUG   (2002-07-12) 09:25.27:275   [core.datasources.sga_db] (/sg/perfil:administradorn/NuevoMotivosSolicitud)
Thread-197/LogKitLogger: Retrieving a org.apache.avalon.excalibur.datasource.JdbcConnection
from the pool
DEBUG   (2002-07-12) 09:25.27:276   [core.datasources.sga_db] (/sg/perfil:administradorn/NuevoMotivosSolicitud)
Thread-197/LogKitLogger: Pinging database after 243551ms of inactivity.
DEBUG   (2002-07-12) 09:25.27:279   [core] (/sg/perfil:administradorn/NuevoMotivosSolicitud)
Thread-197/FrmMotivosSolicitud_xsp: esql query:
          INSERT INTO SGMOSOTO
             SELECT SG_SQ_CO_MOTIVO_SOLI.NEXTVAL, 'PROBANDO'
                FROM DUAL WHERE NOT EXISTS (SELECT null FROM SGMOSOTO WHERE
                                      MOSO_DS_MOTIVO_SOLICITUD = 'PROBANDO')

DEBUG   (2002-07-12) 09:25.27:283   [core] (/sg/perfil:administradorn/NuevoMotivosSolicitud)
Thread-197/FrmMotivosSolicitud_xsp: esql query:
                SELECT      MOSO_CO_MOTIVO_SOLICITUD,
                            MOSO_DS_MOTIVO_SOLICITUD
                FROM        SGMOSOTO

DEBUG   (2002-07-12) 09:25.27:284   [core] (/sg/perfil:administradorn/NuevoMotivosSolicitud)
Thread-196/FrmMotivosSolicitud_xsp: esql query:
          INSERT INTO SGMOSOTO
             SELECT SG_SQ_CO_MOTIVO_SOLI.NEXTVAL, 'PROBANDO'
                FROM DUAL WHERE NOT EXISTS (SELECT null FROM SGMOSOTO WHERE
                                      MOSO_DS_MOTIVO_SOLICITUD = 'PROBANDO')

DEBUG   (2002-07-12) 09:25.27:292   [core] (/sg/perfil:administradorn/NuevoMotivosSolicitud)
Thread-196/FrmMotivosSolicitud_xsp: esql query:
                SELECT      MOSO_CO_MOTIVO_SOLICITUD,
                            MOSO_DS_MOTIVO_SOLICITUD
                FROM        SGMOSOTO

DEBUG   (2002-07-12) 09:25.27:357   [core.datasources.sga_db] (/sg/perfil:administradorn/NuevoMotivosSolicitud)
Thread-196/LogKitLogger: Returning a org.apache.avalon.excalibur.datasource.JdbcConnection
to the pool
DEBUG   (2002-07-12) 09:25.27:358   [core.datasources.sga_db] (/sg/perfil:administradorn/NuevoMotivosSolicitud)
Thread-197/LogKitLogger: Returning a org.apache.avalon.excalibur.datasource.JdbcConnection
to the pool


The xsp page NuevoMotivoSolicitud:

<xsp:page xmlns:xi="http://www.w3.org/2001/XInclude"  xmlns:error="http://apache.org/cocoon/error/2.0"
     language="java"
     xmlns:xsp="http://apache.org/xsp"
     xmlns:esql="http://apache.org/cocoon/SQL/v2"
     xmlns:xsp-request="http://apache.org/xsp/request/2.0"
     xmlns:xsp-formval="http://apache.org/xsp/form-validator/2.0"
     xmlns:session="http://apache.org/xsp/session/2.0"
>
 <SGA_APLICACION sga_id="frm_motivos_solicitud" sga_titulo="Configuraci@CTE_ACENTO_O@n
de Motivos de Solicitud">
<xsp:logic>
String eliminar                 = <xsp-request:get-parameter name="ELIMINAR"/>;
String nuevo                    = <xsp-request:get-parameter name="NUEVO"/>;
String nuevaDescripcion         = <xsp-request:get-parameter name="INPUT_AREA_DESCRIPCION"/>;
if (nuevaDescripcion != null)
{
  nuevaDescripcion = nuevaDescripcion.toUpperCase();
}
String motivo                   = <xsp-request:get-parameter name="SELECT_MOTIVO"/>;
</xsp:logic>
<esql:connection>
  <esql:pool>sga_db</esql:pool>


  if (nuevo!=null)
  {
    <![CDATA[if  ( (nuevo.equals("si"))
                   && (nuevaDescripcion!=null)
                   && (nuevaDescripcion.length() !=0)
                   && (nuevaDescripcion.length() < @CTE_MAX_MOSO_DS_MOTIVO_SOLICITUD@)
)]]>
    {
  </xsp:logic>
        <esql:execute-query>
          <esql:query>
          INSERT INTO SGMOSOTO
             SELECT SG_SQ_CO_MOTIVO_SOLI.NEXTVAL, '<xsp:expr>nuevaDescripcion</xsp:expr>'
                FROM DUAL WHERE NOT EXISTS (SELECT null FROM SGMOSOTO WHERE
                                      MOSO_DS_MOTIVO_SOLICITUD = '<xsp:expr>nuevaDescripcion</xsp:expr>')
          </esql:query>
          <esql:results>
            <esql:row-results>
            </esql:row-results>
          </esql:results>
          <esql:no-results>
          </esql:no-results>
        </esql:execute-query>
  <xsp:logic>
    }
  }
  </xsp:logic>

  <SGA_FORMULARIO sga_alias="FrmMotivosSolicitud" sga_titulo="Motivos de las solicitudes">
    <SGA_FILA>
      <SGA_SELECT_CONSULTA sga_nombre="SELECT_MOTIVO" sga_titulo="Motivo">
        <SGA_OPCIONES_A_BUSCAR>
          <SGA_ModeloDatos_dameCodHor>
            <esql:execute-query>
              <esql:query>
                SELECT      MOSO_CO_MOTIVO_SOLICITUD,
                            MOSO_DS_MOTIVO_SOLICITUD
                FROM        SGMOSOTO
              </esql:query>
              <esql:results>
                <esql:row-results>
                  <ROW>
                    <xsp:attribute name="ID"><xsp:expr><esql:get-int column="MOSO_CO_MOTIVO_SOLICITUD"/></xsp:expr></xsp:attribute>
                    <MOSO_DS_MOTICO_SOLICITUD><esql:get-string column="MOSO_DS_MOTIVO_SOLICITUD"/></MOSO_DS_MOTICO_SOLICITUD>
                  </ROW>
                </esql:row-results>
              </esql:results>
            </esql:execute-query>
          </SGA_ModeloDatos_dameCodHor>
        </SGA_OPCIONES_A_BUSCAR>
        <xsp:logic>
         <![CDATA[if ( (eliminar!=null) && (eliminar.equals("si")) && (
(motivo==null) || (motivo.length()==0) )){]]>
         </xsp:logic>
         <SGA_AVISO>Seleccione un Motivo de Solicitud</SGA_AVISO>
         <xsp:logic>
         }
         </xsp:logic>

      </SGA_SELECT_CONSULTA>
    </SGA_FILA>
    <SGA_FILA>
      <SGA_INPUT_OCULTO sga_nombre="ELIMINAR" sga_valor=""/>
    </SGA_FILA>
    <SGA_BOTONES>
      <SGA_BOTON sga_nombre="Nuevo" sga_tipo="submit" sga_script="FrmNuevoMotivosSolicitud"/>
      <SGA_BOTON sga_nombre="Eliminar" sga_tipo="button" sga_script="eliminar"/>
    </SGA_BOTONES>
  </SGA_FORMULARIO>
</esql:connection>
</SGA_APLICACION>
</xsp:page>

And in the sitemap...
<map:match pattern="NuevoMotivosSolicitud">
      <map:act type="form-validator">
        <map:parameter name="descriptor" value="context://descriptores/NuevoMotivosSolicitud.xml"/>
        <map:parameter name="validate-set" value="NuevoMotivosSolicitud"/>
        <map:call resource="portal">
          <map:parameter name="accion" value="context://logica/configuracion/MotivosSolicitud/FrmMotivosSolicitud"/>
              <map:parameter name="validado" value="false"/>
              <map:parameter name="ajeno" value="false"/>
              <map:parameter name="primeraVez" value="false"/>
              <map:parameter name="vieneDeMod" value="false"/>
        </map:call>
      </map:act>
      <map:call resource="portal">
        <map:parameter name="accion" value="context://logica/configuracion/MotivosSolicitud/FrmNuevoMotivosSolicitud"/>
              <map:parameter name="validado" value="true"/>
              <map:parameter name="ajeno" value="false"/>
              <map:parameter name="primeraVez" value="false"/>
              <map:parameter name="vieneDeMod" value="false"/>
      </map:call>
    </map:match>

 If I don't use the form-validator in this "map:match" I have not this problem, so I'm very
surprised....
Carlos.



Christian Haul wrote:

> On 11.Jul.2002 -- 03:54 PM, Carlos Maté wrote:
> > Hi.
> >
> > In my cocoon2 based application, queries in a xsp page using "esql" taglib  are
executed  ¡¡ two times !! although, of course, they are only written once.
> > It doesn't happen always, but happen.
> > I think it's related with the form-validator but I'm not sure. And I need the form-validator.
> > Can you help me, please?
>
> Example, please.
> I do use both without problem.
>
>         Chris.
>
> Please follow up summarizing your problem and which suggested solution
> / information worked for you when you consider your problem
> solved. Add "SUMMARY: " to the subject line. This will make FAQ
> generation and searching the list easier. In addition, it makes
> helping you more fun. Thank you.
>
> --
> C h r i s t i a n       H a u l
> haul@informatik.tu-darmstadt.de
>     fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08
>
> ---------------------------------------------------------------------
> Please check that your question  has not already been answered in the
> FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>




---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message