Re: Will Connection.createBlob be implemented any time soon?

From: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Will Connection.createBlob be implemented any time soon?
Date: 2014-01-19 14:07:56
Message-ID: OfficeNetEmail.46.d375005b1e5e082d.143aacfb5b4@prod2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

På søndag 19. januar 2014 kl. 14:58:00, skrev Thomas Kellerer <
spam_eater(at)gmx(dot)net <mailto:spam_eater(at)gmx(dot)net>>: Andreas Joseph Krogh wrote on
19.01.2014 14:41:
>     Using PreparedStatement.setBinaryStream() works without problems.
>     You don't even need the intermediate Blob instance:
>
>     PreparedStatement pstmt = con.createStatement("....");
>
>     pstmt.setBinaryStream(1, is);
>         or
>     pstmt.setBinaryStream(1, is, length);  // if the length is known
>
> I'm using JPA and need to be able to set a (new) Blob as a field, like this:

Ah! The joys of database obfuscation layers.
Sorry, I can't help you with that.

> val b = con.createBlob()
> val os = b.setBinaryStream(1)
> IOUtils.copyLarge(is, os, new Array[Byte](1024 * 1024))
> myEntity.setData(b)

The above code (val b = ...) does not look like Java. What exactly is that?  
Scala, but for this case it is irrelevant.   Is there any reason why
Connection.createBlob isn't implemented in the official driver? The NG-driver
(https://github.com/impossibl/pgjdbc-ng) has it and it works quite well. I am,
however, experiencing some issues in my app and want to test it with the
official driver, but am unable to because it doesn't support createBlob, which
my app needs.   Is it possible to fund development of it and have it merged
into the official driver?   --
Andreas Joseph Krogh <andreak(at)officenet(dot)no>      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  

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Frederik Wiers 2014-01-20 00:37:51 StringBuffer vs. StringBuilder
Previous Message Thomas Kellerer 2014-01-19 13:58:00 Re: Will Connection.createBlob be implemented any time soon?