[jbossseam-issues] [JBoss JIRA] Created: (JBSEAM-3298) seam-gen doesn't handle hibernate types such as yes_no
6:33 p.m.
seam-gen doesn't handle hibernate types such as yes_no
------------------------------------------------------
Key: JBSEAM-3298
URL: https://jira.jboss.org/jira/browse/JBSEAM-3298
Project: Seam
Issue Type: Bug
Components: Tools
Affects Versions: 2.0.3.CR1
Environment: JBoss 4.2.2, DB2, Linux
Reporter: Valerie Griffin
My database has quite a few CHAR(1) entries used as boolean values where the field can
contain Y or N. I defined these entries as hibernate yes_no in the seam-gen.reveng.xml
file, but the code didn't reflect the data type. To work, the field needs to be
annotated with
@Type(type = "yes_no")
and needs to not contain an annotation like:
@Length(max = 1)
If the Type annotation is absent, hibernate detects a schema mismatch. (It expects a
numeric boolean value.)
If there's a Length annotation, the UI's checkbox displays a surprising error
message about the data length.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7 p.m.
New subject: [jbossseam-issues] [JBoss JIRA] Updated: (JBSEAM-3298) seam-gen doesn't handle hibernate types such as yes_no
[
https://jira.jboss.org/jira/browse/JBSEAM-3298?page=com.atlassian.jira.pl...
]
Valerie Griffin updated JBSEAM-3298:
------------------------------------
Attachment: EntityHome.java.ftl
GetPropertyAnnotation.ftl
These files allow use of hibernate yes_no. The change to EntityHome resolves a syntax
error caused by a boolean value in a composite key.
This is not really a complete fix because there is no test in the code for the hibernate
type. According to a post in the hibernate forum, Hibernate is failing to include the
yes_no annotation so I don't know if all of this belongs in seam-gen.
seam-gen doesn't handle hibernate types such as yes_no
------------------------------------------------------
Key: JBSEAM-3298
URL: https://jira.jboss.org/jira/browse/JBSEAM-3298
Project: Seam
Issue Type: Bug
Components: Tools
Affects Versions: 2.0.3.CR1
Environment: JBoss 4.2.2, DB2, Linux
Reporter: Valerie Griffin
Attachments: EntityHome.java.ftl, GetPropertyAnnotation.ftl
My database has quite a few CHAR(1) entries used as boolean values where the field can
contain Y or N. I defined these entries as hibernate yes_no in the seam-gen.reveng.xml
file, but the code didn't reflect the data type. To work, the field needs to be
annotated with
@Type(type = "yes_no")
and needs to not contain an annotation like:
@Length(max = 1)
If the Type annotation is absent, hibernate detects a schema mismatch. (It expects a
numeric boolean value.)
If there's a Length annotation, the UI's checkbox displays a surprising error
message about the data length.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:58 p.m.
New subject: [jbossseam-issues] [JBoss JIRA] Updated: (JBSEAM-3298) seam-gen doesn't handle hibernate types such as yes_no
[
https://jira.jboss.org/jira/browse/JBSEAM-3298?page=com.atlassian.jira.pl...
]
Pete Muir updated JBSEAM-3298:
------------------------------
Assignee: Dan Allen
Dan, can you take a look at this?
seam-gen doesn't handle hibernate types such as yes_no
------------------------------------------------------
Key: JBSEAM-3298
URL: https://jira.jboss.org/jira/browse/JBSEAM-3298
Project: Seam
Issue Type: Bug
Components: Tools
Affects Versions: 2.0.3.CR1
Environment: JBoss 4.2.2, DB2, Linux
Reporter: Valerie Griffin
Assignee: Dan Allen
Attachments: EntityHome.java.ftl, GetPropertyAnnotation.ftl
My database has quite a few CHAR(1) entries used as boolean values where the field can
contain Y or N. I defined these entries as hibernate yes_no in the seam-gen.reveng.xml
file, but the code didn't reflect the data type. To work, the field needs to be
annotated with
@Type(type = "yes_no")
and needs to not contain an annotation like:
@Length(max = 1)
If the Type annotation is absent, hibernate detects a schema mismatch. (It expects a
numeric boolean value.)
If there's a Length annotation, the UI's checkbox displays a surprising error
message about the data length.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:14 a.m.
New subject: [jbossseam-issues] [JBoss JIRA] Commented: (JBSEAM-3298) seam-gen doesn't handle hibernate types such as yes_no
[
https://jira.jboss.org/jira/browse/JBSEAM-3298?page=com.atlassian.jira.pl...
]
Julien Kronegg commented on JBSEAM-3298:
----------------------------------------
We had the same problem (mapping Y/N character to boolean) using the following type
mapping in the seam-gen.reveng.xml file:
<type-mapping>
<sql-type jdbc-type="CHAR" length="1" not-null="true"
hibernate-type="yes_no"/>
</type-mapping>
The corresponding java properties are defined as java.lang.Boolean with the @Column(...),
@NotNull and @Length(max=1) annotations.
Thus, when we do a HQL
"select o from MyObject o where o.myYesNoProperty=true"
the SQL prepared statement is
"select ... from MY_OBJECT where MY_YES_NO_PROPERTY=1"
This is the wrong behavior. The correct behavior would be to generate the following SQL
prepared statement:
"select ... from MY_OBJECT where MY_YES_NO_PROPERTY='Y' "
As Valerie wrote, the correct behavior is obtained by adding the
@Type(type="yes_no") annotation. The @Length annotation is not mandatory (the
expected SQL query is generated whether if the @Length annotation is present or not).
We found references to that "feature" on the web:
- http://www.seamframework.org/Community/HibernateYesnoForChar1VsSeamgen (Valerie's
original post; I added a reference to this JIRA issue)
- http://arrogantprogrammer.blogspot.com/2008/02/hibernate-reverse-engineer...
seam-gen doesn't handle hibernate types such as yes_no
------------------------------------------------------
Key: JBSEAM-3298
URL: https://jira.jboss.org/jira/browse/JBSEAM-3298
Project: Seam
Issue Type: Bug
Components: Tools
Affects Versions: 2.0.3.CR1
Environment: JBoss 4.2.2, DB2, Linux
Reporter: Valerie Griffin
Assignee: Dan Allen
Attachments: EntityHome.java.ftl, GetPropertyAnnotation.ftl
My database has quite a few CHAR(1) entries used as boolean values where the field can
contain Y or N. I defined these entries as hibernate yes_no in the seam-gen.reveng.xml
file, but the code didn't reflect the data type. To work, the field needs to be
annotated with
@Type(type = "yes_no")
and needs to not contain an annotation like:
@Length(max = 1)
If the Type annotation is absent, hibernate detects a schema mismatch. (It expects a
numeric boolean value.)
If there's a Length annotation, the UI's checkbox displays a surprising error
message about the data length.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:28 a.m.
New subject: [jbossseam-issues] [JBoss JIRA] Commented: (JBSEAM-3298) seam-gen doesn't handle hibernate types such as yes_no
[
https://jira.jboss.org/jira/browse/JBSEAM-3298?page=com.atlassian.jira.pl...
]
Valerie Griffin commented on JBSEAM-3298:
-----------------------------------------
As I stated in my original report, including the @Length annotation causes validation
problems. Hibernate tries to validate the length, but it can't. The only purpose of
the @Length annotation is validation.
seam-gen doesn't handle hibernate types such as yes_no
------------------------------------------------------
Key: JBSEAM-3298
URL: https://jira.jboss.org/jira/browse/JBSEAM-3298
Project: Seam
Issue Type: Bug
Components: Tools
Affects Versions: 2.0.3.CR1
Environment: JBoss 4.2.2, DB2, Linux
Reporter: Valerie Griffin
Assignee: Dan Allen
Attachments: EntityHome.java.ftl, GetPropertyAnnotation.ftl
My database has quite a few CHAR(1) entries used as boolean values where the field can
contain Y or N. I defined these entries as hibernate yes_no in the seam-gen.reveng.xml
file, but the code didn't reflect the data type. To work, the field needs to be
annotated with
@Type(type = "yes_no")
and needs to not contain an annotation like:
@Length(max = 1)
If the Type annotation is absent, hibernate detects a schema mismatch. (It expects a
numeric boolean value.)
If there's a Length annotation, the UI's checkbox displays a surprising error
message about the data length.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:15 a.m.
New subject: [jbossseam-issues] [JBoss JIRA] Commented: (JBSEAM-3298) seam-gen doesn't handle hibernate types such as yes_no
[
https://jira.jboss.org/jira/browse/JBSEAM-3298?page=com.atlassian.jira.pl...
]
Dan Allen commented on JBSEAM-3298:
-----------------------------------
Resolved by making the following two changes:
1. Don't add @Length annotation for boolean types
2. Add @Type(type = "yes_no") annotation to entity properties that are set to
the hibernate type "yes_no"
seam-gen doesn't handle hibernate types such as yes_no
------------------------------------------------------
Key: JBSEAM-3298
URL: https://jira.jboss.org/jira/browse/JBSEAM-3298
Project: Seam
Issue Type: Bug
Components: Tools
Affects Versions: 2.0.3.CR1
Environment: JBoss 4.2.2, DB2, Linux
Reporter: Valerie Griffin
Assignee: Dan Allen
Fix For: 2.2.0.CR1
Attachments: EntityHome.java.ftl, GetPropertyAnnotation.ftl
My database has quite a few CHAR(1) entries used as boolean values where the field can
contain Y or N. I defined these entries as hibernate yes_no in the seam-gen.reveng.xml
file, but the code didn't reflect the data type. To work, the field needs to be
annotated with
@Type(type = "yes_no")
and needs to not contain an annotation like:
@Length(max = 1)
If the Type annotation is absent, hibernate detects a schema mismatch. (It expects a
numeric boolean value.)
If there's a Length annotation, the UI's checkbox displays a surprising error
message about the data length.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:15 a.m.
New subject: [jbossseam-issues] [JBoss JIRA] Resolved: (JBSEAM-3298) seam-gen doesn't handle hibernate types such as yes_no
[
https://jira.jboss.org/jira/browse/JBSEAM-3298?page=com.atlassian.jira.pl...
]
Dan Allen resolved JBSEAM-3298.
-------------------------------
Fix Version/s: 2.2.0.CR1
Resolution: Done
seam-gen doesn't handle hibernate types such as yes_no
------------------------------------------------------
Key: JBSEAM-3298
URL: https://jira.jboss.org/jira/browse/JBSEAM-3298
Project: Seam
Issue Type: Bug
Components: Tools
Affects Versions: 2.0.3.CR1
Environment: JBoss 4.2.2, DB2, Linux
Reporter: Valerie Griffin
Assignee: Dan Allen
Fix For: 2.2.0.CR1
Attachments: EntityHome.java.ftl, GetPropertyAnnotation.ftl
My database has quite a few CHAR(1) entries used as boolean values where the field can
contain Y or N. I defined these entries as hibernate yes_no in the seam-gen.reveng.xml
file, but the code didn't reflect the data type. To work, the field needs to be
annotated with
@Type(type = "yes_no")
and needs to not contain an annotation like:
@Length(max = 1)
If the Type annotation is absent, hibernate detects a schema mismatch. (It expects a
numeric boolean value.)
If there's a Length annotation, the UI's checkbox displays a surprising error
message about the data length.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:21 a.m.
New subject: [JBoss JIRA] Closed: (JBSEAM-3298) seam-gen doesn't handle hibernate types such as yes_no
[
https://jira.jboss.org/jira/browse/JBSEAM-3298?page=com.atlassian.jira.pl...
]
Pete Muir closed JBSEAM-3298.
-----------------------------
seam-gen doesn't handle hibernate types such as yes_no
------------------------------------------------------
Key: JBSEAM-3298
URL: https://jira.jboss.org/jira/browse/JBSEAM-3298
Project: Seam
Issue Type: Bug
Components: Tools
Affects Versions: 2.0.3.CR1
Environment: JBoss 4.2.2, DB2, Linux
Reporter: Valerie Griffin
Assignee: Dan Allen
Fix For: 2.1.2.CR1
Attachments: EntityHome.java.ftl, GetPropertyAnnotation.ftl
My database has quite a few CHAR(1) entries used as boolean values where the field can
contain Y or N. I defined these entries as hibernate yes_no in the seam-gen.reveng.xml
file, but the code didn't reflect the data type. To work, the field needs to be
annotated with
@Type(type = "yes_no")
and needs to not contain an annotation like:
@Length(max = 1)
If the Type annotation is absent, hibernate detects a schema mismatch. (It expects a
numeric boolean value.)
If there's a Length annotation, the UI's checkbox displays a surprising error
message about the data length.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5449
days inactive
5968
days old
7 comments
4 participants
participants (4)
-
Dan Allen (JIRA) -
Julien Kronegg (JIRA)
-
Pete Muir (JIRA)
-
Valerie Griffin (JIRA)