cannot get clob datatype from database into JPA entity

Question

I able to save (spring-hibernate saveorupdate()) field

 @Lob
 @Column(name = "FILENAME")
 private String filename;

into oracle database datatype is clob

but when i try retrieve it, i get error

ERROR - JDBCExceptionReporter.logExceptions(72) | ORA-00932: inconsistent datatypes: expected - got CLOB

below is how i retrive from database

DetachedCriteria crit = DetachedCriteria.forClass(Storagefile.class);
crit.addOrder(bSortOrder ? Order.asc(sortColumnId) : Order.desc(sortColumnId));
 List<Storagefile> result = (List<Storagefile>) getHibernateTemplate().findByCriteria(crit, nFirst, nPageSize);

skaffman · Accepted Answer · 2009-12-23 12:44:43Z

6

It's not clear from your sample code, but my guess is that you're trying to sort by the CLOB column, and Oracle does not permit that. That error code is Oracle's charming way of telling you this.

Are you sure you need to use a CLOB to store a filnename? Oracle can store up to 4000 characters in a VARCHAR2 column, surely that's enough for a filename? If you want to sort by the filename, then that's what you'll need to do.

answered Dec 23, 2009 at 12:44

skaffman

405k96 gold badges825 silver badges775 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

davek · Accepted Answer · 2009-12-23 10:06:05Z

1

Have you waded through this:

https://www.hibernate.org/56.html

There seems to be an issue with the Oracle 9i driver and LOBs (not sure what your setup is).

answered Dec 23, 2009 at 10:06

davek

23k11 gold badges80 silver badges97 bronze badges

1 Comment

cometta Over a year ago

i upgraded to 10gDialect but still the same.

Collectives™ on Stack Overflow

cannot get clob datatype from database into JPA entity

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related