Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Blob and PostgreSQL
Lets say you get a LOB using an OID. Does the connection you initially read it with need to stay open in order to get the stream? (If so, that will be a challenge given the constraints of the JPA world). If not, what code would you write to get the stream? Do you keep the stream open for a long period of time? Do you need a connection for the duration of the time that you use it? 

On 24/06/2013 3:33 PM, Andreas Joseph Krogh wrote:

På mandag 24. juni 2013 kl. 16:23:15, skrev Tom Ware <tom.ware@xxxxxxxxxx
<mailto:tom.ware@xxxxxxxxxx>>:

    There is quite alot of functionality that can be overridden through subclassing
    our various database platforms.

    You should be able to override buildFieldTypes() in PostgreSQLPlatform to change
    what DDL generation will generate.

    How is writing to a LOB using OID different than writing to a bytea different in
    JDBC?

I don't understand the question, what do you mean? For clarity; What I'm after
is to use Blob as a JPA-field (and call getBinaryStream to get the data) and be
sure the underlying framework (EL) uses streams (not byte-arrays), and having it
work with PG's OID type.
--
Andreas Joseph Krogh <andreak@xxxxxxxxxxxx>      mob: +47 909 56 963
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no
Public key: http://home.officenet.no/~andreak/public_key.asc


_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

Back to the top