Hi,

Yes. Insertion into the same table would be invalidated due to the transaction semantics. See https://www.monetdb.org/Documentation/Manuals/SQLreference/Transactions

On 12/03/15 08:18, Shivanandan Gupta wrote:

Hi All,

I am evaluating monetdb for our dwh and I am trying to load data from two different csv file to 2 different tables using multi-threaded java program in parallel, for one thread the load is successful and other one is failing with exception given below.

Exception in thread "main" java.sql.SQLException: COMMIT: failed at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2535) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:2284) at nl.cwi.monetdb.jdbc.MonetConnection.commit(MonetConnection.java:374) at connect_monetdb.runETL(connect_monetdb.java:78) at connect_monetdb.main(connect_monetdb.java:14)

command used is :

String csql = "copy into s_asset_"+filename+" from '"+filepath+""+ filename +".csv' using delimiters',';"; st.execute(csql); con.commit();

I am using monetdb jdbc driver and monetdb server is also on the same machine.

Any help will be really great.

Thank you.

Cheers, Shivanandan Gupta

---

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list