Skip site navigation (1) Skip section navigation (2)

Re: COPY support in JDBC driver?

From: Daniel Migowski <dmigowski(at)ikoffice(dot)de>
To: Michael Nacos <m(dot)nacos(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: COPY support in JDBC driver?
Date: 2008-09-24 14:41:53
Message-ID: 48DA51B1.8090204@ikoffice.de (view raw or flat)
Thread:
Lists: pgsql-jdbc
Michael Nacos schrieb:
> Hi Mark,
>
> if you want COPY support from the JDBC driver just for performance 
> reasons, you should probably also consider using the driver's batch 
> mode. Please have a look at the following links:
>
> http://archives.postgresql.org/pgsql-jdbc/2007-04/msg00076.php
> http://freeyourtech.wordpress.com/2008/07/15/using-postgresql-jdbc-for-bulk-updates-batch-size-vs-performance/
>
> Encoding is a serious consideration. While testing pgBee, I ran into 
> problems inserting codepage 1252 files into a SQL_ASCII database, 
> because of character mismatches. In your Java application, you may 
> specify a particular charset for reading the input files. I haven't 
> used the patch, but if support for the COPY operation is to be 
> included in the driver, please make sure the driver handles such 
> things with care.
AFAIK is UTF-8 the only encoding which the driver supports, anyway. And 
the native Java encoding, too. In my opinion the API should either 
support Writers and Readers (instead of Output- and InputStream), so the 
application has to take care for the encoding itself, or the API should 
encapsulate setting an arbitrary encoding on the server side before the 
copy command, and return to the default encoding directly afterwards.

Please note that this might create conflicts with error mesages and 
notices thrown during the copy command.

With best regards,
Daniel Migowski

In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2008-09-24 18:24:16
Subject: Re: COPY support in JDBC driver?
Previous:From: Michael NacosDate: 2008-09-24 14:06:40
Subject: Re: COPY support in JDBC driver?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group