Hello everybody,
due to business decision we needed to transfer our database from PostgreSQL to SQL Server 2014, we use in production Hibernate 3.6.7-Final. Now, we are trying to run our tests and application again reconfiguring Hibernate to deal with the new DBMS, and a problem occurred on the SchemaExport operation. It seems that SchemaExport is creating a query to create schema in SQL Server without converting boolean columns with the right "default" property, which in SQL Server is '0' or '1' instead 'true' or 'false'. I can see the SchemaExport source, where it receive the mapping of the boolean field, code doesn't care about the dialect setted on Hibernate configuration.
At the moment I solved the problem removing "default" property from the Hibernate mapping, but I would like to fix the behavior definitely. Do you know official ways to solve this problem?
Thanks in advance!
|