14 Replies Latest reply on Mar 28, 2011 2:41 PM by Gaurav Chaudhary

    H2 database boolean type problem !

    Gaurav Chaudhary Newbie

      Hi ! I have a H2 database which has a table for example TABLE1. This has one column named as COLUMN1 which is of boolean datatype. Now, when I go through Teiid to see this table, COLUMN1 shows up like it has NULL datatype (or it does not have any datatype). All other datatypes work fine.

       

      Due to this problem, I am not able to fire any Update or Insert statements involving those columns through Teiid.  Though I was able to do "select" by casting that column to boolean but cast will not work in Insert or Update.

       

      Is there any workaround possible for this?

       

      Thanks in advance