Win a copy of Five Lines of Code this week in the OO, Patterns, UML and Refactoring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
  • Piet Souris
  • Frits Walraven
  • Carey Brown

CMP and Oracle CLOB

Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello there,
I am using Websphere 5 and EJB 2.0 and was wondering if it is possible to map CLOBs in some way when creating entity beans ?
Ranch Hand
Posts: 147
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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: = 'Chris' > ?1
Examples of invalid predicates:
substring(,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.
What are you doing? You are supposed to be reading this tiny ad!
Thread Boost feature
    Bookmark Topic Watch Topic
  • New Topic