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
What are you doing? You are supposed to be reading this tiny ad!