Hi  Jennie,

Thanks for your reply. please find my replies below:

Jennie Commented: Concurrent insertion into two different tables should work.  Do you have anymore information about why the COMMIT has failed?  Maybe the problem lies somewhere else than concurrent insertions?

Shiva's Comment: yes when I run two batch file by clicking it with difference of second ( as it takes few seconds to click the second batch file) and it runs perfectly, even I have tried running copy command directly on the monetsql client and on two clients in parallel it works perfectly. Is there some configuration change required on monetdb server?

Jennie Commented: - Have you tried the two COPY INTO separately?  To know if the problem is indeed caused by concurrent insertions.

Shiva's Comment:  When I am trying with two separate java program running concurrently its throwing same exception.

Jennie Comment: - Does the problem occur one-time, or every time you repeatedly execute your code?

Shiva's Comment: Yes the same error message is coming every time I run concurrent java programs with copy command in it ( here copying data to different tables ).

Any help will be really appreciated.

Thank you.

Shivanandan Gupta.

 

Date: Fri, 13 Mar 2015 15:36:23 +0800
From: Ying Zhang <Y.Zhang@cwi.nl>
To: Communication channel for MonetDB users <users-list@monetdb.org>
Cc: martin@monetdb.org
Subject: Re: Multi threaded (2 threads) Java program for copy command
Message-ID: <89A66109-B083-45A4-B59E-62B7AF0C9D86@cwi.nl>
Content-Type: text/plain; charset=us-ascii


> On Mar 12, 2015, at 19:27, Shivanandan Gupta <shivnandangupta@gmail.com> wrote:
>
> Hi Martin,
>
> Thanks for your prompt reply , I am using two different tables here but still  I am getting "Exception in thread "main" java.sql.SQLException: COMMIT: failed"   exception.

Hello Shivanandan,

Concurrent insertion into two different tables should work.  Do you have anymore information about why the COMMIT has failed?  Maybe the problem lies somewhere else than concurrent insertions?

- Have you tried the two COPY INTO separately?  To know if the problem is indeed caused by concurrent insertions.
- Does the problem occur one-time, or every time you repeatedly execute your code?

Regards,

Jennie

On Thu, Mar 12, 2015 at 4:57 PM, Shivanandan Gupta <shivnandangupta@gmail.com> wrote:

Hi Martin,

Thanks for your prompt reply , I am using two different tables here but still  I am getting "Exception in thread "main" java.sql.SQLException: COMMIT: failed"   exception.

Message: 2
Date: Thu, 12 Mar 2015 08:32:31 +0100
From: Martin Kersten <martin@monetdb.org>
To: users-list@monetdb.org
Subject: Re: Multi threaded (2 threads) Java program for copy command
        commit fails for one thread
Message-ID: <5501410F.1070508@monetdb.org>
Content-Type: text/plain; charset=windows-1252; format=flowed

Hi,

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