Bugs item #555764, was opened at 2002-05-14 01: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: Closed >Resolution: Fixed 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: Dain Sundstrom (dsundstrom) Date: 2002-06-09 15:01 Message: Logged In: YES user_id=251431 Added true-mapping and false-mapping elements type- mapping. For most databases they have been set to 1 and 0 respectively. If the mapping is wrong for your database, post a bug report. ---------------------------------------------------------------------- Comment By: Tim Fox (timfox) Date: 2002-05-16 06: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 01: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 _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
