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
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? |