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

Reply via email to