• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

CMP and Oracle CLOB

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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:
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
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic