Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of anoopkumarv@gmail.com
 designates 209.85.220.220 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:from:date:message-id:subject:to:content-type;
        b=YGhCCVdWrTLGIpHER9r9nikOUU/3vPxyiC7O7vspSusg1NB8CVUTneyEERol4bay2u
         Xup8a47bKpAxbr2SILP16nmCFSTAoboMTnnQWjUseV8mhS8B0y/4K2BmrZPkussrHqhB
         JDxrTwxC91cF5Evime3fWtfN3np+klNvR8Pzc=
MIME-Version: 1.0
From: Anoop kumar V <anoopkumarv@gmail.com>
Date: Sat, 22 Aug 2009 23:54:26 -0400
Message-ID: <ac0203f60908222054qa0a69a2ve47e5f0d49c6bb15@mail.gmail.com>
Subject: Newbie question: Update table that has no key / id
To: user-java@ibatis.apache.org
Content-Type: multipart/alternative; boundary=0016e65aedd8e8241d0471c70f78

--0016e65aedd8e8241d0471c70f78
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi,

I am facing an issue updating a table that is part of a crappy datamodel.
The table has no primary key. It has 3 columns user, region and division.

My issue is when a user wants to modify a particular record, I am not sure
how to pass the parameters...

  <update id="updateUserApprover" parameterClass="ad.UserApprover">
    update user_approvers set region_name = #region:VARCHAR#,
                      division_name = #division:VARCHAR#,
    where user = #user:VARCHAR#
    and region = #region:VARCHAR#
    and division=#division:VARCHAR#
  </update>

I know the above is hopelessly wrong, the where clause parameters is the
same as the update values and this will never find the record and so will
not update anything.

I think there is a unique constraint or composite key set up for all 3
columns. I am using Oracle in production and mysql on my laptop if that
makes a difference. Would using rownum or something make some sort of
difference?


Thanks,
Anoop

--0016e65aedd8e8241d0471c70f78
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,<br><br>I am facing an issue updating a table that is part of a crappy d=
atamodel. The table has no primary key. It has 3 columns user, region and d=
ivision.<br><br>My issue is when a user wants to modify a particular record=
, I am not sure how to pass the parameters...<br>

<br>=A0 &lt;update id=3D&quot;updateUserApprover&quot; parameterClass=3D&qu=
ot;ad.UserApprover&quot;&gt;<br>=A0=A0=A0 update user_approvers set region_=
name =3D #region:VARCHAR#,<br>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0 division_name =3D #division:VARCHAR#,<br>

=A0=A0=A0 where user =3D #user:VARCHAR#<br>=A0=A0=A0 and region =3D #region=
:VARCHAR#<br>=A0=A0=A0 and division=3D#division:VARCHAR#<br>=A0 &lt;/update=
&gt;<br><br>I know the above is hopelessly wrong, the where clause paramete=
rs is the same as the update values and this will never find the record and=
 so will not update anything.<br>

<br>I think there is a unique constraint or composite key set up for all 3 =
columns. I am using Oracle in production and mysql on my laptop if that mak=
es a difference. Would using rownum or something make some sort of differen=
ce?<br>

<br clear=3D"all"><br>Thanks,<br>Anoop<br>

--0016e65aedd8e8241d0471c70f78--