wso2正在更改嵌入式数据库架构 [英] wso2 is change the embedded database schema

问题描述

我正在使用WSO2 IS 5.2.0

I am working with the WSO2 IS 5.2.0

由于某些原因，我想更改默认嵌入式H2数据库的数据模式.

for some reasons, I would like to change the data schema of the default embedded H2 database.

例如， 表"IDN_OAUTH2_ACCESS_TOKEN"中卷"ACCESS_TOKEN"的最大长度为255个字符.我想将其更改为8194.

for example, the maximum length of volume "ACCESS_TOKEN" in table "IDN_OAUTH2_ACCESS_TOKEN" is 255 chars. I would like to change it to 8194.

我对配置文件"/dbscripts/identity/h2.sql"进行了以下更改(请参见值"8194")

I made the following change the configuration file "/dbscripts/identity/h2.sql" (see the value "8194")

CREATE TABLE IF NOT EXISTS IDN_OAUTH2_ACCESS_TOKEN (
            TOKEN_ID VARCHAR (255),
            ACCESS_TOKEN VARCHAR (8194),
            REFRESH_TOKEN VARCHAR (255),
            CONSUMER_KEY_ID INTEGER,
            AUTHZ_USER VARCHAR (100),
            TENANT_ID INTEGER,
            USER_DOMAIN VARCHAR(50),
            USER_TYPE VARCHAR (25),
            GRANT_TYPE VARCHAR (50),
            TIME_CREATED TIMESTAMP DEFAULT 0,
            REFRESH_TOKEN_TIME_CREATED TIMESTAMP DEFAULT 0,
            VALIDITY_PERIOD BIGINT,
            REFRESH_TOKEN_VALIDITY_PERIOD BIGINT,
            TOKEN_SCOPE_HASH VARCHAR (32),
            TOKEN_STATE VARCHAR (25) DEFAULT 'ACTIVE',
            TOKEN_STATE_ID VARCHAR (128) DEFAULT 'NONE',
            SUBJECT_IDENTIFIER VARCHAR(255),
            PRIMARY KEY (TOKEN_ID),
            FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE,
            CONSTRAINT CON_APP_KEY UNIQUE (CONSUMER_KEY_ID,AUTHZ_USER,TENANT_ID,USER_DOMAIN,USER_TYPE,TOKEN_SCOPE_HASH,
                                           TOKEN_STATE,TOKEN_STATE_ID)

问题在于我只是无法实施此更改.我做了一切(重新启动，重新安装)，原始设置("256")仍然存在...

the problems is that I just cannot put this change into effect. I did everything (restart, reinstall), the original settings ("256") persists...

似乎数据库架构已在IS服务器映像中生成.并且生成的脚本文件显示如果不存在则生成..."

it seems that the database schema had been generated in the IS server image. and the generating script file says "GENERATE IF NOT EXISTS..."

有人有什么主意吗?

谢谢

推荐答案

删除<IS_HOME>/repository/database/*.然后用-Dsetup启动服务器.

Remove <IS_HOME>/repository/database/*. Then start server with -Dsetup.

./wso2server.sh -Dsetup

这篇关于wso2正在更改嵌入式数据库架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！