Thread: [BUGS] BUG #14712: postgres how to handle boolean datatype to use 0 and 1using hibernate
[BUGS] BUG #14712: postgres how to handle boolean datatype to use 0 and 1using hibernate
From
aprasad@flexerasoftware.com
Date:
The following bug has been logged on the website: Bug reference: 14712 Logged by: Akanksha Prasad Email address: aprasad@flexerasoftware.com PostgreSQL version: 9.6.2 Operating system: windows 7 Description: I wanted to use boolean withd efault value as 1 in hbm file , the hibernate generates the ddl for sql server and oracle and they both works fine but postgres fails with error as cannot have int default 1 as value for boolean field. Please help with this. How can i do this with changes only at the dialect level beacuse changing the application me too many changes and that too sql server and oracle databases with fail. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #14712: postgres how to handle boolean datatype to use0 and 1 using hibernate
From
"David G. Johnston"
Date:
The following bug has been logged on the website:
Bug reference: 14712
Logged by: Akanksha Prasad
Email address: aprasad@flexerasoftware.com
PostgreSQL version: 9.6.2
Operating system: windows 7
Description:
I wanted to use boolean withd efault value as 1 in hbm file , the hibernate
generates the ddl for sql server and oracle and they both works fine but
postgres fails with error as cannot have int default 1 as value for boolean
field.
Please help with this. How can i do this with changes only at the dialect
level beacuse changing the application me too many changes and that too sql
server and oracle databases with fail.
Please send non-bug-report questions to pgsql-general@postgresql.org or a more appropriate list if there is one.
Thank You.
David J.
p.s. It sounds to me, though, that if Hibernate is translating between dialects that you should be able to specify "default true" for your boolean column and let it make that work with the other DBMSes - a true boolean column only stores "True" and "False" by definition.