Grokbase Groups Cayenne dev May 2006
FAQ
Error when join table spans DataMaps
------------------------------------

Key: CAY-552
URL: http://issues.apache.org/cayenne/browse/CAY-552
Project: Cayenne
Type: Bug

Components: Cayenne Core Library
Versions: 1.2 [BETA]
Reporter: Mike Kienenberger


When a join table spans DataMaps, the join query generated typically fails, unless the schemas are accessible via the same DataSource.

For example,

Caused by: java.sql.SQLException: invalid schema name: ENG_WORK_MGMT
in statement [SELECT DISTINCT t0.ACTIVITY_YEAR, t0.BUDGET_CODE, t0.GL,
t0.IS_ACTIVE, t0.NAME, t0.OBJ_TYPE, t0.SUB_ACTIVITY, t0.WORK_ORDER,
t0.ACTIVITY, t0.ID, t0.WORK_TYPE FROM CORE_WORK_MGMT.WORK t0,
ENG_WORK_MGMT.AUTHORIZATION_DOC__WORK t1 WHERE t0.ID = t1.WORK_ID AND
(t1.AUTHORIZATION_DOCUMENT_ID = ?)]

Unfortunately, fixing this equates to "horrible performance" ("cartesian
product in memory, turning Cayenne in a database engine"), but that's better than no performance.

One possible solution is "doing joins within Cayenne SQLAction code "

For more details, see the mailing list thread:

http://objectstyle.org/cayenne/lists/cayenne-user/2006/05/0083.html


--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/cayenne/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categoriescayenne
postedMay 22, '06 at 3:06p
activeMay 22, '06 at 3:06p
posts1
users1
websitecayenne.apache.org

1 user in discussion

Mike Kienenberger (JIRA): 1 post

People

Translate

site design / logo © 2022 Grokbase