WebSphere allowable type mappings
For WebSphere applications, fields that can be used in predicates, grouping or ordering operations must be of the types listed below:
Primitive types: byte, short, int, long, float, double, boolean, char
Object types: Byte, Short, Integer, Long, Float, Double, BigDecimal,
String, Boolean, Char
JDBC types: Date, Time, Timestamp
CMP fields used in the SELECT clause can be of any type supported by the EJB container.
If a CMP field is mapped to a column using a converter function for finder and select queries, the field can be used in predicates of the following form:
field <comparison> literal_value
field <comparison> parameter
In this situation, the inverse converter toData( ) method is used to convert the right side of the comparison to a database value and the predicate is rewritten into SQL.
Examples of valid predicates:
e.name = 'Chris'
e.name > ?1
Examples of invalid predicates:
substring(e.name,1,3) = 'ABC'
e.salary > d.budget
The field must be mapped to a table column that is compatible in type.
You can get more information from WSAD Help.
-Mahesh