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 ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

CMP and Oracle CLOB

 
Greenhorn
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:
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!
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic