ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Ewald <martinew...@gmail.com>
Subject RE: Problem with Mapping Boolean to Bit(MSSql)
Date Mon, 22 Jan 2007 14:15:26 GMT

Hi

thx, for the fast ( and short :) ) answer...

hmmm, do i have to write an own Typehandler to support Boolean <-> Bit?

Greez Martin


yhofri wrote:
> 
> Use the integer parameter-type.
> 
> -----Original Message-----
> From: Martin Ewald [mailto:martinewald@gmail.com] 
> Sent: Monday, January 22, 2007 3:36 PM
> To: user-java@ibatis.apache.org
> Subject: Problem with Mapping Boolean to Bit(MSSql)
> 
> 
> Hi
> 
> I'm really new to iBatis and have a Problem with mapping a Boolean Java
> Bean property to an "MSSql-Server 2005" Bit field...
> 
> The Query aborts with the message:
> Exception in 'java.lang.Class': com.ibatis.dao.client.DaoException: Failed
> to insert - id [risGeschaeft.insert], parameterObject
> [ch.oca.cq.ris.dao.Geschaeft@57737a]. Cause:
> com.ibatis.common.jdbc.exception.NestedSQLException:   
> --- The error occurred in ibatis/sqlMaps/ris/risGeschaeft_SqlMap.xml.  
> --- The error occurred while applying a parameter map.  
> --- Check the risGeschaeft.insert-InlineParameterMap.  
> --- Check the statement (update failed).  
> --- Cause: com.inet.tds.SQLException: Msg 8009, Level 16, State 1, Line 1,
> Sqlstate 01000 [MMS-SQL03]Der eingehende Tabular Data Stream (TDS) für das
> RPC-Protokoll (Remote Procedure Call) ist nicht richtig. Parameter 6 (""):
> Der 0x32-Datentyp ist unbekannt.
> 
> What means in English --> The incoming Tabular Data Stream (TDS) for the
> RPC-Protocol (Remote Procedure Call) is not correct. Parameter 6(""): The
> 0x32-Datatype in unknown.
> 
> The Definition out of the SqlMap:
> <insert id="insert_save" parameterClass="ch.oca.cq.ris.dao.Geschaeft" >
>   insert into risGeschaeft (PK_GeschaeftId, GeschaeftZiel, FK_ArtId,
> FK_ThemaId, GeschaeftDeleted,
>     GeschaeftBezeichnung, GeschaeftKurzbezeichnung, GeschaeftNummer,
> GeschaeftGremium,
>     GeschaeftBeschluss, GeschaeftEroeffnet, GeschaeftVorstoss,
> GeschaeftLaufweg,
>     GeschaeftAktenplanId, GeschaeftBezeichnungSort, GeschaeftNummerSort,
> GeschaeftBeschlussSort,
>     GeschaeftEroeffnetSort, ArtTextSort)
>   values (#id:VARCHAR#, #ziel:INTEGER#, #artId:VARCHAR#,
> #themaId:INTEGER#, #deleted:BIT#,
>     #bezeichnung:VARCHAR#, #kurzbezeichnung:VARCHAR#, #nummer:VARCHAR#,
> #gremium:VARCHAR#,
>     #beschluss:TIMESTAMP#, #eroeffnet:TIMESTAMP#, #vorstoss:BIT#,
> #laufweg:VARCHAR#,
>     #aktenplanId:VARCHAR#, #bezeichnungSort:VARCHAR#,
> #nummerSort:VARCHAR#,
>     #beschlussSort:VARCHAR#, #eroeffnetSort:VARCHAR#,
> #artTextSort:VARCHAR#) </insert>
> 
> I think i don't have to post the Java Bean Code cause it's a normal
> bean...
> 
> Had anyone of you a Problem like this bevor?
> 
> What can i do to fix this Problem?
> 
> Thx
> 
> Greez Martin Ewald
> --
> View this message in context:
> http://www.nabble.com/Problem-with-Mapping-Boolean-to-Bit%28MSSql%29-tf3055783.html#a8492657
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
> 
> 

-- 
View this message in context: http://www.nabble.com/Problem-with-Mapping-Boolean-to-Bit%28MSSql%29-tf3055783.html#a8502022
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message