Good luck with that... -----Original Message----- From: Martin Ewald [mailto:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 5:36 PM To: user-java@ibatis.apache.org Subject: RE: Problem with Mapping Boolean to Bit(MSSql)
Unfortunately i must use Java 1.4 :( Cast? i think you misunderstood me... Well, i decide me to write a Typehandler to have a comfortable interface. The only thing i don't unterstand is that in the Dokumentation Boolean <-> Bit is listed as Supported.... but, thx 4 ur help yhofri wrote: > > 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-t > f3055783.html#a8502022 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#a8503571 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
