Quick Links

Experimental COPY Helper class

Lists:	pgsql-jdbc

From:	Markus Schaber <schabios(at)logi-track(dot)com>
To:	pgsql-jdbc(at)postgresql(dot)org
Subject:	COPY Support Patch - actualized version?
Date:	2004-06-24 08:08:53
Message-ID:	20040624100853.50d02c71@kingfisher.intern.logi-track.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-jdbc

Hi,

I'm currently trying to apply the COPY patch from
http://archives.postgresql.org/pgsql-jdbc/2003-12/msg00186.php but it
seems that it doesn't work cleanly.

Does someone have an updated version ready? I'm currently trying to dig
into the code myself, but reinventing the wheel is not my primary
pleasure :-)

Thanks,
Markus

From:	Kris Jurka <books(at)ejurka(dot)com>
To:	Markus Schaber <schabios(at)logi-track(dot)com>
Cc:	pgsql-jdbc(at)postgresql(dot)org
Subject:	Re: COPY Support Patch - actualized version?
Date:	2004-06-24 09:26:07
Message-ID:	Pine.BSO.4.56.0406240421150.29880@leary.csoft.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-jdbc

On Thu, 24 Jun 2004, Markus Schaber wrote:

> Hi,
>
> I'm currently trying to apply the COPY patch from
> http://archives.postgresql.org/pgsql-jdbc/2003-12/msg00186.php but it
> seems that it doesn't work cleanly.
>
> Does someone have an updated version ready? I'm currently trying to dig
> into the code myself, but reinventing the wheel is not my primary
> pleasure :-)
>

Steve Wampler claimed to have it working recently here:

http://archives.postgresql.org/pgsql-jdbc/2004-06/msg00034.php

I imagine he patched the 7.4 branch driver instead of the cvs version.
Merging this with the latest cvs code will be a waste of time as a monster
patch implementing full V3 protocol support will soon be applied and it
will need to be remerged. Once this patch is settled in I'll produce an
updated copy patch.

Kris Jurka

From:	Markus Schaber <schabios(at)logi-track(dot)com>
To:
Cc:	pgsql-jdbc(at)postgresql(dot)org
Subject:	Experimental COPY Helper class
Date:	2004-06-24 16:44:07
Message-ID:	20040624184407.7278de00@kingfisher.intern.logi-track.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-jdbc

Hi @all,

I attached a little utility class that may be of use for all those "COPY
table FROM" users.

It may be used with a ByteArrayOutputStream when the amount of data is
small enough to get buffered in RAM, with a PipedOutputStream for fully
featured Piping of Data (when your pgjdbc version supports it) or even
with a FileOutputStream when your Java App just creates feed for psql.

Currently, it's rather untested and not well commented, but this will
improve, especially when lots of constructive feedback reaches my inbox
:-)

Happy Hacking,
Markus Schaber

Attachment	Content-Type	Size
SQLCopyWriteHelper.java	text/x-java	3.6 KB