Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

jdbc 8 blob not implemented?

0 views
Skip to first unread message

aditya Kulkarni

unread,
Sep 15, 2004, 9:16:23 AM9/15/04
to
Hi,

I downloaded the pgjdbc 8.0 driver, and when i tried using the
getBlob() on a result set, it throws a NotImplemented Exception

I looked at the code, and it looks like none of the functionality has
been implemented. Is this a server limitation or such thing, or is it
work that just needs to be done?

The real problem is that i can't use the LargeObject API for Blob's,
only bytea. I understand that i can use a getBinaryStream on a result
set, but i want to know what the problem with getBlob is

Thanks in advance
--
Aditya Kulkarni

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Kris Jurka

unread,
Sep 15, 2004, 6:52:49 PM9/15/04
to

On Wed, 15 Sep 2004, aditya Kulkarni wrote:

> Hi,
>
> I downloaded the pgjdbc 8.0 driver, and when i tried using the
> getBlob() on a result set, it throws a NotImplemented Exception

Just calling getBlob gives the exception? I don't see what code path that
could be coming from, what's the whole stacktrace?

> I looked at the code, and it looks like none of the functionality has
> been implemented. Is this a server limitation or such thing, or is it
> work that just needs to be done?

I believe the reading methods have been implements while the writing
and positioning methods have not. The writing methods seem easy to
implement, but the positioning methods seem like they would require
server support to be efficient.

> The real problem is that i can't use the LargeObject API for Blob's,
> only bytea. I understand that i can use a getBinaryStream on a result
> set, but i want to know what the problem with getBlob is

bytea really isn't a LOB type, it doesn't have any real support for
partial reads, writes, streaming or the normal LOB like things.

Kris Jurka

0 new messages