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

Reply via email to