ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hofri Yehuda" <Yehuda.Ho...@comverse.com>
Subject RE: Problem with Mapping Boolean to Bit(MSSql)
Date Tue, 23 Jan 2007 08:58:21 GMT

Good luck with that... 

-----Original Message-----
From: Martin Ewald [mailto:martinewald@gmail.com] 
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:martinewald@gmail.com]
> 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: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-
>> 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.

Mime
View raw message