Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
Received-SPF: pass (hermes.apache.org: domain of gthought@gmail.com designates
 64.233.170.203 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=W4sCzuqn3nGQusvEEFLGjqGVMMD2J9feo/M5cZSsIrcj1aCmb5FF3c44+mLSNBnrMUAhY0cy9oPb2CHeEH6q43U3T/1aXkMLjxKrSyymFc1q0kpeFHORsueZFkC3VJ7CKxquwsYeEhpsD1RLJTKXLGk/QJcopEpvBLDckHxRolM=
Message-ID: <bf2767430504271236699d671d@mail.gmail.com>
Date: Wed, 27 Apr 2005 14:36:53 -0500
From: Gregg D Bolinger <gthought@gmail.com>
Reply-To: Gregg D Bolinger <gthought@gmail.com>
To: ibatis-user-java@incubator.apache.org
Subject: Mapping Help
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I need a bit of help with setting up a mapping file or 2.  I have a
POJO called Filter.  I use this to store options from the user as for
search criteria.  I have a database that relates to this filter.

The problem I am having is I have 2 List properties that are part of
Filter.  1 is Status and the other is Users.  I have both the Status
class and User class mapped with iBatis.  No problem there.

I have created 2 more tables.  t_filter_status and
t_filter_assignment.  t_filter_status stores a filterId and a
statusId.  t_filter_assignment also holds a filterId and a userId.

I need to create the Filter mapping in iBatis so that when I save the
Filter object to the database, I also create records in the
t_filter_status and t_filter_assingment tables.  This may just be a
matter of getting the SQL right but I am not 100% sure if I am even
thinking about this the right way.  Here is an example

t_filter
------------------------------------------------------
- 1 - filtername - 04/24/05 - 04/25/05 -
------------------------------------------------------

t_filter_status
-----------
- 1 - 2 -
- 1 - 0 -
- 1 - 1 -
----------

t_filter_assignment
-----------------
- 1 - 9715 -
- 1 - 8765 -
----------------

I hope this makes some sense.  If you need more information just let me kno=
w.

Thanks

Gregg