>
> Obviously, if you only have many-to-one relationship (from left to
> right) you can just use the ID of the left hand table. AFAICS that
> must be your case. My problem is that the join involves two many-to-many
> relationships, so I cannot even use the ID's of the relation table.
>
Hmmm... anyway, what about to try to construct the view (with not unique
IDs as a result) on the server side and let the SQLObject "chew" this view
"table". I think it worth to try it. But I am sure Oleg is reading this and
gives his comments about the issue.
>
> > I did not find solution, how to solve above mentioned SELECT using the
> > SQLObject. Even using raw SELECT.
> > I mean something like: result = con.queryAllDescription("rawSqlQuerry").
> > Because of that I am using views and it works.
>
> As far as I can see, you could do the same with the ViewSQLObject class.
>
Did not think about this (I do not know the ViewSQLObject class). My
feeling is I do not need more CPU load on the client side (which IMHO
ViewSQLObject is).
>
Regards
Petr
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
