COPY in Java?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: COPY in Java?
Date: 2016-07-18 20:34:37
Message-ID: b4c16a4a-a410-38c5-becc-fc5f1d10cc7c@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm looking at the JDBC documentation at
https://jdbc.postgresql.org/documentation/head/index.html and not
seeing any mention of COPY and any semantics for using COPY FROM STDIN
or COPY TO STDOUT... google has a link to a 404 page with some sort of
CopyManager

we may need to develop a specialized sort of sql loader to replace an
existing Oracle tool, we need to intercept bad rows and put them in an
exceptions file, while bulk loading the good data. I'm thinking we
batch N rows into COPY, and if a row faults, put it in the exception
pool then retry the batch without it. the source data needs to be
massaged before it can be fed to copy, so we can't use COPY FROM
filename ...

--
john r pierce, recycling bits in santa cruz

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Kellerer 2016-07-18 21:16:49 Re: COPY in Java?
Previous Message Gavin Flower 2016-07-18 19:42:32 Re: Slow performance updating CLOB data