Any other ideas? Somebody else in trouble with booleans under .NET and ODBC?
It's a really weird issue... probably I'm doing something wrong, but I can't find where and I don't understand it, cause all attributes other than boolean are working okay (and even boolean attributes are working okay in insertions!!).
Thanks,
Pablo.
Gilles Bayon wrote:
Have you try to specify a dbtype = 'bool' in the resultMap property ?
-Gilles
On Mon, 31 Jan 2005 10:42:51 +0100, Pablo Lopez <[EMAIL PROTECTED]> wrote:
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.
Thanks a lot,
Pablo.
