GaussDB连接高斯数据库

配置文件写法:

spring:
    datasource:
    url: jdbc:gaussdb://xxx:29900/database?currentSchema=schema
    driver-class-name: com.huawei.gaussdb.jdbc.Driver
    username: nuzgnaw
    password: xxx
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
        # 初始化大小
        initial-size: 1
        # 最小连接数
        min-idle: 1
        # 最大连接数
        max-active: 50
        # 获取连接时的最大等待时间
        max-wait: 60000
        # 一个连接在池中最小生存的时间,单位是毫秒
        min-evictable-idle-time-millis: 300000
        # 多久才进行一次检测需要关闭的空闲连接,单位是毫秒
        time-between-eviction-runs-millis: 60000
        # 检测连接是否有效的 SQL语句,为空时以下三个配置均无效
        validation-query: SELECT 1 from sys_dummy
        # 申请连接时执行validationQuery检测连接是否有效,默认true,开启后会降低性能
        test-on-borrow: true
        # 归还连接时执行validationQuery检测连接是否有效,默认false,开启后会降低性能
        test-on-return: true
        # 申请连接时如果空闲时间大于timeBetweenEvictionRunsMillis,执行validationQuery检测连接是否有效,默认false,建议开启,不影响性能
        test-while-idle: true


mybatis:
    mapper-locations=classpath: /mapper/*.xml

遇到问题:

        通过Druid连接数据库资源池时,会导致JDBCUtils空指针,经查,SpringBoot约定大于配置,而华为GaussDB驱动没有遵守Spring的配置,和其他驱动程序不同的是,其中并没有针对seata做出的配置,导致报错

10:20:37.417 [main] WARN  o.a.c.l.WebappClassLoaderBase - [log,173] - The web application [ROOT] appears to have started a thread named [Druid-ConnectionPool-Create-1652197647] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
 sun.misc.Unsafe.park(Native Method)
 java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
 java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
 com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2852)
10:20:37.417 [main] WARN  o.a.c.l.WebappClassLoaderBase - [log,173] - The web application [ROOT] appears to have started a thread named [Druid-ConnectionPool-Destroy-1652197647] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
 java.lang.Thread.sleep(Native Method)
 com.alibaba.druid.pool.DruidDataSource$DestroyConnectionThread.run(DruidDataSource.java:2951)
10:20:37.419 [main] WARN  o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - [refresh,591] - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat
10:20:37.467 [main] ERROR o.s.b.SpringApplication - [reportFailure,821] - Application run failed
org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:165)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:577)
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:147)
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:731)
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:408)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:307)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292)
	at com.ruoyi.guass.RuoYiGuassApplication.main(RuoYiGuassApplication.java:25)
Caused by: org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat
	at org.springframework.boot.web.embed
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值