[
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
