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 selva.andre@gmail.com
 designates 209.85.218.215 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=VoeY+tWElsTiVe1Iy+dxrJ5h0BPfLAJLCZkwBOAyulIO6BGhkRcbuTeuvcbnZqfoD1
         g+G05gqJZ3Xdlnr/w8N+dQz7qE6twuckFADwhVRyUSYMwDdjs3RKjRVV/CRzVQ8HF+ma
         QExGs+pNLW5Q0NFdSrRy0iQ6bp8AG4audLEB8=
MIME-Version: 1.0
Date: Thu, 22 Apr 2010 09:30:49 +0200
Message-ID: <p2jac6d98521004220030w2f89f918ze1a88eaf8c78a71c@mail.gmail.com>
Subject: Problem with id mapping to IDENTITY in HSQLDB
From: Andrea Selva <selva.andre@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: multipart/alternative; boundary=0016364c74df35e4200484ce4a7b

--0016364c74df35e4200484ce4a7b
Content-Type: text/plain; charset=ISO-8859-1

Hi list,
i've a trouble with IDENTITY in hsqldb and id attribute in a resulMap:

--- Activity DDL ----
DROP TABLE Activity;

CREATE TABLE Activity (
    idActivity IDENTITY,
    name varchar(30) not null,
    description varchar(100) null,
    constraint pk_activity primary key (idActivity)
);

----ResultMap ---------
<resultMap id="activityResultMap" type="Activity">
    <id property="id" column="idActivity" />
    <result property="name" column="name" />
    <result property="description" column="description" />
</resultMap>

NB Activity is an alias for the class i map

--- This is my mapper annotated interface -----
public interface ActivityMapper {
    @Select("SELECT * FROM Activity")
    List<Activity> listAll();
}


--- My domain class ----
public class Activity implements Serializable {
    private static final long serialVersionUID = -4735861071294335763L;
    private int id = -55; //only for test
    private String name;
    private String description;

    public Activity(String name, String description) {
        this.name = name;
        this.description = description;
    }

    public Activity() {}

    public int getId() {
        return id;
    }

    public String getDescription() {
        return description;
    }

    public String getName() {
        return name;
    }

    public int getDays() {
        return days;
    }
}


--- This is the test incriminate test code ---

