1

I am using WSO2 Streaming Integrator (WSO2 SI) with default deployment settings which is based on H2 database, but I am not able to find a way to browse H2 database from http://localhost:8082

As I know, I have to configure it in deployment.yaml file udner SI_HOME/conf/server, but I can't find any reference in https://apim.docs.wso2.com/en/latest/streaming/streaming-overview/ documentation

Ismail Anjrini
  • 23
  • 3

2 Answers2

0

You don't have to rely on the inbuild H2 browser to connect to the Local H2 DB. You can use a client like DBeaver to connect to the DB. You can get the necessary paramerters from the datasource configurations.

ycr
  • 12,828
  • 2
  • 25
  • 45
0

Please follow the below-mentioned steps to browse through the default H2 database.

  1. Open the <SI_HOME>/repository/conf/deployment.toml file and add the following configuration.
[database_configuration]
enable_h2_console = "true"
  1. Restart the WSO2 SI and access the following URL via your browser:

http://localhost:8082

  1. Provide the relevant path of the DB you want to browse, username, and password in the connection UI.
JDBC URL: jdbc:h2:[file path to <SI_HOME>/repository/database/<DB>]
username: wso2carbon
password: wso2carbon

As the recommended practice please use any industry standard DBs when moving to production.

Saranki Magenthirarajah
  • 481
  • 1
  • 5
  • 14