Clob to String using hibernate and Oracle

Question

I am having difficulty while reading from oracle database using hibernate. The column is of clob type and mapped class property is of String type. The database is Oracle 11G. I have tried to update my driver as suggested by some posts, But it was of no use. The problem is that All other columns(which are not clob) are read properly and the column which is clob is returned null besides it has data. Thanks in advance.

The query is :

select id,about_us,other_details,periodicity,active,createts,updatets from Details where id = ?

This above the HQL query where about_us and other_details are clob type in database. The java entity contains it as type String.

Rahul

Rahul Taneja · Accepted Answer · 2014-03-18 09:23:17Z

2

I tried many solutions as suggested in different posts, It includes: 1) Updating odbc jar. 2) Using @lob on the porperty in hibernate mapping/entity.

Both of the above solutions did not work for me, Rather I used the hibernate function str(clob_property) to read it, It worked for me and I could get the property read.

Regards Rahul

answered Mar 18, 2014 at 9:23

Rahul Taneja

4172 gold badges8 silver badges18 bronze badges

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

Comments

ttulka · Accepted Answer · 2014-03-10 13:49:02Z

0

Have you tried something like this?

@Lob @Column(name = "long_text")
private String longText;

answered Mar 10, 2014 at 13:49

ttulka

11k7 gold badges46 silver badges57 bronze badges

1 Comment

Rahul Taneja Over a year ago

Yes, I have tried using @Lob annotation, but it was of no respite. In fact, Hibernate detects itself the underlying columng with just use of @Column annotations.

Collectives™ on Stack Overflow

Clob to String using hibernate and Oracle

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