I am using Cayenne 2.0.4.
I added a table to my database and then manually added as a dbentity and
objentity in the modeler.
When I save the project, I get the Warning:
DbRelationship <TOURNAMENT_TEMPLATES.toSites> has no joins.
once for each relationship in the db entity that I manually addecd.
I am getting this error only on this db entity but I have similar db
entities that are not getting this error that are set up the same way as
far as I can tell.
When I access the object in my application I get SQL that looks like this:
SELECT DISTINCT t0.ID, t0.LONG_NAME, t0.NAME, t0.ONLINE FROM APP.SITES
t0, APP.TOURNAMENT_TEMPLATES t1 WHERE AND (t1.id = ?) [bind: 1]
which obviously results in an SQLException.
I presume this is related to the problem that results in the warning
Can anyone tell me from this information what I may be missing?
I could reimport my schema into the modeler from scratch but I really
don't want to do that since I have had to modify the project a lot from
the imported state.