JDBC - how to set autocommit in url as on option
Hello, We are using the JDBC driver from KETTLE (http://kettle.pentaho.com) tool. I could not find an option how to tell the driver that my connections are autocommit. I tried to add option autocommit=true. The tool added the opton at the end of the JDBC URL as follows jdbc:monetdb://172.26.123.14:50000/zkdev1;autocommit=true . But it failed with error that it could not find database "zkdev1;autocommit=true". Thank you for your help. Radovan
Radovan, Without knowing any technical details, the document says "MonetDB, by default, runs in auto-commit mode" https://www.monetdb.org/book/export/html/340 cheers, -----Original Message----- From: users-list [mailto:users-list-bounces+ahmad.hassan=sap.com@monetdb.org] On Behalf Of Radovan Bicište Sent: 21 March 2014 06:57 To: Communication channel for MonetDB users Subject: JDBC - how to set autocommit in url as on option Hello, We are using the JDBC driver from KETTLE (http://kettle.pentaho.com) tool. I could not find an option how to tell the driver that my connections are autocommit. I tried to add option autocommit=true. The tool added the opton at the end of the JDBC URL as follows jdbc:monetdb://172.26.123.14:50000/zkdev1;autocommit=true . But it failed with error that it could not find database "zkdev1;autocommit=true". Thank you for your help. Radovan _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi there, Also I wanted to point out, in PDI under the bulk loader step category there is a bulk loader step that is designed especially for MonetDB. Auto commit is on by default. Do make sure you download MonetDB 10.2 JDBC driver from the MonetDB website. Don't know why it's always hanging out separately. I have to search box or Google it every time because it is not clearly listed on the MonetDB website. Hope that gets you further along. Brandon Sent from my iPhone
On Mar 21, 2014, at 1:57 AM, Radovan Bičiště
wrote: Hello, We are using the JDBC driver from KETTLE (http://kettle.pentaho.com) tool. I could not find an option how to tell the driver that my connections are autocommit. I tried to add option autocommit=true. The tool added the opton at the end of the JDBC URL as follows jdbc:monetdb://172.26.123.14:50000/zkdev1;autocommit=true . But it failed with error that it could not find database "zkdev1;autocommit=true". Thank you for your help.
Radovan _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Brandon Jackson
-
Hassan, Ahmad
-
Radovan Bičiště