Error when join table spans datamaps

From: Mike Kienenberger (mkienen..mail.com)
Date: Thu May 18 2006 - 18:01:37 EDT

  • Next message: Andrus Adamchik: "Re: Error when join table spans datamaps"

    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?

    This archive was generated by hypermail 2.0.0 : Thu May 18 2006 - 18:02:03 EDT