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
> [EMAIL PROTECTED]
> 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: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
