Try
#COMENTARIOS,type=String,dbType=VarChar#,handler=stringNull#
On 11/11/05, Angel Valero <[EMAIL PROTECTED]> wrote:
Thanks Gilles :), now my custom type handler is "about
to work"... I've changed this:
<typeHandlers>
<typeHandler type="String" dbType="VarChar"
callback="stringNull"/>
</typeHandlers>
And now the breakpoint in the "GetResult(IResultGetter
getter)" is working, but the other breakpoint in the
"void SetParameter(IParameterSetter setter, object
parameter)" is not working :(.
I´ve got this in the sqlMap file:
<update id="ActualizarPeguntaExamen"
parameterClass="PreguntaExamen">
update CUE_PREGUNTAS_EXAMEN
set ...
COMENTARIOS =
#COMENTARIOS,type=String,dbType=VarChar# ,
..
</update>
Any ideas?
Thanks in advance.
--- Gilles Bayon <[EMAIL PROTECTED]> escribió:
> I guess that for Oracle, you must used
> dbType="*VarChar*" with an upper C
> On 11/10/05, Angel Valero <[EMAIL PROTECTED]>
> wrote:
> >
> > Hi again. Now I'm trying to use a Custom Type
> Handler
> > in order to permit null strings with the Ms Oracle
> > client. I have created the custom type handler and
> in
> > the sqlMap.config I've added this:
> >
> > <alias>
> > <typeAlias
> > alias="stringNull"
> >
> > type="
> >
>
Cuestionarios.Persistencia.TypeHandlers.MsOracleVarcharTypeHandlerCallback
> > ,
> > Cuestionarios.Persistencia"/>
> > </alias>
> >
> > <typeHandlers>
> > <typeHandler type="string" dbType="Varchar"
> > callback="stringNull"/>
> > </typeHandlers>
> >
> > I'm trying with one map file in wich I've got
> this:
> >
> > <resultMaps>
> > <resultMap id="PreguntaExamenResult"
> > class="PreguntaExamen">
> > ..
> > <result property="COMENTARIOS"
> > column="COMENTARIOS" type="string"
> dbType="Varchar"/>
> > ..
> > </resultMap>
> > </resultMaps>
> >
> > <update id="ActualizarPeguntaExamen"
> > parameterClass="PreguntaExamen">
> > update CUE_PREGUNTAS_EXAMEN
> > set ...
> > COMENTARIOS =
> > #COMENTARIOS,type=string,dbType=Varchar# ,
> > ...
> > where ID_PREGUNTA_EXAMEN =
> > #ID_PREGUNTA_EXAMEN#
> > </update>
> >
> > Also I've got a breakpoint on each method of my
> custom
> > type handler. And when I try to perform the update
> > sentence with an empty value for the field
> > COMENTARIOS, I still having errors and no one of
> the
> > breakpoints are working.
> >
> > Any ideas?... um.. sorry for my poor English.
> >
> > Thanks in advance.
> >
> > Angel
> >
> >
> >
> > ______________________________________________
> > Renovamos el Correo Yahoo!
> > Nuevos servicios, más seguridad
> > http://correo.yahoo.es
> >
>
______________________________________________
Renovamos el Correo Yahoo!
Nuevos servicios, más seguridad
http://correo.yahoo.es
