Mercurial > hg > monetdb-java
diff release.txt @ 577:6ab9168ef8e1 onclient
Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
author | Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
---|---|
date | Thu, 14 Oct 2021 01:31:03 +0200 (2021-10-13) |
parents | daf6a3b828f9 |
children | 1c5e59760ff8 |
line wrap: on
line diff
--- a/release.txt +++ b/release.txt @@ -185,9 +185,29 @@ The following java.sql.* interfaces are * java.sql.SQLXML * java.sql.Struct -Since version VERSION_NUMBER, the MonetDB JDBC driver has support for the -ON CLIENT clause of the COPY statement. You can register callback to provide -data when the server asks for it, see onclient.txt for more information. + +Since release 3.2 (monetdb-jdbc-3.2.jre8.jar), the MonetDB JDBC driver has +support for the ON CLIENT clause of the COPY statement. To make use of +this functionality you must register handlers for upload and download of data. +The MonetConnection class has been extended with 2 methods: + public void setUploadHandler(UploadHandler uploadHandler) + public void setDownloadHandler(DownloadHandler downloadHandler) +The API has been extended with interfaces and utility class: + public interface org.monetdb.jdbc.MonetConnection.UploadHandler + public interface org.monetdb.jdbc.MonetConnection.DownloadHandler + public class org.monetdb.util.FileTransferHandler + which implements MonetConnection.UploadHandler, MonetConnection.DownloadHandler +See onclient.txt for more information on how to use these from Java. + +The JdbcClient application has also been extended to support COPY ... +ON CLIENT functionality. However for security reasons you must provide an +explicit new startup argument + --csvdir "/path/to/csvdatafiles" +or on MS Windows + --csvdir "C:\\path\\to\\csvdatafiles" +in order to allow the JdbcClient to down/up load data to/from local csv files. +All csv data in the local files must be UTF-8 encoded and uncompressed. + Notes and Tips for Java Programmers using MonetDB JDBC driver: - Close JDBC ResultSet, Statement, PreparedStatement, CallableStatement and @@ -251,3 +271,4 @@ Warning: Note: as of Febr 2021 (monetdb-jdbc-3.0.jre8.jar) we compile all the java sources to target: Java SE 8 (profile compact2), so you need a JRE/JDK JVM of version 8 or higher to use it. +