How to use Custom Type Handler?

[Angel Valero]

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