Corrections for xmlMapping example in chapter 13

[Himai Minh]

For everyone's reference, on p.407 of JPA Pro , xmlmapping,

@Entity
public class Employee{
  //...
@Embedded 
  @Embedded
    @AttributeOverrides(
    		{@AttributeOverride(name="state",column=@Column(table="EMP_ADDRESS", name="PROV")),
    		 @AttributeOverride(name="zip", column=@Column(table="EMP_ADDRESS",name="PCODE")),
    	  })
    private Address address;

}

The corresponding orm.xml is:

<entity class="Employee">
   < embedded name="address">
               <attribute-override name="state">
                    <column name="PROV"  />
                </attribute-override>
                <attribute-override name="zip">
                    <column name="PCODE" />
                </attribute-override>
            </embedded>
</entity>

My correction is:

public class Employee{
...

 @Embedded
    @AttributeOverrides(
    		{@AttributeOverride(name="state",column=@Column(table="EMP_ADDRESS", name="PROV")),
    		 @AttributeOverride(name="zip", column=@Column(table="EMP_ADDRESS",name="PCODE")),
    		 @AttributeOverride(name="city",column=@Column(table="EMP_ADDRESS",name="CITY")),
    		 @AttributeOverride(name="street",column=@Column(table="EMP_ADDRESS",name="STREET"))
             })
    private Address address;
    
}

The corresponding orm.xml is:

<embedded name="address">
                <attribute-override name="street">
                    <column name="STREET" table="EMP_ADDRESS"/>
                </attribute-override>
                <attribute-override name="city">
                    <column name="CITY" table="EMP_ADDRESS"/>
                </attribute-override>
                <attribute-override name="state">
                    <column name="PROV" table="EMP_ADDRESS"/>
                </attribute-override>
                <attribute-override name="zip">
                    <column name="PCODE" table="EMP_ADDRESS"/>
                </attribute-override>
            </embedded>

If I don't specify CITY  in the attribute override, the Employee.findAll query cannot find t0.City from EMP class.
The exception is:

Call: SELECT t0.ID, t0.TYPE, t1.EMP_ID, t0.NAME, t0.STARTDATE, t0.CITY, t1.PROV, t0.STREET, t1.PCODE, t0.DEPT, t0.MGR, t0.DAILYRATE, t0.TERM, t0.HOURLYRATE, t0.VACATION, t0.PENSION, t0.SALARY FROM xmlMappings.EMP t0, xmlMappings.EMP_ADDRESS t1 WHERE (t1.EMP_ID = t0.ID)
Query: ReadAllQuery(name="Employee.findAll" referenceClass=Employee sql="SELECT t0.ID, t0.TYPE, t1.EMP_ID, t0.NAME, t0.STARTDATE, t0.CITY, t1.PROV, t0.STREET, t1.PCODE, t0.DEPT, t0.MGR, t0.DAILYRATE, t0.TERM, t0.HOURLYRATE, t0.VACATION, t0.PENSION, t0.SALARY FROM xmlMappings.EMP t0, xmlMappings.EMP_ADDRESS t1 WHERE (t1.EMP_ID = t0.ID)")

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't0.CITY' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)