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