From: <glassfish_at_javadesktop.org>
Date: Fri, 09 Feb 2007 17:26:05 PST

Hi,

When I updated from Sun Java System Application Server Platform Edition 9.0 (build b48)
to Sun Java System Application Server Platform Edition 9.0_01 (build b02-p01), I got an error in the application which did not occur in the older version.

Caused by: Exception [TOPLINK-6052] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.QueryException
Exception Description: An outer join (getAllowingNull or anyOfAllowingNone) is only valid for OneToOne, OneToMany, ManyToMany, AggregateCollection and DirectCollection Mappings, and cannot be used for the mapping [oracle.toplink.essentials.mappings.AggregateObjectMapping[contact]].

select new somepackage.MyProjection(s.companyId,
                                s.company.name, s.userId, s.company.contact.firstName,
                                s.company.contact.lastName)
from Submission s
order by s.companyId
            

@Embeddable
public class Contact{
     private String firstName;
     private String lastName;
}

@Embeddable
public class Company{
    @Embedded
    private Contact contact;
}

@Entity
@Table(name="SOMETABLE")
public class Submission {
        @Embedded
    private Company company;
}


All of the information is stored under one table. From the error message, it seems like I can no longer navigate to the Contact object.

-tiep
[Message sent by forum member 'tmv' (tmv)]

http://forums.java.net/jive/thread.jspa?messageID=203009