Not if you're using java tiger... Otherwise you must cast. -----Original Message----- From: Martin Ewald [mailto:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 4:15 PM To: user-java@ibatis.apache.org Subject: RE: Problem with Mapping Boolean to Bit(MSSql)
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:[EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] 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-t > f3055783.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.
