Return-Path: <frederic.gedin@Jaluna.COM>
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 21663 invoked from network); 14 Mar 2003 11:04:47 -0000
Received: from smtp.jaluna.com (212.11.48.245)
  by daedalus.apache.org with SMTP; 14 Mar 2003 11:04:47 -0000
Received: from mail.Jaluna.COM (mailspool [192.168.0.252])
	by smtp-gw (8.12.3/8.12.3) with ESMTP id h2E9vK0u013159
	for <torque-user@db.apache.org>; Fri, 14 Mar 2003 10:57:20 +0100
Received: from jaluna.com (dvorak [129.157.196.32])
	by mail.Jaluna.COM (8.12.3/8.12.3) with ESMTP id h2EB4rNh019092
	for <torque-user@db.apache.org>; Fri, 14 Mar 2003 12:04:54 +0100 (MET)
Message-ID: <3E71B71B.6050100@jaluna.com>
Date: Fri, 14 Mar 2003 12:03:55 +0100
From: Frederic Gedin <frederic.gedin@Jaluna.COM>
User-Agent: Mozilla/5.0 (X11; U; SunOS sun4u; en-US;
 rv:1.0.1) Gecko/20020920 Netscape/7.0
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: torque-user <torque-user@db.apache.org>
Subject: Criteria quizz
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hello


I am faced with a query problem:

To simplify the problem, I have three OM classes Task Worker, 
Assignment) which are generated from the following XML

  <table name="XP_TASK" javaName="Task">
    <column name       = "TASK_ID"
            primaryKey = "true"
            required   = "true"
            javaName   = "Id"
            type       = "INTEGER"/>
    <column name       = "TK_REFERENCE"
            javaName   = "Reference"
            required   = "true"
            type       = "VARCHAR"
            size       = "32" />
    <unique>
      <unique-column name="TK_REFERENCE" />
    </unique>
  </table>

  <table name="XP_WORKER" javaName="Worker">
    <column name       = "WORKER_ID"
            primaryKey = "true"
            required   = "true"
            javaName   = "Id"
            type       = "INTEGER"/>
    <column name       = "WK_FIRST_NAME"
            javaName   = "FirstName"
            required   = "true"
            type       = "VARCHAR"
            size       = "32" />
    <column name       = "WK_LAST_NAME"
            javaName   = "LastName"
            required   = "true"
            type       = "VARCHAR"
            size       = "32" />
    <column name       = "WK_INITIALS"
            javaName   = "Initials"
            required   = "true"
            type       = "VARCHAR"
            size       = "3" />
    <unique>
      <unique-column name="WK_FIRST_NAME" />
      <unique-column name="WK_LAST_NAME" />
    </unique>
    <unique>
      <unique-column name="WK_INITIALS" />
    </unique>
  </table>

  <table name="XP_ASSIGNMENT" javaName="Assignment">
    <column name       = "ASSIGNMENT_ID"
            primaryKey = "true"
            required   = "true"
            javaName   = "Id"
            type       = "INTEGER"/>
    <column name       = "TASK_ID"
            required   = "true"
            type       = "INTEGER"/>
    <column name       = "WORKER_ID"
            required   = "true"
            type       = "INTEGER"/>

    <foreign-key foreignTable="XP_TASK">
      <reference local="TASK_ID" foreign="TASK_ID"/>
    </foreign-key>
    <foreign-key foreignTable="XP_WORKER">
      <reference local="WORKER_ID" foreign="WORKER_ID"/>
    </foreign-key>
    <unique>
      <unique-column name="TASK_ID" />
      <unique-column name="WORKER_ID" />
    </unique>
   
  </table>


Now I would like to find all the tasks with no assigned worker.

How to do it?

Thank you for your help

Frederic