3:44 p.m.
SQL datatypes for booleans not being handled correctly
------------------------------------------------------
Key: HHH-6705
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR4
Reporter: Steve Ebersole
Assignee: Steve Ebersole
Fix For: 4.0.0.next
Perhaps due to changes for metamodel...
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:48 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-6705) SQL datatypes for booleans not being handled correctly
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705?page=c...
]
Brad Maxwell updated HHH-6705:
------------------------------
Attachment: hhh-6705.war.zip
hhh-6705.war
hhh-6705-server.log
adding server.log, compiled test war and source for test war
SQL datatypes for booleans not being handled correctly
------------------------------------------------------
Key: HHH-6705
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR4
Reporter: Steve Ebersole
Assignee: Steve Ebersole
Fix For: 4.0.0.next
Attachments: hhh-6705-server.log, hhh-6705.war, hhh-6705.war.zip
Perhaps due to changes for metamodel...
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:48 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6705) SQL datatypes for booleans not being handled correctly
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705?page=c...
]
Brad Maxwell commented on HHH-6705:
-----------------------------------
Server log
17:44:19,891 INFO [java.sql.DatabaseMetaData] (MSC service thread 1-3) HHH000262: Table
not found: TestEntity
17:44:19,893 INFO [java.sql.DatabaseMetaData] (MSC service thread 1-3) HHH000262: Table
not found: TestEntity
17:44:19,898 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-3)
HHH000388: Unsuccessful: create table TestEntity (Id number(19,0) not null, BoolObject
boolean, BoolPrim boolean, primary key (Id))
17:44:19,898 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-3)
ORA-00902: invalid datatype
17:44:19,898 INFO [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-3)
HHH000232: Schema update complete
Attaching full AS 7.1 Alpha 2 log and test case.
Test cause is using OracleDS at java:jboss/datasources/ExampleOracleDS using ojdbc6.jar in
deployments directory.
Started server with:
./standalone.sh --server-config=standalone-preview.xml
To test create ExampleOracleDS and deploy hhh-6705.war
SQL datatypes for booleans not being handled correctly
------------------------------------------------------
Key: HHH-6705
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR4
Reporter: Steve Ebersole
Assignee: Steve Ebersole
Fix For: 4.0.0.next
Attachments: hhh-6705-server.log, hhh-6705.war, hhh-6705.war.zip
Perhaps due to changes for metamodel...
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:12 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6705) SQL datatypes for booleans not being handled correctly
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705?page=c...
]
Lukasz Antoniak commented on HHH-6705:
--------------------------------------
In my opinion there is a little bug in Oracle dialects. Oracle RDBMS does not support (in
any version) BOOLEAN column type. BOOLEAN can be legally used only in PL/SQL stored
procedure. I did not know that Hibernate manages mapping of Boolean/boolean properties.
I've been always extending {{org.hibernate.type.CharBooleanType}} to create a custom
type.
So, should Boolean be mapped to NUMBER(1,0) or CHAR(1)? In my opinion NUMBER(1,0) is more
universal, because acronyms for 'Yes' and 'No' can differ in various
languages. Teradata dialect also uses 'BYTEINT'.
SQL datatypes for booleans not being handled correctly
------------------------------------------------------
Key: HHH-6705
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR4
Reporter: Steve Ebersole
Assignee: Steve Ebersole
Fix For: 4.0.0.next
Attachments: hhh-6705-server.log, hhh-6705.war, hhh-6705.war.zip
Perhaps due to changes for metamodel...
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:14 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-6705) SQL datatypes for booleans not being handled correctly
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705?page=c...
]
Lukasz Antoniak updated HHH-6705:
---------------------------------
Attachment: HHH-6705.patch
Attaching fix patch.
SQL datatypes for booleans not being handled correctly
------------------------------------------------------
Key: HHH-6705
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR4
Reporter: Steve Ebersole
Assignee: Steve Ebersole
Fix For: 4.0.0.next
Attachments: HHH-6705.patch, hhh-6705-server.log, hhh-6705.war, hhh-6705.war.zip
Perhaps due to changes for metamodel...
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:18 p.m.
New subject: [Hibernate-JIRA] Assigned: (HHH-6705) SQL datatypes for booleans not being handled correctly
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705?page=c...
]
Gail Badner reassigned HHH-6705:
--------------------------------
Assignee: Gail Badner (was: Steve Ebersole)
SQL datatypes for booleans not being handled correctly
------------------------------------------------------
Key: HHH-6705
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR4
Reporter: Steve Ebersole
Assignee: Gail Badner
Fix For: 4.0.0.next
Attachments: HHH-6705.patch, hhh-6705-server.log, hhh-6705.war, hhh-6705.war.zip
Perhaps due to changes for metamodel...
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:36 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-6705) SQL datatypes for booleans not being handled correctly
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705?page=c...
]
Gail Badner resolved HHH-6705.
------------------------------
Resolution: Duplicate
Fix Version/s: (was: 4.0.0.next)
SQL datatypes for booleans not being handled correctly
------------------------------------------------------
Key: HHH-6705
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6705
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR4
Reporter: Steve Ebersole
Assignee: Gail Badner
Attachments: HHH-6705.patch, hhh-6705-server.log, hhh-6705.war, hhh-6705.war.zip
Perhaps due to changes for metamodel...
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4606
days inactive
4616
days old
hibernate-issues@lists.jboss.org
6 comments
4 participants
participants (4)
-
Brad Maxwell (JIRA) -
Gail Badner (JIRA)
-
Lukasz Antoniak (JIRA)
-
Steve Ebersole (JIRA)