Re: COPY support in JDBC driver?

Поиск
Список
Период
Сортировка
От Michael Nacos
Тема Re: COPY support in JDBC driver?
Дата
Msg-id 407fa4640809240706s797ce2d0ic36b01d2e9558ab5@mail.gmail.com
обсуждение исходный текст
Ответ на Re: COPY support in JDBC driver?  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Ответы Re: COPY support in JDBC driver?  (Daniel Migowski <dmigowski@ikoffice.de>)
Re: COPY support in JDBC driver?  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
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.

It might also be that the driver shouldn't have to deal with things like that. It's a driver for connecting to a DBMS, not a backup-restore solution. But I cannot speak on behalf of anyone or anything, I'm pretty much an occasional pgsql-jdbc reader.

Michael

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Matt Magoffin"
Дата:
Сообщение: Re: very large result sets and ResultSet.relative() to jump to a desired offset
Следующее
От: Daniel Migowski
Дата:
Сообщение: Re: COPY support in JDBC driver?