RE: Boolean properties with Microsoft OracleClient

[Thompson, Kent]

Thanks.  I think I'll have to use the approach you mentioned (possibly
storing an integer value of 0 or 1 in a separate property).

Do you have any time frame when the 'custom type handler' feature might
be included in the .NET version of Ibatis?  Seems like this could be
used to overcome some of the shortcommings in the OracleClient.

Thanks again,
Kent

-----Original Message-----
From: Roberto Rabe [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 29, 2005 3:00 PM
To: ibatis-user-cs@incubator.apache.org
Subject: Re: Boolean properties with Microsoft OracleClient

Yes, there are known issues with GetBoolean and GetByte with the
OracleClient provider (not supported).

This is not a clean workaround, but you could create a 2nd set of
property accessors in your class that is used by the mapper that
actually sets the class bool field just to get it working.

For example, the iBATIS NUnit tests use a class with a Guid property but
the tests store it in a varchar field in Oracle.  To make the test pass,
this is used (not great but it works with the provider and works on the
same class' private field _guid):

public Guid Guid
{
        get
        {
                return _guid;
        }
        set
        {
                _guid = value;
        }
}

public string GuidString {
        get {
                return _guid.ToString();
        }
        set {
                if (value == null) {
                        _guid = Guid.Empty;
                }
                else {
                        _guid = new Guid(value.ToString());
                }
        }
}

Probably could poke holes in there like String.Empty but I dan't think
the DataMapper passes that back as a result currently.  :-)

Hope this helps!

Roberto



On Tue, March 29, 2005 12:02, Pablo Lopez said:
> Hi Kent,
>
> I also had some problems with booleans with PostgreSQL. This was my 
> email and my problem:
>
>> Hi everybody,
>>
>> I'm using iBatis under .NET and PostgreSQL (ODBC driver). I'm trying 
>> my first mappings and I have a problem with the boolean datatype.
>>
>> Integer mapping is working okay, and I can query / insert objects 
>> without any trouble, but the problem arises when one of the 
>> attributes is a boolean (bool under .NET / bool under PostgreSQL).
>>
>> When I insert an object there is no problem, but when I query the 
>> database to populate an object, the following exception arises:
>>
>> "Uncontrolled Exception: System.InvalidCastException: "Specified 
>> conversion is not valid" (at
>> System.Data.Odbc.OdbcDataReader.GetBoolean(Int32 i)
>>
>>
>> I don't know what the problem is, cause I'm using bool types under 
>> .Net and under PostgreSQL. I also tried the bit type (in the 
>> documentation), but it doesn't work.
>>
>> What annoys me is that insertions are correct, but queries are not.
>
> I tried several solutions (specifying a dbtype = 'bool' in the 
> resultMap property, for example) but none of them worked, so now I'm 
> using shorts even it's still spring ;) (bad joke)
>
> Talking seriously, I know using a short type instead is messy and not 
> elegant, in fact it annoys me quite a lot, but it's the only one that 
> did work.
>
> I hope you're luckier. Just keep in touch if you come across
something.
>
> See you,
>
> Pablo.
>
>
>