Re: Any chance to get support for createBlob? - Mailing list pgsql-jdbc

From Lachezar Dobrev
Subject Re: Any chance to get support for createBlob?
Date
Msg-id CA+xsaB0yd0O7FAWQQxEFQ_yYopxo__+oVDK6s0YzMZ9iW9ECVg@mail.gmail.com
Whole thread Raw
In response to Any chance to get support for createBlob?  (Christian Schmitt <c.schmitt@envisia.de>)
List pgsql-jdbc
  A temporary (until fixed) work-around is to execute:
    SELECT lo_create(0)
  And do a
    ResultSet.getBlob(1)

  I have not tried it, but this may also work with EntityManager:
   .createNativeQuery("SELECT lo_create(0)", Blob.class).getSingleResult();

  In PostgreSQL Blobs are not exactly the same thing as the JDBC Blobs, in JDBC it seems Blobs are functional values, while in PostgreSQL they're more like stand-alone objects that can and must be managed on their own.


2015-08-04 12:16 GMT+03:00 Christian Schmitt <c.schmitt@envisia.de>:
Hello, currently we are relying on the LargeObject API of PostgreSQL. Currently we access the Large Object API directly via unwrap of the Connection that comes from the Connection Pool, however there is also a createBLOB method of the Driver, but that doesn’t work as of JDBC 4.x - 9.4 Is there any chance that createBLOB will also be supported, like getBLOB?

pgsql-jdbc by date:

Previous
From: Christian Schmitt
Date:
Subject: Any chance to get support for createBlob?
Next
From: Vladimir Sitnikov
Date:
Subject: Re: Release schedule