-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 On 17/11/15 23:04, Gerardo Blanco wrote:
Hi,
We are already using the COPY INTO bulk insert from Java via BufferedMCLWriter, as you suggest in your recipes book <https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/LoadingBul kData>,
and based in the example
<http://dev.monetdb.org/hg/MonetDB/file/tip/java/example/SQLcopyinto.j ava>
you provided.
I understood that each COPY INTO behaves as a single transaction. My question now is if there is a way to group two or more COPY INTO and make them behave as a single transaction.
Turn off autocommit using the appropriate JDBC call (setAutoCommit(false)). After you're done, call commit() (or rollback() if you don't want to commit).
Thank you
Gerardo
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEbBAEBCAAGBQJWTDYxAAoJEISMxT6LrWYgIZoH+M5rZrMLfq3Xst50nQqDlc6U bNLP9hmK6FN75TOYAHF4uNs9R8DZ5HswkvaqXY7xzeCU9AE6gBAeD2hT8YfW16El PqP5VxFiKlYqdS1cDjIetSQSVbb4yZP2SxF5D0q6Vi7ISM7jaTDM5syhNl66gfq/ uUYi5f9m1gMLc4kXfoDLFJdXVhpnve/mBLthzTcknNle8LBbc4gRNfpd064+eCID vz8d06l/p3TdMPETxJEG+5X0wwUe4nTRzsAmFe+itrKUPNPgiyCO56vyY0igcbmM wzJS61C+mQLQmTEHI6qXb946RndI4PeDiV4IMKQeNVRcZDy2nJT7t6k1e9qAKA== =Y6VP -----END PGP SIGNATURE-----