openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sebastien morissette (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OPENJPA-2022) Reversemappingtooltask with oracle is failing like in OPENJPA-1940 previous bug
Date Tue, 28 Jun 2011 01:17:16 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-2022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13056240#comment-13056240
] 

sebastien morissette commented on OPENJPA-2022:
-----------------------------------------------

here is the ddl for 3 of my tables

ALTER TABLE RMTOOLS."AppUsers"
 DROP PRIMARY KEY CASCADE;
DROP TABLE RMTOOLS."AppUsers" CASCADE CONSTRAINTS;

CREATE TABLE RMTOOLS."AppUsers"
(
  "AppUser"        NUMBER(12)                   NOT NULL,
  "Name"           VARCHAR2(100 BYTE)           NOT NULL,
  "Email"          VARCHAR2(100 BYTE)           NOT NULL,
  "Creation_Date"  DATE                         NOT NULL,
  "pager"          VARCHAR2(100 BYTE),
  "LDAPuserId"     VARCHAR2(100 BYTE)           NOT NULL,
  "Active"         VARCHAR2(5 BYTE)             NOT NULL
)
TABLESPACE USERS
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX RMTOOLS."Key8" ON RMTOOLS."AppUsers"
("AppUser")
LOGGING
TABLESPACE USERS
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


ALTER TABLE RMTOOLS."AppUsers" ADD (
  CONSTRAINT "Key8"
 PRIMARY KEY
 ("AppUser")
    USING INDEX 
    TABLESPACE USERS
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
               ));



ALTER TABLE RMTOOLS."Credentials"
 DROP PRIMARY KEY CASCADE;
DROP TABLE RMTOOLS."Credentials" CASCADE CONSTRAINTS;

CREATE TABLE RMTOOLS."Credentials"
(
  CREDENTIAL        NUMBER(12),
  USERNAME          VARCHAR2(50 BYTE) CONSTRAINT SYS_C004201 NOT NULL,
  PASSWORD          VARCHAR2(50 BYTE),
  KEY               VARCHAR2(200 BYTE),
  LABEL             VARCHAR2(25 BYTE),
  "CredentialType"  NUMBER(12)                  NOT NULL
)
TABLESPACE USERS
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX RMTOOLS.CREDENTIALS_PK ON RMTOOLS."Credentials"
(CREDENTIAL)
LOGGING
TABLESPACE USERS
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


CREATE UNIQUE INDEX RMTOOLS.SYS_C004204 ON RMTOOLS."Credentials"
(LABEL)
LOGGING
TABLESPACE USERS
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


ALTER TABLE RMTOOLS."Credentials" ADD (
  CONSTRAINT CREDENTIALS_PK
 PRIMARY KEY
 (CREDENTIAL)
    USING INDEX 
    TABLESPACE USERS
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
               ),
  CONSTRAINT SYS_C004204
 UNIQUE (LABEL)
    USING INDEX 
    TABLESPACE USERS
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
               ));

ALTER TABLE RMTOOLS."Credentials" ADD (
  CONSTRAINT "Relationship12" 
 FOREIGN KEY ("CredentialType") 
 REFERENCES RMTOOLS."CredentialTypes" ("CredentialType"));



ALTER TABLE RMTOOLS."CredentialTypes"
 DROP PRIMARY KEY CASCADE;
DROP TABLE RMTOOLS."CredentialTypes" CASCADE CONSTRAINTS;

CREATE TABLE RMTOOLS."CredentialTypes"
(
  "CredentialType"  NUMBER(12)                  NOT NULL,
  "Label"           VARCHAR2(100 BYTE),
  "Type"            VARCHAR2(100 BYTE)          NOT NULL
)
TABLESPACE USERS
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX RMTOOLS."Key2" ON RMTOOLS."CredentialTypes"
("CredentialType")
LOGGING
TABLESPACE USERS
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


ALTER TABLE RMTOOLS."CredentialTypes" ADD (
  CONSTRAINT "Key2"
 PRIMARY KEY
 ("CredentialType")
    USING INDEX 
    TABLESPACE USERS
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
               ));


> Reversemappingtooltask with oracle is failing like in OPENJPA-1940 previous bug
> -------------------------------------------------------------------------------
>
>                 Key: OPENJPA-2022
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2022
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: tooling
>    Affects Versions: 2.1.0, 2.1.1, 2.2.0
>         Environment: Woking on a windows pc with a oracle 10g express database, eclipse
helios, using oracle 11.2.0.2 driver. 
>            Reporter: sebastien morissette
>            Assignee: Michael Dick
>             Fix For: 2.1.1, 2.2.0
>
>
> When running either of the versions of the reversemappingtool as reported in the 1940
bug as fixed, i get the same error as in 2.1.0 :
> [reversemappingtool] 2363  openjpa  INFO   [main] openjpa.Tool - ReverseMappingTool :
generating classes.
> [reversemappingtool] 2365  openjpa  INFO   [main] openjpa.MetaData - Table "RMTOOLS."AppUsers""
could not be reverse mapped.  This means that the table does not have a primary key (primary
keys are required to establish unique identifiers for all persistent objects) and does not
match a known pattern for a table used for cross-reference or value collections.
> [reversemappingtool] 2366  openjpa  INFO   [main] openjpa.MetaData - Table "RMTOOLS."CredentialTypes""
could not be reverse mapped.  This means that the table does not have a primary key (primary
keys are required to establish unique identifiers for all persistent objects) and does not
match a known pattern for a table used for cross-reference or value collections.
> [reversemappingtool] 2366  openjpa  INFO   [main] openjpa.MetaData - Table "RMTOOLS."Credentials""
could not be reverse mapped.  This means that the table does not have a primary key (primary
keys are required to establish unique identifiers for all persistent objects) and does not
match a known pattern for a table used for cross-reference or value collections.
> this happens for all my tables. Is it possible this bug was reintroduced?
> thanks

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message