wso2 3.2如何浏览H2 DB控制台

Question

我使用的是wso2 3.2。我只是想浏览本地H2 DB。有人知道整个步骤吗？

我在deployment.toml文件中做了一些更改，如下所示&重新启动服务器，但控制台没有打开。

[database.local]
type = "h2"
url = "jdbc:h2:C:/Tools/wso2am- 
3.2.0/repository/database/WSO2CARBON_DB;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE"
enable_h2_console = "true"
port = "1010"
username = "wso2carbon"
password = "wso2carbon"


[database.apim_db]
type = "h2"
url = "jdbc:h2:C:/Tools/wso2am- 
3.2.0/repository/database/WSO2AM_DB;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE"
username = "wso2carbon"
password = "wso2carbon"
enable_h2_console = "true"
port = "1010"



[database.shared_db]
type = "h2"
url = "jdbc:h2:C:/Tools/wso2am-3.2.0/repository/
database/WSO2SHARED_DB;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE" 
username = "wso2carbon"
password = "wso2carbon"
enable_h2_console = "true"
port = "1010"

Answer 1

您需要将以下配置添加到deployment.toml中。

[database_configuration]
enable_h2_console = true

参考资料：https://apim.docs.wso2.com/en/3.2.0/reference/config-catalog/#enabling-the-h2-database-console

加载H2控制台后，输入JDBC、用户名和密码以连接到数据库。

根据您的配置，输入以下值以连接到apim_db数据库。

JDBC URL: jdbc:h2:C:/Tools/wso2am- 
3.2.0/repository/database/WSO2AM_DB;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE
User Name: wso2carbon
Password: wso2carbon