Mailing-List: contact user-help@empire-db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@empire-db.apache.org
MIME-Version: 1.0
From: Daniel Weidele <daniel.weidele@gmail.com>
Date: Fri, 15 Jul 2016 14:01:58 -0400
Message-ID: <CAFGS3ACyrVLTyvM8c0OAJGZbdGk6g7Ajyv1k6qKq9BbGBvLBxQ@mail.gmail.com>
Subject: Prepared Statements
To: user@empire-db.apache.org
Content-Type: multipart/alternative; boundary=001a113eccd0399c280537b06ae0
archived-at: Fri, 15 Jul 2016 18:02:05 -0000

--001a113eccd0399c280537b06ae0
Content-Type: text/plain; charset=UTF-8

Dear group,

what is the use of the prepared statements mechanism when, as it appears to
me, the prepared statement is recreated with every call of
"db.executeInsert(cmd, conn);"?

In particular DBDatabaseDriver.class:541 to DBDatabaseDriver.class:547 do
not "reuse" any prepared statement, but a new prepared statement is
requested from the connection.

Am I using it correctly?

DBCmdParam myParam = myCmd.addParam(...);
for (String value : myValues)
{
 myParam.setValue(value);
 db.executeInsert(myCmd, myConn);
}

Thanks for help,
Daniel

--001a113eccd0399c280537b06ae0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div><div><div>Dear group,<br><br></div>what is the u=
se of the prepared statements mechanism when, as it appears to me, the prep=
ared statement is recreated with every call of &quot;db.executeInsert(cmd, =
conn);&quot;?<br><br></div>In particular DBDatabaseDriver.class:541 to DBDa=
tabaseDriver.class:547 do not &quot;reuse&quot; any prepared statement, but=
 a new prepared statement is requested from the connection.<br><br></div>Am=
 I using it correctly?<br><br>DBCmdParam myParam =3D myCmd.addParam(...);<b=
r>for (String value : myValues)<br>{<br>=C2=A0myParam.setValue(value);<br>=
=C2=A0db.executeInsert(myCmd, myConn);<br>}<br><br></div><div>Thanks for he=
lp,<br></div><div>Daniel<br></div></div>

--001a113eccd0399c280537b06ae0--