How to create a blob / clob?

Question

At the moment I have hibernate JPA HSQLDB to auto-create my database tables.

<property name="hibernate.hbm2ddl.auto" value="create-drop" />

How can I tell JPA or Hibernate to save a String as a clob/blob field? Ie a very long String. I could not find any annotation so far. How must I configure this on eg a private String myBigContent?

Aryan · Accepted Answer · 2013-06-28 10:59:45Z

1

Hope this may help :)

  @Column( name = "FILEIMAGE" )
    @Lob(type = LobType.BLOB)
    private byte[] fileimage;

answered Jun 28, 2013 at 10:59

Aryan

1,9072 gold badges23 silver badges42 bronze badges

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

1 Comment

membersound Over a year ago

Just for reference. As written I use HSQLDB, which has a serious Bug which is still not fixed in the 2.3.0-SNAPSHOT release. Using @Lob, it always results in a unsupported internal operation: Session Exception. Therefore I switched to @Column(length = 2147483647) which should do the same as lob.

Collectives™ on Stack Overflow

How to create a blob / clob?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related