Lob « Data Type « JPA Q&A

1. How to use Hibernate Annotations to add an index on a Lob / Clob / tinyblob    stackoverflow.com

I have a bean which I map to the database using Hibernate. I'm using Hibernate Annotations to indicate the mapping I want, and to create the indices. The thoroughly simplified code ...

2. Lob returns null using MySQL and jpa    stackoverflow.com

I'm trying to store a document as a BLOB in a java domain object that I have. I've seen several posts saying it can be done using @Lob for example http://www.java2s.com/Tutorial/Java/0355__JPA/MarkByteArrayFieldAsLob.htm So, ...

3. "could not initialize a collection" + @Lob + MSSQL    stackoverflow.com

When using Blob-fields in n-to-m-relations Hibernate and MSSQL are failing for some reason.

SQL Error: 421, SQLState: S0001
The image data type cannot be selected as DISTINCT because it is not comparable.
...
could not ...

4. Hibernate : Disabling contextual LOB creation as createClob() method threw error    stackoverflow.com

I am using using hibernate 3.5.6 with Oracle 10g. I am seeing the below exception during initialization but the application itself is working fine. What is the cause for this exception? ...

5. JBoss6 JPA: Entity with @Lob results in GenericJDBCException    stackoverflow.com

I have a simple EntityBean with a @Lob annotation. If I delete this annotation I get no errors on JBossAS 6.0.0.Final and MySQL5. But if I annotate it with @Lob (because ...

6. ORA-01460: unimplemented or unreasonable conversion requested using Hibernate @Lob    stackoverflow.com

I have a byte[] that I am persisting to a Lob as follows:

@Basic(fetch = FetchType.LAZY)
@Column(name = "ABF", length = Integer.MAX_VALUE)
@Lob
private byte[] abf;

7. JPA Using @Lob and lazyfetch option    coderanch.com

8. Hibernate and Blobs...@Lob does no good. Suggestions?    coderanch.com

All I want to do is store and retrieve an image file using Hibernate into a MySQL database. Getting this to work though is proving to be a bit of an issue. According to Hibernate Made Easy, I should be able to annotate the image field with @Lob. Well, I tried that and I still get the same exception when I ...

9. Need help with MySQL varbinary -> byte[] with @Lob    forum.hibernate.org

Dear community, First off, my appologies if this has been asked before, but I'm having severe difficulties accessing my varbinary field in a MySQL database: Field is defined as varbinary(16). Mapping to POJO byte[] decorated with @Lob annotation. Code is as follows: Code: @Entity @Table( name = "aim" ) @Cache( usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE ) public class AIM implements Serializable { ...

10. @Lob String -> Text (and not Longtext) in MySQL    forum.hibernate.org

Hello, I use Hibernate as persistence in Glassfish V3. When I annotate String properties as @Lob Hibernate creates "longtext" MySQL data type. I'd like to change this to the smaller "text" MySQL type... but not using the @Column annotation; I'd prefer to configure it via XML. What is the simplest way of doing it? Can I configure that mapping in the ...

11. could not initialize a collection + @Lob + MSSQL    forum.hibernate.org

12. Problem with PostgreSQL and @Lob byte[]    forum.hibernate.org

Hi, we have a problem with Hibernate 3.5.2 persisting the following entity: Code: import javax.persistence.*; @Entity public class Foo { @Id private int id; @Lob private byte[] someBytes = new byte[] { 'b', 'a', 'r', }; } With PostgreSQL 8.4 we get the following error: SQL Error: 0, SQLState: 42804, ...

13. @Lob on class member vs method, Hibernate 3.6    forum.hibernate.org

14. BLOB issue with org.hibernate.lob.SerializableBlob.length    forum.hibernate.org

Hi, I am working on the spring project which intgrates with Hibernate through IOC. Recently, we came across weird issue. Here is the exception, Hope you could provide us with some solution. java.sql.SQLRecoverableException: Closed Connection at oracle.sql.BLOB.getDBAccess(BLOB.java:1087) at oracle.sql.BLOB.length(BLOB.java:151) at org.hibernate.lob.SerializableBlob.length(Serializ ableBlob.java:31) Code: byte[] bytes = ttFileInfo.getFileContent().getBytes(1, (int)blob.length());IOUtils.copy(ttFileInfo.getFileContent().getBinaryStream(), out);Exception is getting thrown when any method is called upon Blob object after ...

15. MappingException:No persister for: net.sf.hibernate.lob.Blob    forum.hibernate.org

Below is the code for email class: public class Email implements Serializable { /** identifier field */ private long emailId; /** identifier field */ private Object emailattachment; /** full constructor */ public Email(long emailId Object emailattachment) { this.emailId = emailId; this.emailattachment = emailattachment; } /** default constructor */ public Email() { } public long getEmailId() { return this.emailId; } public void ...

16. Oracle LOB's the easy way returns null    forum.hibernate.org

Hibernate version:2.1.7 Mapping documents: [code] SEQ_MESSAGE [code] Code between sessionFactory.openSession() and session.close(): [code] Session session = HibernateSessionFactory.currentSession(); String querystring = "SELECT msg FROM Message as msg where messageid= :msgid"; Query query = session.createQuery(querystring); query.setLong("msgid", messageid.longValue()); List list = query.list(); if (list.size() > 0) { ...

17.  in a @Lob    forum.hibernate.org

18. @Lob private Object foo    forum.hibernate.org

19. Lazy @Lob (BLOB) not so lazy    forum.hibernate.org

Hi everyone, I am having a problem lazy-loading a Blob. This is a simplified (yet accurate) scenario of what I have: Code: class Parent { @OneToMany(fetch = LAZY, mappedBy="parent") private Set children; /// other properties, accessors and modifiers } class Child { @ManyToOne ...

20. Oracle Lobs and Hibernate (nth time...)    forum.hibernate.org

Hi, I'm using Hibernate 3.3 and Oracle 10g and I'm having two similar problems when working with lobs. First with a simple Lob property in the DB I can't automatically translate it to String in my Java code. I am using annotations and would like to avoid the use of XML config files. Is there any one-stop place for solving this? ...

21. @Lob column not updated?    forum.hibernate.org

Hi, I'm using hibernate (JPA) with spring. I have a field of type Blob that is marked with an @Lob annotation. This field causes a OID (postgresql) column to be created, but even though the field is set before peristing (insert/update) the column is always null. I am creating the Blob instance with "Hibernate.createBlob(inputStream)". Any ideas on why a Blob column ...

22. @LOB or path to file?    forum.hibernate.org

23. Problem with @Lob / Orcale Clob / Oracle Exception ORA-01461    forum.hibernate.org

Newbie Joined: Mon Aug 21, 2006 12:44 pm Posts: 12 Hello all, we have some kind of a problem with the following setup: Hibernate 3.2.0 Oracle 10.2.0.3 ojdbc-14 (10.2.0.4) using the following Annotation: Code: .... @Lob public String getWert() { return wert; } .... wich results ...