Table 'clob_master' does not exist or is not owned by you

From: Tore Halset (halse..vv.ntnu.no)
Date: Thu Nov 11 2004 - 07:14:13 EST

  • Next message: jir..bjectstyle.org: "[OS-JIRA] Created: (CAY-236) gui application generates malformed xml"

    Hello.

    I am trying to create a IngresAdapter as we are evaluating Ingres for
    internal use.

    The first thing I had to fix was syntax for create statements. "not
    null" worked, but "null" did not work. I just copied the createTable
    method from JdbcAdapter and removed two lines.

    I have also started to do some changes in types.xml, but some more work
    has to be done.

    My current problem is with the CLOB_MASTER entity. Running the junit
    tests fails. The CLOB_DETAIL table are created, but not the
    CLOB_MASTER. The full log are attached at the bottom of this mail.

          [java] [junit] INFO QueryLogger: ALTER TABLE CLOB_DETAIL ADD
    FOREIGN KEY (CLOB_MASTER_ID) REFERENCES CLOB_MASTER (CLOB_MASTER_ID)
          [java] [junit] ERROR CayenneTestResources: Error generating
    schema...
          [java] [junit] ca.gcf.util.SqlEx: Table 'clob_master' does not
    exist or is not owned by you.

    Anyone seen this problem before?

    Regards,
      - Tore.

          [java] unit-test:
          [java] [junit] INFO QueryLogger: CREATE TABLE
    TIME_LOCKING_TEST (NAME VARCHAR(100), TIME_LOCK DATE,
    TIME_LOCKING_TEST_ID INTEGER NOT NULL, PRIMARY KEY
    (TIME_LOCKING_TEST_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    DATE_LOCKING_TEST (DATE_LOCK DATE, DATE_LOCKING_TEST_ID INTEGER NOT
    NULL, NAME VARCHAR(100), PRIMARY KEY (DATE_LOCKING_TEST_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    SIMPLE_LOCKING_TEST (DESCRIPTION VARCHAR(200), LOCKING_TEST_ID INTEGER
    NOT NULL, NAME VARCHAR(100), PRIMARY KEY (LOCKING_TEST_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    REL_LOCKING_TEST (NAME VARCHAR(100), REL_LOCKING_TEST_ID INTEGER NOT
    NULL, SIMPLE_LOCKING_TEST_ID INTEGER, PRIMARY KEY
    (REL_LOCKING_TEST_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE LOCKING_HELPER
    (LOCKING_HELPER_ID INTEGER NOT NULL, NAME VARCHAR(100),
    REL_LOCKING_TEST_ID INTEGER, PRIMARY KEY (LOCKING_HELPER_ID))
          [java] [junit] INFO QueryLogger: ALTER TABLE REL_LOCKING_TEST
    ADD FOREIGN KEY (SIMPLE_LOCKING_TEST_ID) REFERENCES SIMPLE_LOCKING_TEST
    (LOCKING_TEST_ID)
          [java] [junit] INFO QueryLogger: ALTER TABLE LOCKING_HELPER
    ADD FOREIGN KEY (REL_LOCKING_TEST_ID) REFERENCES REL_LOCKING_TEST
    (REL_LOCKING_TEST_ID)
          [java] [junit] INFO QueryLogger: CREATE TABLE CLIENT_COMPANY
    (CLIENT_COMPANY_ID INTEGER NOT NULL, NAME VARCHAR(100), PRIMARY KEY
    (CLIENT_COMPANY_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE DEPARTMENT
    (DEPARTMENT_ID INTEGER NOT NULL, MANAGER_ID INTEGER, NAME VARCHAR(100)
    NOT NULL, PRIMARY KEY (DEPARTMENT_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE PERSON
    (CLIENT_COMPANY_ID INTEGER, CLIENT_CONTACT_TYPE VARCHAR(50),
    DEPARTMENT_ID INTEGER, NAME VARCHAR(100) NOT NULL, PERSON_ID INTEGER
    NOT NULL, PERSON_TYPE CHAR(2) NOT NULL, SALARY FLOAT, PRIMARY KEY
    (PERSON_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE ADDRESS
    (ADDRESS_ID INTEGER NOT NULL, CITY VARCHAR(100), PERSON_ID INTEGER NOT
    NULL, PRIMARY KEY (ADDRESS_ID))
          [java] [junit] INFO QueryLogger: ALTER TABLE DEPARTMENT ADD
    FOREIGN KEY (MANAGER_ID) REFERENCES PERSON (PERSON_ID)
          [java] [junit] INFO QueryLogger: ALTER TABLE PERSON ADD
    FOREIGN KEY (CLIENT_COMPANY_ID) REFERENCES CLIENT_COMPANY
    (CLIENT_COMPANY_ID)
          [java] [junit] INFO QueryLogger: ALTER TABLE PERSON ADD
    FOREIGN KEY (DEPARTMENT_ID) REFERENCES DEPARTMENT (DEPARTMENT_ID)
          [java] [junit] INFO QueryLogger: ALTER TABLE ADDRESS ADD
    FOREIGN KEY (PERSON_ID) REFERENCES PERSON (PERSON_ID)
          [java] [junit] INFO QueryLogger: CREATE TABLE
    DELETE_RULE_FLATB (FLATB_ID INTEGER NOT NULL, PRIMARY KEY (FLATB_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    RELATIONSHIP_HELPER (NAME VARCHAR(100), RELATIONSHIP_HELPER_ID INTEGER
    NOT NULL, PRIMARY KEY (RELATIONSHIP_HELPER_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    FLATTENED_TEST_1 (FT1_ID INTEGER NOT NULL, NAME VARCHAR(100) NOT NULL,
    PRIMARY KEY (FT1_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE MEANINGFUL_FK
    (MEANIGNFUL_FK_ID INTEGER NOT NULL, RELATIONSHIP_HELPER_ID INTEGER NOT
    NULL, PRIMARY KEY (MEANIGNFUL_FK_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    DELETE_RULE_FLATA (FLATA_ID INTEGER NOT NULL, PRIMARY KEY (FLATA_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE CLOB_DETAIL
    (CLOB_DETAIL_ID INTEGER NOT NULL, CLOB_MASTER_ID INTEGER, NAME
    VARCHAR(254), PRIMARY KEY (CLOB_DETAIL_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE TO_ONEFK2
    (TO_ONEFK2_PK INTEGER NOT NULL, PRIMARY KEY (TO_ONEFK2_PK))
          [java] [junit] INFO QueryLogger: CREATE TABLE TO_ONEFK1
    (TO_ONEFK1_FK INTEGER NOT NULL, TO_ONEFK1_PK INTEGER NOT NULL, PRIMARY
    KEY (TO_ONEFK1_PK))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    FLATTENED_TEST_2 (FT1_ID INTEGER, FT2_ID INTEGER NOT NULL, NAME
    VARCHAR(100) NOT NULL, PRIMARY KEY (FT2_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    REFLEXIVE_AND_TO_ONE (NAME VARCHAR(100), PARENT_ID INTEGER,
    REFLEXIVE_AND_TO_ONE_ID INTEGER NOT NULL, RELATIONSHIP_HELPER_ID
    INTEGER, PRIMARY KEY (REFLEXIVE_AND_TO_ONE_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    DELETE_RULE_JOIN (FLATA_ID INTEGER NOT NULL, FLATB_ID INTEGER NOT NULL,
    PRIMARY KEY (FLATA_ID, FLATB_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    DELETE_RULE_TEST2 (DEL_RULE_TEST2_ID INTEGER NOT NULL, PRIMARY KEY
    (DEL_RULE_TEST2_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    FLATTENED_TEST_3 (FT2_ID INTEGER, FT3_ID INTEGER NOT NULL, NAME
    VARCHAR(100) NOT NULL, PRIMARY KEY (FT3_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    DELETE_RULE_TEST3 (DELETE_RULE_TEST_3_FK INTEGER, DELETE_RULE_TEST_3_ID
    INTEGER NOT NULL, PRIMARY KEY (DELETE_RULE_TEST_3_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE
    DELETE_RULE_TEST1 (DEL_RULE_TEST1_ID INTEGER NOT NULL, TEST2_ID INTEGER
    NOT NULL, PRIMARY KEY (DEL_RULE_TEST1_ID))
          [java] [junit] INFO QueryLogger: CREATE TABLE COMPLEX_JOIN
    (EXTRA_COLUMN VARCHAR(50), FT1_FK INTEGER, FT3_FK INTEGER, PK INTEGER
    NOT NULL, PRIMARY KEY (PK))
          [java] [junit] INFO QueryLogger: ALTER TABLE MEANINGFUL_FK
    ADD FOREIGN KEY (RELATIONSHIP_HELPER_ID) REFERENCES RELATIONSHIP_HELPER
    (RELATIONSHIP_HELPER_ID)
          [java] [junit] INFO QueryLogger: ALTER TABLE CLOB_DETAIL ADD
    FOREIGN KEY (CLOB_MASTER_ID) REFERENCES CLOB_MASTER (CLOB_MASTER_ID)
          [java] [junit] ERROR CayenneTestResources: Error generating
    schema...
          [java] [junit] ca.gcf.util.SqlEx: Table 'clob_master' does not
    exist or is not owned by you.
          [java] [junit] at
    ca.gcf.jdbc.DrvObj.readError(DrvObj.java:773)
          [java] [junit] at
    ca.gcf.jdbc.JdbcStmt.readError(JdbcStmt.java:2259)
          [java] [junit] at
    ca.gcf.jdbc.DrvObj.readResults(DrvObj.java:629)
          [java] [junit] at
    ca.gcf.jdbc.JdbcStmt.readResults(JdbcStmt.java:2156)
          [java] [junit] at
    ca.gcf.jdbc.JdbcStmt.readResults(JdbcStmt.java:2107)
          [java] [junit] at
    ca.gcf.jdbc.JdbcStmt.exec(JdbcStmt.java:1364)
          [java] [junit] at
    ca.gcf.jdbc.JdbcStmt.execute(JdbcStmt.java:551)
          [java] [junit] at
    org.objectstyle.cayenne.unit.AbstractAccessStack.createSchema(AbstractAc
    cessStack.java:289)
          [java] [junit] at
    org.objectstyle.cayenne.unit.SimpleAccessStack.createSchema(SimpleAccess
    Stack.java:149)
          [java] [junit] at
    org.objectstyle.cayenne.unit.CayenneTestResources.rebuildSchema(CayenneT
    estResources.java:185)
          [java] [junit] at
    org.objectstyle.cayenne.unit.CayenneTestResources.<clinit>(CayenneTestRe
    sources.java:143)
          [java] [junit] at java.lang.Class.forName0(Native Method)
          [java] [junit] at java.lang.Class.forName(Class.java:141)
          [java] [junit] at
    org.objectstyle.cayenne.unit.CayenneTestCase.class$(CayenneTestCase.java
    :93)

          [java] [junit] at
    org.objectstyle.cayenne.unit.CayenneTestCase.<clinit>(CayenneTestCase.ja
    va:93)
          [java] BUILD FAILED
          [java] [junit] at java.lang.Class.forName0(Native Method)
          [java] java.lang.ExceptionInInitializerError
          [java] [junit] at java.lang.Class.forName(Class.java:141)

          [java] [junit] at
    org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.<init>(JUni
    tTestRunner.java:204)



    This archive was generated by hypermail 2.0.0 : Thu Nov 11 2004 - 07:14:16 EST