HighGo数据库配置
驱动配置
jdbc仓库
https://mvnrepository.com/artifact/com.highgo/HgdbJdbc
Maven配置(6.0.1版本可用)
<highgo.version>6.0.1.jre8</highgo.version>
<dependency>
<groupId>com.highgo</groupId>
<artifactId>HgdbJdbc</artifactId>
<version>${highgo.version}</version>
</dependency>
JDBC连接配置
pamirs:
datasource:
base:
type: com.alibaba.druid.pool.DruidDataSource
driverClassName: com.highgo.jdbc.Driver
url: jdbc:highgo://127.0.0.1:5866/oio_base?currentSchema=base,utl_file
username: xxxxxx
password: xxxxxx
initialSize: 5
maxActive: 200
minIdle: 5
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
asyncInit: true
连接url配置
官方文档
https://www.highgo.com/document/zh-cn/application/jdbc.html
url格式
jdbc:highgo://ip:端口号/数据库名?currentSchema=schema1,schema2
在jdbc连接配置时,${database}和${schema}必须完整配置,不可缺省。
jdbc指定schema时可以在currentSchema后指定多个schema,中间用,分隔,第一个schema为业务库表存放的主schema。
highgo数据库6.0版本里每个数据库默认会带一个utl_file的schema,该模式与文件访问功能有关,需要带在jdbc的schema中,但不能放在第一个。
其他连接参数如需配置,可自行查阅相关资料进行调优。
方言配置
pamirs方言配置
pamirs:
dialect:
ds:
base:
type: HighGoDB
version: 6
major-version: 6.0.1
biz_data:
type: HighGoDB
version: 6
major-version: 6.0.1
数据库版本 | type | version | majorVersion |
---|---|---|---|
6.0.x | HighGo | 6 | 6.0.1 |
PS:由于方言开发环境为6.0.1版本,其他类似版本(6.0.x)原则上不会出现太大差异,如出现其他版本无法正常支持的,可在文档下方留言。
schedule方言配置
pamirs:
event:
enabled: true
schedule:
enabled: true
dialect:
type: HighGoDB
version: 6
major-version: 6.0.1
其他配置
逻辑删除的值配置
pamirs:
mapper:
global:
table-info:
logic-delete-value: (EXTRACT(epoch FROM CURRENT_TIMESTAMP) * 1000000 + EXTRACT(MICROSECONDS FROM CURRENT_TIMESTAMP))::bigint
Highgo数据库用户初始化及授权
-- init oio_base user (user name can be modified by oneself)
CREATE USER oio_base WITH PASSWORD 'Test@12345678';
-- if using automatic database and schema creation, this is very important.
ALTER USER oio_base CREATEDB;
SELECT * FROM pg_roles;
-- if using highgo database, this authorization is required.
GRANT CREATE ON DATABASE highgo TO oio_base;
Oinone社区 作者:Gesi原创文章,如若转载,请注明出处:https://doc.oinone.top/install/21374.html
访问Oinone官网:https://www.oinone.top获取数式Oinone低代码应用平台体验