Home JBoss howto Persistence - Database How to use Clob and Blob with EJB 3 ?
30 | 07 | 2010
JBoss 5 AS Book
"JBoss AS 5 development" reviews
Please share your feedback/review with other readers!
Banner
Dashboard
Advertise with Us
Banner
RSS Feed
Java EE 1.6 resources
Login
Sign here for the NewsLetter.



JBoss admin resources
Banner
Java EE 1.6 resources
JBoss howto

How to avoid the 50 seconds start up limit in Eclipse ?

JBoss recipe of the day ...
Read More

How can you solve deployment errors caused by large war/jar/ear files ?

jboss recipe of the day ...
Read More

How do you configure your .war to be deployed after your EJB ?

jboss recipe of the day ...
Read More
How to use Clob and Blob with EJB 3 ?
Written by Mark S.   

jboss recipe of the day

You can use @javax.persistence.Lob annotation to fetch Clob and Blob elements from the Database. Example:  

@Entity
public class SampleEntity implements Serializable
{
   private Long id;
   private Blob blob;
   private Clob clob;

   @Id @GeneratedValue(strategy=GenerationType.IDENTITY)
   public Long getId()
   {
      return id;
   }

   public void setId(Long id)
   {
      this.id = id;
   }

   @Lob @Basic(fetch = FetchType.EAGER)
   public Blob getBlob()
   {
      return blob;
   }

   public void setBlob(Blob blob)
   {
      this.blob = blob;
   }

   @Lob @Basic(fetch = FetchType.EAGER)
   public Clob getClob()
   {
      return clob;
   }

   public void setClob(Clob clob)
   {
      this.clob = clob;
   }


}

If you need to insert data in your Clob/Blob you can use Hibernate helper classes:

Blob:

org.hibernate.Hibernate.createBlob(byte[] bytes)
org.hibernate.Hibernate.createBlob(InputStream stream, int length)
org.hibernate.Hibernate.createBlob(InputStream stream)

Clob:

org.hibernate.Hibernate.createClob(String string)
org.hibernate.Hibernate.createClob(Reader reader, int length)


JBoss.org Search
Custom Search
Comments
Search
Only registered users can write comments!

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."