Hello,

I'm trying to do just as in page 36 of the dev manual:
<sqlMap namespace="SQL.procedimientos">

        <resultMap class="com.ibermatica.nia.db.ProcedimientoAlmacenado"
id="get-procedimientos">
                <result property="nombre" column="ROUTINE_NAME"/>
                <result property="listaDeParametros"
column="ROUTINE_NAME"
select="spObtenerListaDeParametrosDelProcedimiento"/>
        </resultMap>

        <resultMap
class="com.ibermatica.nia.db.ParametroDeProcedimientoAlmacenado"
id="get-parametros">
                <result property="nombre" column="PARAMETER_NAME"/>
                <result property="modo" column="PARAMETER_MODE"/>
                <result property="tipo" column="DATA_TYPE"/>
        </resultMap>

        <procedure id="spObtenerListaDeProcedimientos"
                parameterClass="java.lang.String"
                resultMap="get-procedimientos">
                <![CDATA[
{call spObtenerListaDeProcedimientos ()}
]]>
        </procedure>
        <procedure id="spObtenerListaDeParametrosDelProcedimiento"
                parameterClass="java.lang.String"
                resultMap="get-parametros">
                <![CDATA[
{call spObtenerListaDeParametrosDelProcedimiento (
[EMAIL PROTECTED],jdbcType=VARCHAR,javaType=java.lang.String,mode=IN
#
)}
]]>
        </procedure>
</sqlMap>


The problem is it doesn't seem to like the reference to the procedure in
the first resultMap:
"There is no statement named spObtenerListaDeParametrosDelProcedimiento
in this SqlMap."

Which is a weird error, because if I reference a select with that name
(i.e. I substiture the procedure for a select) I get the same error.

So,
A) what is the problem?
B) can this be achieved w/ stored procedures only?

Thank you so much,
Alex

Reply via email to