Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
From: Pavel Bortnovskiy <pbortnovskiy@jefferies.com>
To: "Derby Discussion (derby-user@db.apache.org)" <derby-user@db.apache.org>
Subject: concurrent execution of Statement's .addBatch() and .executeBatch()
Thread-Topic: concurrent execution of Statement's .addBatch() and
 .executeBatch()
Thread-Index: Ac3T9NM1gxnz4P7rRAaed3CoOJklAA==
Date: Thu, 6 Dec 2012 21:03:57 +0000
Message-ID: 
 <619F13B2042F204E8E8E93D73870255809DEA2AB@EXJSQUSDAG04.ad.jefco.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: multipart/alternative;
	boundary="_000_619F13B2042F204E8E8E93D73870255809DEA2ABEXJSQUSDAG04adj_"
MIME-Version: 1.0

--_000_619F13B2042F204E8E8E93D73870255809DEA2ABEXJSQUSDAG04adj_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello:

Is it safe to call .addBatch() and .executeBatch() methods from multiple th=
reads on the same PreparedStatement?
Simple example: batching and executing a large number of the same statement=
s (with the same PreparedStatement) by using ExecutorService.

Thank you,
Pavel.

Jefferies archives and monitors outgoing and incoming e-mail. The contents =
of this email, including any attachments, are confidential to the ordinary =
user of the email address to which it was addressed. If you are not the add=
ressee of this email you may not copy, forward, disclose or otherwise use i=
t or any part of it in any form whatsoever. This email may be produced at t=
he request of regulators or in connection with civil litigation. Jefferies =
accepts no liability for any errors or omissions arising as a result of tra=
nsmission. Use by other than intended recipients is prohibited. In the Unit=
ed Kingdom, Jefferies operates as Jefferies International Limited; register=
ed in England: no. 1978621; registered office: Vintners Place, 68 Upper Tha=
mes Street, London EC4V 3BJ. Jefferies International Limited is authorised =
and regulated by the Financial Services Authority.

--_000_619F13B2042F204E8E8E93D73870255809DEA2ABEXJSQUSDAG04adj_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<style>
<!--
@font-face
	{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline}
span.EmailStyle17
	{font-family:"Calibri","sans-serif";
	color:windowtext}
.MsoChpDefault
	{font-family:"Calibri","sans-serif"}
@page WordSection1
	{margin:1.0in 1.0in 1.0in 1.0in}
div.WordSection1
	{}
-->
</style>
</head>
<body lang=3D"EN-US" link=3D"blue" vlink=3D"purple">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hello:</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">Is it safe to call .addBatch() and .executeBatch() m=
ethods from multiple threads on the same PreparedStatement?</p>
<p class=3D"MsoNormal">Simple example: batching and executing a large numbe=
r of the same statements (with the same PreparedStatement) by using Executo=
rService.</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">Thank you,</p>
<p class=3D"MsoNormal">Pavel.</p>
</div>
<h6><font color=3D"gray"><br>
Jefferies archives and monitors outgoing and incoming e-mail. The contents =
of this email, including any attachments, are confidential to the ordinary =
user of the email address to which it was addressed. If you are not the add=
ressee of this email you may not
 copy, forward, disclose or otherwise use it or any part of it in any form =
whatsoever. This email may be produced at the request of regulators or in c=
onnection with civil litigation. Jefferies accepts no liability for any err=
ors or omissions arising as a result
 of transmission. Use by other than intended recipients is prohibited. In t=
he United Kingdom, Jefferies operates as Jefferies International Limited; r=
egistered in England: no. 1978621; registered office: Vintners Place, 68 Up=
per Thames Street, London EC4V 3BJ.
 Jefferies International Limited is authorised and regulated by the Financi=
al Services Authority.
</font></h6>
</body>
</html>

--_000_619F13B2042F204E8E8E93D73870255809DEA2ABEXJSQUSDAG04adj_--