Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to access and operate the O2OA embedded H2 database. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have some understanding of the relevant knowledge after reading this article.

The H2 database is embedded in O2OA by default, and the H2 database can be managed and queried by JDBC or directly by the WEB client.

Web access

Default access address: http://hostip:20051/

Saved Settings: Generic H2 (Server)

Setting Name: Generic H2 (Server)

Driver Class: org.h3.Driver

JDBC URL: jdbc:h3:tcp://localhost:20050/X

User Name:sa

Password: o2

Description:

Password is the same as xadmin password, and the default administrator password for the platform is O2.

If you log in to the management side for the first time, it will be faster and slower. Please wait about 30 seconds.

H2 database WEB management side home page

Client access

Recommended client software: open source database client DBeaver

DBeaver official website: https://dbeaver.io or download from other websites, the installation process is not described here.

Installation and user manual: https://blog.csdn.net/volitationLong/article/details/80583977

Related configuration instructions

1. Create a new data connection

2. Fill in the connection information

JDBC URL: automatic generation

Host: the host IP where the server resides, such as 127.0.0.1

Port: default is 20050

Database / schema: X01

User name: sa

Password: O2

The database password is consistent with the xadmin password.

Other database access

For other databases, such as Oralce,Mysql,SQLServer, please use the corresponding database client yourself. I won't go into too much detail here.

MySQL-Front:

Download address: http://www.mysqlfront.de/

Installation and usage tutorial: https://www.w3cschool.cn/mysql/mysql-mox12owr.html

On how to access and operate O2OA embedded H2 database to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.