Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes Object Relational Mapping and the fly likes CLOB in Hibernate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "CLOB in Hibernate" Watch "CLOB in Hibernate" New topic

CLOB in Hibernate

Rahul Babbar
Ranch Hand

Joined: Jun 28, 2008
Posts: 210

I had a column defined as Varchar2(4000) in Oracle database and defined as the following in the Value Object.

I needed to change the column to allow more than 4000 chars, and since the maximum limit of varchar is 4000, i needed to change it to CLOB.
So, i changed the data type of the VALUE column in the database as CLOB.

Surprisingly, although i did not make any changes in the value object(like defining the column as CLOB etc), it has started working.
I am not sure whether it is the expected behavior and everything's good or i am in for a surprise when suddenly it will fail.

Any comments are appreciated.


Rahul Babbar
I agree. Here's the link:
subject: CLOB in Hibernate
It's not a secret anymore!