Tough one. What DB is that, Oracle? Can you run this query from sqlplus?
Andrus On May 18, 2006, at 6:01 PM, Mike Kienenberger wrote:
Here's an odd error that I've hit for the first time: 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 = ?)] It's a join table where one foreign key points to a different DataMap which is in a different DataNode/schema. Any thoughts?
