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.
