Eclipse Community Forums: EclipseLink

Home » Eclipse Projects » EclipseLink » Creating BLOBs

Thu, 20 September 2012 08:58

Eclipse User

Hi,

I'm trying to switch from Hibernate to EclipseLink. Now I'm facing the problem of creating BLOBs. With Hibernate I solved it this way:

import org.hibernate.LobHelper;
import org.hibernate.classic.Session;

...
  public Blob createBlob(InputStream inputStream, long length)
  {
    Session session = entityManager.unwrap(Session.class);
    LobHelper lobHelper = session.getLobHelper();
    Blob blob = lobHelper.createBlob(inputStream, length);
    return blob;
  }

Any hints how I can do this with EclipseLink? (I'm on an Oracle DB if this matters).

Jonny

Re: Creating BLOBs [message #923027 is a reply to message #917807]

Tue, 25 September 2012 10:45

Eclipse User

Normally you can just treat a BLOB as a byte array (byte[]).

If you want the JDBC Blob you can use the unwrap(java.sql.Connection.class) to get the JDBC Connection.

Re: Creating BLOBs [message #923049 is a reply to message #923027]

Tue, 25 September 2012 11:05

Eclipse User

Hi James,

thanks for your reply.

> Normally you can just treat a BLOB as a byte array (byte[]).
I have large files, so the streaming ability of BLOBs would come handy.

> If you want the JDBC Blob you can use the unwrap(java.sql.Connection.class) to get the JDBC Connection.
Do you have an example? My knowledge in this particlar field isn't too deep.

Thanks
Jonny

Re: Creating BLOBs [message #923063 is a reply to message #923049]

Tue, 25 September 2012 11:14

Eclipse User

Search for "JDBC BLOB examples", you basically just create a select Statement execute it to get the Blob and write into it.

Unless the file is extremely large, it would probably fit into memory as a byte[].

Re: Creating BLOBs [message #923082 is a reply to message #923063]

Tue, 25 September 2012 11:33

Eclipse User

Hi,

> Search for "JDBC BLOB examples", you basically just create a select Statement execute it to get the Blob and write into it.
Ok, I'll do that. Thanks. My hope was, that maybe EclipseLink provided such helper-classes as Hibernate.

Thanks
Jonny

Previous Topic:	AggregateCollectionMapping in DyanmicMapping
Next Topic:	Transform xml from one XSD version to another

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 18:33:37 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter