Doesn't work for me. This is a copy of my code. It barks at me with
a stack trace I'll place below the code.
Expression exp = ExpressionFactory.matchExp(
Reservation.TO_SITE_PROPERTY
+ Site.TO_SITE_TYPE_PROPERTY
+ SiteType.TYPE_NAME_PROPERTY,
type);
SelectQuery sq = new SelectQuery(Reservation.class, exp);
List<Reservation> rlist = context.performQuery(sq);
[#|2008-05-22T17:45:33.673-0400|INFO|sun-appserver9.1|org.apache.cayenne.access.QueryLogger|_ThreadID=16;_ThreadName=httpSSLWorkerThread-8080-0;|***
error.
org.apache.cayenne.exp.ExpressionException: [v.3.0M2 Oct 23 2007
13:00:44] Can't resolve path component:
[Reservation.toSitetoSiteTypetypeName].
at org.apache.cayenne.map.Entity$PathIterator.next(Entity.java:375)
at
org.apache.cayenne.access.trans.QueryAssemblerHelper.appendObjPath(QueryAssemblerHelper.java:90)
at
org.apache.cayenne.access.trans.QualifierTranslator.objectNode(QualifierTranslator.java:338)
at org.apache.cayenne.exp.Expression.traverse(Expression.java:455)
at org.apache.cayenne.exp.Expression.traverse(Expression.java:452)
at org.apache.cayenne.exp.Expression.traverse(Expression.java:432)
at
org.apache.cayenne.access.trans.QualifierTranslator.doTranslation(QualifierTranslator.java:74)
at
org.apache.cayenne.access.trans.SelectTranslator.createSqlString(SelectTranslator.java:123)
at
org.apache.cayenne.access.trans.QueryAssembler.createStatement(QueryAssembler.java:95)
at
org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:71)
at
org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:57)
at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:236)
at
org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:446)
at
org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:67)
at
org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:418)
at
org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:853)
at
org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:415)
at
org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:119)
at org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:746)
at
org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:282)
at
org.apache.cayenne.access.DataContextQueryAction.execute(DataContextQueryAction.java:59)
at org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1323)
at
org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1312)
at
com.campgroundautomation.sunrise.hostedservices.sws.datagateway.ReservationDataGateway.retrieveCriteriaReservationCount(ReservationDataGateway.java:265)
at
com.campgroundautomation.sunrise.hostedservices.sws.datagateway.ReservationDataGateway.retrieveAvailabilityByType(ReservationDataGateway.java:387)
at
com.campgroundautomation.sunrise.hostedservices.sws.ReservationService.checkAvailByType(ReservationService.java:266)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
On Thu, May 22, 2008 at 5:37 PM, Mike Kienenberger <[EMAIL PROTECTED]> wrote:
> Expression qualifier = ExpressionFactory.matchExp(
> Reservation.SITE_RELATIONSHIP_PROPERTY
> + Site.SITE_TYPE_RELATIONSHIP_PROPERTY
> + SiteType.NAME_ATTRIBUTE_PROPERTY,
> "foo");
>
> SelectQuery query = new SelectQuery(Reservation.class, qualifier );
>
> On 5/22/08, Eric Polino <[EMAIL PROTECTED]> wrote:
>> On Thu, May 22, 2008 at 5:23 PM, Eric Polino
>> <[EMAIL PROTECTED]> wrote:
>> > Given three tables (This is not accurate SQL syntax...but you get the
>> point).
>> >
>> > Reservation {
>> > ...
>> > siteId int foreign key with Site,
>> > ...
>> > }
>> >
>> > Site {
>> > ...
>> > siteId int primary key,
>> > typeId int foreign key with SiteType,
>> > ...
>> > }
>> >
>> > SiteType {
>> > ...
>> > siteTypeId int primary key,
>> > name varchar(32),
>> > ...
>> > }
>> >
>> > How can I do the following SQL statement using Expression,
>> > ExpressionFactory, SelectQuery, etc?
>> >
>> > select * from Reservation r, Site s, SiteType st where r.siteId =
>> > s.siteId and s.typeId = st.siteTypeId and st.name = 'foo'
>> >
>>
>>
>> I'm actually trying to get Reservation objects, so it's not '*' I'm
>> selecting but more like r.field1, r.field2,... But Cayenne can take
>> care of that for me when the time comes I'm sure.
>>
>>
>> > TIA.
>> >
>> > --
>> > Eric Polino
>> > Campground Automated Systems
>> >
>>
>>
>>
>> --
>> Eric Polino
>> Campground Automated Systems
>>
>
--
Eric Polino
Campground Automated Systems
