Re: postgres : storing binary data using OID

2009-03-17 Thread andiqo
Thanks a lot for your help Milosz! Miłosz Tylenda wrote: > > Hi Andiqo, > > That "compatible" property seems promising. I once used it when needed to > tweak how String parameters are sent to PostgreSQL. > > I am not sure what you mean by "directly specify properties". If I want to > specify

Re: postgres : storing binary data using OID

2009-03-17 Thread Miłosz Tylenda
Hi Andiqo, That "compatible" property seems promising. I once used it when needed to tweak how String parameters are sent to PostgreSQL. I am not sure what you mean by "directly specify properties". If I want to specify a JDBC driver property, usually I add it to the database URL or configure the

Re: postgres : storing binary data using OID

2009-03-16 Thread andiqo
Hi Milosz, LOB support using InputStream looks great in OpenJpa. But I would like to conform to JPA-2 specifications... Is there a way to directly specify JDBC connection properties with OpenJPA, as 'compatible' parameter could do the trick (http://jdbc.postgresql.org/documentation/83/connect.ht

Re: postgres : storing binary data using OID

2009-03-16 Thread Miłosz Tylenda
Andiqo, You could try using the so called streaming LOB support. However, this needs using InsputStream instead of byte[] I think. There is a section on it in the manual [1]. Also, there is a test case which can help you too [2]. Greetings, Milosz [1] http://openjpa.apache.org/builds/latest/d

postgres : storing binary data using OID

2009-03-15 Thread andiqo
Dear all, I am trying to persist large binary object using PostgreSQL database. With this mapping, no problem but performance are not optimum for large blobs: // Object: @Basic(fetch = FetchType.LAZY) @Column(name = "DATA") private byte[] data; // Database: CREATE TABLE SPLITBLOBPART (ID BIGSERI