[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3401) H2 Database Dialect Fixes

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3401?page=c... ] Thomas Mueller commented on HHH-3401: ------------------------------------- For H2, BIT and BOOLEAN are the same data type. The same as CHAR and CHARACTER are the same data type. If you create a table like this: CREATE TABLE TEST(B BIT, C CHARACTER); and then retrieve the meta data (using DatabaseMetaData) and re-construct the CREATE TABLE statement you get: CREATE TABLE TEST(B BOOLEAN, C CHAR); However Hibernate doesn't 'know' currently that BIT is BOOLEAN is the same, because of the H2Dialect. So when you start the test again, Hibernate says that the data type BOOLEAN is not compatible with BIT. By the way this problem was found by Dan Allen. He works for Red Hat / JBoss now. See also http://www.manning-sandbox.com/thread.jspa?threadID=26080&tstart=0 Please tell me if you have more question. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira