hibernate mapping for oracle long raw

Question

I try to create a hibernate mapping for an oracle database. The datebase is pretty old from before oracle 8 but is now on 10. Hibernate reverse engineering balks at a long raw column. This datatype is deprecated and should be converted to blob.

But this is not my database. If the customer refuses to convert how would a hibernate mapping look like ?

Did you try to map it manually to anything? I guess you should be able to map it to java.sql.Blob; If you that fails, you must be able to map it to a UserType. see this blog.xebia.com/2009/11/… — bpgergo
– bpgergo, Commented Jul 4, 2011 at 15:01
I've just googled it and it according to Hibernate team member steve, it is possible to map it to String. link: forum.hibernate.org/… — bpgergo
– bpgergo, Commented Jul 4, 2011 at 15:04

antyrat · Accepted Answer · 2012-05-04 13:40:04Z

9

Try mapping it to byte[].

If you get java.sql.SQLException: Stream has already been closed, then try setting useFetchSizeWithLongColumn = true in the connection properties for the OJDBC driver. See the OracleDriver API

edited May 4, 2012 at 13:40

antyrat

27.7k9 gold badges78 silver badges77 bronze badges

answered May 4, 2012 at 13:35

Pablo

1,6921 gold badge16 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

hibernate mapping for oracle long raw

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related