Return-Path: 
 <torque-user-return-3156-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 31802 invoked from network); 30 Sep 2003 10:05:53 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 30 Sep 2003 10:05:53 -0000
Received: (qmail 33619 invoked by uid 500); 30 Sep 2003 10:05:22 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 33545 invoked by uid 500); 30 Sep 2003 10:05:21 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 33515 invoked from network); 30 Sep 2003 10:05:20 -0000
Received: from unknown (HELO elkdc01.office.elkware.com) (62.109.88.105)
  by daedalus.apache.org with SMTP; 30 Sep 2003 10:05:20 -0000
Received: by elkdc01.office.elkware.com with Internet Mail Service
 (5.5.2448.0)
	id <T63RKCTP>; Tue, 30 Sep 2003 12:05:29 +0200
Message-ID: 
 <94A74941C5F70B4BA810C5E04F4A2B363A0E71@elkdc01.office.elkware.com>
From: "Usselmann, Vitali" <Usselmann@elkware.com>
To: 'Apache Torque Users List' <torque-user@db.apache.org>
Subject: AW: Why SQL statement is not terminated correctly?
Date: Tue, 30 Sep 2003 12:05:29 +0200
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2448.0)
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C3873A.60849E90"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

------_=_NextPart_001_01C3873A.60849E90
Content-Type: text/plain;
	charset="windows-1252"
Content-Transfer-Encoding: quoted-printable


Hi fumi,

I can not tell you the difference between your code fragments.
I solved my problems with Criteria.or() by using the Criterion
object instead of Criteria.or() as shown at the bottom of:
http://db.apache.org/torque/peers-howto.html

regards, Vitali




-----Urspr=FCngliche Nachricht-----
Von: fumi [mailto:fmhk1968@yahoo.co.jp]
Gesendet: Montag, 29. September 2003 20:08
An: torque-user@db.apache.org
Betreff: Why SQL statement is not terminated correctly?


Hi.

delete from emp where job =3D 'Engineer' or hiredate < '1970/04/01';

I wrote this code to execute above query.
------------------------------------------------------------------------=
----
-----
Criteria crit =3D new Criteria();
crit.add(EmpPeer.JOB, "Engineer");
crit.orDate(EmpPeer.HIREDATE, 1970, 4, 1, Criteria.LESS_THAN);
EmpPeer.doDelete(crit);
------------------------------------------------------------------------=
----
-----


ORA-00933(SQL statement is not terminated correctly) occured.
------------------------------------------------------------------------=
----
-----
java.sql.SQLException: ORA-00933:=20
        at com.workingdogs.village.DataSet.fetchRecords(Unknown Source)
        at com.workingdogs.village.TableDataSet.fetchRecords(Unknown =
Source)
        at com.workingdogs.village.TableDataSet.fetchRecords(Unknown =
Source)
        at com.workingdogs.village.TableDataSet.fetchRecords(Unknown =
Source)
        at org.apache.torque.util.BasePeer.doDelete(BasePeer.java:573)
        at employee.om.BaseEmpPeer.doDelete(BaseEmpPeer.jav
a:525)
        at employee.sample.TorqueDeleteSample.doIt(TorqueDe
leteSample.java:53)
        at employee.sample.TorqueDeleteSample.main(TorqueDe
leteSample.java:16)
rethrown as org.apache.torque.TorqueException: ORA-00933:=20
        at
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:23
6)
        at org.apache.torque.util.BasePeer.doDelete(BasePeer.java:587)
        at employee.om.BaseEmpPeer.doDelete(BaseEmpPeer.jav
a:525)
        at employee.sample.TorqueDeleteSample.doIt(TorqueDe
leteSample.java:53)
        at employee.sample.TorqueDeleteSample.main(TorqueDe
leteSample.java:16)
Caused by: java.sql.SQLException: ORA-00933:
        at com.workingdogs.village.DataSet.fetchRecords(Unknown Source)
        at com.workingdogs.village.TableDataSet.fetchRecords(Unknown =
Source)
        at com.workingdogs.village.TableDataSet.fetchRecords(Unknown =
Source)
        at com.workingdogs.village.TableDataSet.fetchRecords(Unknown =
Source)
        at org.apache.torque.util.BasePeer.doDelete(BasePeer.java:573)
        ... 3 more
------------------------------------------------------------------------=
----
-----

But i executed next code and succeed.
------------------------------------------------------------------------=
----
-----
Criteria crit =3D new Criteria();
crit.addDate(EmpPeer.HIREDATE, 1970, 4, 1, Criteria.LESS_THAN);
crit.or(EmpPeer.JOB, "Engineer");
EmpPeer.doDelete(crit);
------------------------------------------------------------------------=
----
-----

What difference between these code fragments?

[My Environment]
Oracle8i 8.1.7
Torque 3.1
JSDK1.4.2

Thanx, in advance.



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org




------_=_NextPart_001_01C3873A.60849E90--