Hi ,
I am getting the following error while accessing the application.

org.hibernate.exception.SQLGrammarException: ERROR: column "COL1" is of type numeric but expression is of type boolean

The column is defined as numeric(1,0) in postgresql database and
the corresponding declaration in entity is Boolean.

In the MyPostgreSQLDialect constructor (MyPostgreSQLDialect class extends PostgresPlusDialect)
i have the following code:
registerColumnType(java.sql.Types.BOOLEAN, "numeric(1, 0)");

If i don;t have the above line, i am getting error while the application is loading. If the above line exists then the application is loaded fine. But while accessing the application, i am getting the below error:
org.hibernate.exception.SQLGrammarException: ERROR: column "COL1" is of type numeric but expression is of type boolean

Can any one help me on this?


Thanks
Madhu