我正在使用link将WSO2-APIM从2.1.0升级到2.2.0版本 .
在执行 step 6-g
时,我遇到 java.sql.SQLSyntaxErrorException
用于创建表 IDN_OIDC_REQ_OBJECT_REFERENC
.
我的所有其他脚本都成功运行,但在执行 migration-resources\5.5.0\dbscripts\step1\identity\oracle.sql
的sql脚本时,问题就出现了 . 此文件存在于 step 6-a
中给出的zip文件中 .
当我尝试手动运行以下sql脚本时
CREATE TABLE IDN_OIDC_REQ_OBJECT_REFERENCE (
ID INTEGER,
CONSUMER_KEY_ID INTEGER ,
CODE_ID VARCHAR(255) ,
TOKEN_ID VARCHAR(255) ,
SESSION_DATA_KEY VARCHAR(255),
PRIMARY KEY (ID),
FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE,
FOREIGN KEY (TOKEN_ID) REFERENCES IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) ON DELETE CASCADE,
FOREIGN KEY (CODE_ID) REFERENCES IDN_OAUTH2_AUTHORIZATION_CODE(CODE_ID) ON DELETE CASCADE);
进入oracle db我遇到以下错误:
Error at Command Line : 66 Column : 61
Error report -
SQL Error: ORA-02270: no matching unique or primary key for this column-list
02270. 00000 - "no matching unique or primary key for this column-list"
*Cause: A REFERENCES clause in a CREATE/ALTER TABLE statement
gives a column-list for which there is no matching unique or primary
key constraint in the referenced table.
*Action: Find the correct column names using the ALL_CONS_COLUMNS
catalog view
线 66
只不过是: FOREIGN KEY (TOKEN_ID) REFERENCES IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) ON DELETE CASCADE,
让我知道在迁移过程中我错过了什么?还是因为现有的 table 不合适?任何帮助将不胜感激 . 提前致谢 .