@Test
    public void testAllActivities() throws SQLException, IOException {
        Activity activity1 = new Activity("Fake Name", "Fake description");
        Activity activity2 = new Activity("Fake Name 2", "Second fake
description");
        IActivityDAO dao = new IBatisActivityDAO();
        dao.addNewActivity(activity1);
        dao.addNewActivity(activity2);

        DBUtils.printQueryResults("SELECT * FROM Activity");

        Reader reader =
Resources.getResourceAsReader("org/dna/metronomo/persistence/configuration.xml");
        SqlSessionFactory m_sqlSessionFactory = new
SqlSessionFactoryBuilder().build(reader);
        ActivityMapper mapper =
m_sqlSessionFactory.openSession().getMapper(ActivityMapper.class);
        List<Activity> activities = mapper.listAll();
        assertEquals(2, activities.size());
        assertEquals(activity1.getName(), activities.get(0).getName());
        assertEquals(0, activities.get(0).getId());
        assertEquals(activity2.getName(), activities.get(1).getName());
        assertEquals(1, activities.get(1).getId());
    }

When I load the list of activities I find correctly populated all attributes
except the key attribute, the id, i discover that the mapper doesn't fill it
with the correct value from DB (a SELECT on the DB shot that the data are
presents) but put the -55 default value that I set.
I can't understand why IBatis 3 doesn't corretly map the key IDENTITY column
to the java attribute.
The iBAtis3 svn rev I use is r928229.
Many thanks in advance for any usefull hint.
 Best regards
  Andrea Selva

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

Hi list,<br>i&#39;ve a trouble with IDENTITY in hsqldb and id attribute in =
a resulMap:<br><br>--- Activity DDL ----<br>DROP TABLE Activity;<br><br>CRE=
ATE TABLE Activity (<br>=A0=A0=A0 idActivity IDENTITY,<br>=A0=A0=A0 name va=
rchar(30) not null,<br>
=A0=A0=A0 description varchar(100) null,<br>=A0=A0=A0 constraint pk_activit=
y primary key (idActivity)<br>);<br><br>----ResultMap ---------<br>&lt;resu=
ltMap id=3D&quot;activityResultMap&quot; type=3D&quot;Activity&quot;&gt;<br=
>=A0=A0=A0 &lt;id property=3D&quot;id&quot; column=3D&quot;idActivity&quot;=
 /&gt;<br>
=A0=A0=A0 &lt;result property=3D&quot;name&quot; column=3D&quot;name&quot; =
/&gt;<br>=A0=A0=A0 &lt;result property=3D&quot;description&quot; column=3D&=
quot;description&quot; /&gt;<br>&lt;/resultMap&gt;<br><br>NB Activity is an=
 alias for the class i map<br>
<br>--- This is my mapper annotated interface -----<br>public interface Act=
ivityMapper {<br>=A0=A0=A0 @Select(&quot;SELECT * FROM Activity&quot;)<br>=
=A0=A0=A0 List&lt;Activity&gt; listAll();<br>}<br><br><br>--- My domain cla=
ss ----<br>
public class Activity implements Serializable {<br>=A0=A0=A0 private static=
 final long serialVersionUID =3D -4735861071294335763L;<br>=A0=A0=A0 privat=
e int id =3D -55; //only for test<br>=A0=A0=A0 private String name;<br>=A0=
=A0=A0 private String description;<br>
<br>=A0=A0=A0 public Activity(String name, String description) {<br>=A0=A0=
=A0 =A0=A0=A0 <a href=3D"http://this.name">this.name</a> =3D name;<br>=A0=
=A0=A0 =A0=A0=A0 this.description =3D description;<br>=A0=A0=A0 }<br>=A0=A0=
=A0 <br>=A0=A0=A0 public Activity() {}<br><br>=A0=A0=A0 public int getId() =
{<br>
=A0=A0=A0 =A0=A0=A0 return id;<br>=A0=A0=A0 }<br><br>=A0=A0=A0 public Strin=
g getDescription() {<br>=A0=A0=A0 =A0=A0=A0 return description;<br>=A0=A0=
=A0 }<br><br>=A0=A0=A0 public String getName() {<br>=A0=A0=A0 =A0=A0=A0 ret=
urn name;<br>=A0=A0=A0 }<br><br>=A0=A0=A0 public int getDays() {<br>=A0=A0=
=A0 =A0=A0=A0 return days;<br>
=A0=A0=A0 }<br>}<br><br><br>--- This is the test incriminate test code ---<=
br><br>@Test<br>=A0=A0=A0 public void testAllActivities() throws SQLExcepti=
on, IOException {<br>=A0=A0=A0 =A0=A0=A0 Activity activity1 =3D new Activit=
y(&quot;Fake Name&quot;, &quot;Fake description&quot;);<br>
=A0=A0=A0 =A0=A0=A0 Activity activity2 =3D new Activity(&quot;Fake Name 2&q=
uot;, &quot;Second fake description&quot;);<br>=A0=A0=A0 =A0=A0=A0 IActivit=
yDAO dao =3D new IBatisActivityDAO();<br>=A0=A0=A0 =A0=A0=A0 dao.addNewActi=
vity(activity1);<br>=A0=A0=A0 =A0=A0=A0 dao.addNewActivity(activity2);<br>
=A0=A0=A0 =A0=A0=A0 <br>=A0=A0=A0 =A0=A0=A0 DBUtils.printQueryResults(&quot=
;SELECT * FROM Activity&quot;);<br>=A0=A0=A0 =A0=A0=A0 <br>=A0=A0=A0 =A0=A0=
=A0 Reader reader =3D Resources.getResourceAsReader(&quot;org/dna/metronomo=
/persistence/configuration.xml&quot;);<br>=A0=A0=A0 =A0=A0=A0 SqlSessionFac=
tory m_sqlSessionFactory =3D new SqlSessionFactoryBuilder().build(reader);<=
br>
=A0=A0=A0 =A0=A0=A0 ActivityMapper mapper =3D m_sqlSessionFactory.openSessi=
on().getMapper(ActivityMapper.class);<br>=A0=A0=A0 =A0=A0=A0 List&lt;Activi=
ty&gt; activities =3D mapper.listAll();<br>=A0=A0=A0 =A0=A0=A0 assertEquals=
(2, activities.size());<br>=A0=A0=A0 =A0=A0=A0 assertEquals(activity1.getNa=
me(), activities.get(0).getName());<br>
=A0=A0=A0 =A0=A0=A0 assertEquals(0, activities.get(0).getId());<br>=A0=A0=
=A0 =A0=A0=A0 assertEquals(activity2.getName(), activities.get(1).getName()=
);<br>=A0=A0=A0 =A0=A0=A0 assertEquals(1, activities.get(1).getId());<br>=
=A0=A0=A0 }<br><br>When I load the list of activities I find correctly popu=
lated all attributes except the key attribute, the id, i discover that the =
mapper doesn&#39;t fill it with the correct value from DB (a SELECT on the =
DB shot that the data are presents) but put the -55 default value that I se=
t. <br>
I can&#39;t understand why IBatis 3 doesn&#39;t corretly map the key IDENTI=
TY column to the java attribute.<br>The iBAtis3 svn rev I use is r928229.<b=
r>Many thanks in advance for any usefull hint.<br>=A0Best regards <br>=A0 A=
ndrea Selva<br>
<br>

--0016364c74df35e4200484ce4a7b--