[hibernate-issues] [Hibernate-JIRA] Commented: (JPA-8) No support for java.sql.Blob as a property

[Colbert Philippe (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/JPA-8?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=38928#action_38928 ] 

Colbert Philippe commented on JPA-8:
------------------------------------

A JDBC call instead of Hibernate/JPA call may be exactly what I need.  The part of my program that needs the functionality of java.sql.Blob will use JDBC calls instead of Hibernate calls.  That will workout.  Thanks for the help.

> No support for java.sql.Blob as a property
> ------------------------------------------
>
>                 Key: JPA-8
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/JPA-8
>             Project: Java Persistence API
>          Issue Type: Improvement
>            Reporter: Colbert Philippe
>
> My issue has to do with the Blob feature under JPA.  The JPA standard documentation says that : (I quote) "The Java types mappled to BLOB columns are byte[], Byte[], Serializable type, while char[], Character[] and String are mapped to CLOB".
> There is an important function missing in this statement.   This feature is given by JDBC and made available in Hibernate Persistence.   Why is it missing in JPA?   The way JPA is implemented all BLOB objects are either not-loaded into memory or completely loaded into memory.   What happens when an application only wants to work with only part of the  BLOB object, not the entire BLOB object?
> THE MISSING FEATURE:
> JDBC and Hibernate, allow for declaration of fields of type java.sql.Blob (interface).   This interface has special functionality that allows an application to load only part of a BLOB object (not the entire Blob object, which can be very big) .   Similarly, the Blob interface allows an application to write to only part of BLOB object (not the entire BLOB object).    These two important functions are lost in JPA!   That's a severe drawback!
> My question is:  Is there a way of going around the JPA standard and allow support for java.sql.Blob columns?
> Colbert

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira