Your column names aren't matching. Try this instead.
SELECT
baz1 baz2 FROM
    foo

Also, make sure the Bar class has a get/set for baz1 and baz2.

Zarar

----- Original Message ----- From: "Tom B." <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, July 18, 2005 10:02 AM
Subject: Nested Beans not populating using SQL alias.


I saw this question had been asked earlier, with no reply, so I'll try
and re-phrase ;-)

I have a nested bean called "Bar", inside of a class "Foo".  I am able
to use a Map to populate this bean, IE:

<result property="bar.baz1" column="baz1" />
<result property="bar.baz2" column="baz2" />

However, when I use the "equivelant" SQL alias without a map:

SELECT
    baz1 AS "bar.baz1",
    baz2 AS "bar.baz2"
FROM
    foo

This SQL does not populate my nested bean.  Is this a bug?

My Classes would look like:

class Foo{
  private Bar bar;

  Bar getBar() {
    if(this.bar == null) {
      this.bar = new Bar();
    }
    return bar;
  }
  void setBar(Bar bar) {
    this.bar = bar;
  }
}
....
class Bar{
   String getBaz1() {}
   void setBaz1(String baz1) {}
   String getBaz2() {}
   void setBaz2(String baz2) {}
}
....


Thanks!
Tom


Reply via email to