Received: from iremia.univ-reunion.fr (iremia.univ-reunion.fr [194.199.73.10])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA86754
	for <pgsql-interfaces@postgresql.org>;
	Wed, 19 Apr 2000 05:45:59 -0400 (EDT)
	(envelope-from Guillaume.Rousse@univ-reunion.fr)
Received: from agathe (agathe.univ.run [10.10.2.24])
	by iremia.univ-reunion.fr (8.9.1a/jtpda-5.3.1/jlo(98)) with SMTP id
	NAA22949 for <pgsql-interfaces@postgresql.org>;
	Wed, 19 Apr 2000 13:45:24 +0400 (GMT+4)
From: Guillaume Rousse <Guillaume.Rousse@univ-reunion.fr>
Organization: Université de la Réunion
To: pgsql-interfaces@postgresql.org
Subject: Is this usage correct ?
Date: Wed, 19 Apr 2000 13:47:21 +0400
X-Mailer: KMail [version 1.0.28]
Content-Type: text/plain
MIME-Version: 1.0
Message-Id: <00041913520100.08718@agathe>
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200004/144

Is it correct to use a preparedStatement with no variable element, as this:
PreparedStatement stmp=conn.prepareStatement("delete from table where
oid="+oid);
stmt.excuteUpdate();

Or is it mandatory to use :
PreparedStatement stmp=conn.prepareStatement("delete from table where
oid=?");
stmt.setInt(1,oid);
stmt.excuteUpdate();

 -- 
Guillaume Rousse
Iremia - Université de la Réunion

Sleep doesn't exists. Just lack of cafeine.