Bugs item #555764, was opened at 2002-05-14 06:07 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=555764&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: Accepted Priority: 5 Submitted By: Stephen Coy (scoy) Assigned to: Dain Sundstrom (dsundstrom) Summary: EJB-QL/SQL mapping of boolean literals Initial Comment: JBoss 3.0RC2 and earlier does not perform any SQL mapping of the boolean literal constants 'false' and 'true'. Not all SQL implementations (Oracle in particular) support the use of literal "true" and "false" values in the SQL select statements generated from EJB QL. In these situations, the boolean values need to be mapped to a numeric value instead, such as 0 and 1. ---------------------------------------------------------------------- Comment By: Tim Fox (timfox) Date: 2002-05-16 11:58 Message: Logged In: YES user_id=545046 Also, it is very common to represent boolean as Y/N or y/n or T/F or 0/1 in a char(1) field. This is particularly common when retrofitting on a legacy database. There seems no way to map Y/N (or y/n etc.) to a boolean attribute at present. Suggestion would be to allow mapping of arbitrary pair of characters to represent true/false ---------------------------------------------------------------------- Comment By: Georg Schmid (giorgio42) Date: 2002-05-14 06:31 Message: Logged In: YES user_id=437570 I just ran into this same bug (using Oracle8). The only mapping that seems to occur is replacing a capital TRUE or FALSE by a lower-case version. Hmmm. I'm stunned. Georg ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=555764&group_id=22866 _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: [EMAIL PROTECTED] _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
