jeecgboot / JeecgBoot

🔥「企业级低代码平台」前后端分离架构SpringBoot 2.x/3.x,SpringCloud,Ant Design&Vue3,Mybatis,Shiro,JWT。强大的代码生成器让前后端代码一键生成,无需写任何代码! 引领新的开发模式,引入AI模型能力 OnlineCoding->代码生成->手工MERGE,帮助Java项目解决70%重复工作,让开发更关注业务,既能快速提高效率,帮助公司节省成本,同时又不失灵活性。
http://www.jeecg.com
Apache License 2.0
40.89k stars 14.89k forks source link

连接达梦数据库启动时一直 #2525

Closed HUANGZHENJIE2 closed 3 years ago

HUANGZHENJIE2 commented 3 years ago
版本号:

2.4.3

问题描述:

下载jeecboot源代码后配置,根据教程配置达梦数据库后,启动循环一直打印“2021-04-29 00:20:02.988 [main] INFO c.a.d.s.b.a.DruidDataSourceAutoConfigure:56 - Init DruidDataSource”。

截图&代码:

1 、application-dev.yml server: port: 8080 tomcat: max-swallow-size: -1 error: include-exception: true include-stacktrace: ALWAYS include-message: ALWAYS servlet: context-path: /jeecg-boot compression: enabled: true min-response-size: 1024 mime-types: application/javascript,application/json,application/xml,text/html,text/xml,text/plain,text/css,image/*

management: endpoints: web: exposure: include: metrics,httptrace

spring: servlet: multipart: max-file-size: 10MB max-request-size: 10MB mail: host: smtp.163.com username: jeecgos@163.com password: ?? properties: mail: smtp: auth: true starttls: enable: true required: true

quartz定时任务,采用数据库方式

quartz: job-store-type: jdbc initialize-schema: embedded

设置自动启动,默认为 true

auto-startup: true
#启动时更新己存在的Job
overwrite-existing-jobs: true
properties:
  org:
    quartz:
      scheduler:
        instanceName: MyScheduler
        instanceId: AUTO
      jobStore:
        class: org.quartz.impl.jdbcjobstore.JobStoreTX
        driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate
        tablePrefix: QRTZ_
        isClustered: true
        misfireThreshold: 60000
        clusterCheckinInterval: 10000
      threadPool:
        class: org.quartz.simpl.SimpleThreadPool
        threadCount: 10
        threadPriority: 5
        threadsInheritContextClassLoaderOfInitializingThread: true

json 时间戳统一转换

jackson: date-format: yyyy-MM-dd HH:mm:ss time-zone: GMT+8

jpa:

open-in-view: false

jpa: properties: hibernate: dialect: org.hibernate.dialect.Oracle8iDialect activiti: check-process-definitions: false

启用作业执行器

async-executor-activate: false
#启用异步执行器
job-executor-activate: false

aop: proxy-target-class: true

配置freemarker

freemarker:

设置模板后缀名

suffix: .ftl
# 设置文档类型
content-type: text/html
# 设置页面编码格式
charset: UTF-8
# 设置页面缓存
cache: false
prefer-file-system-access: false
# 设置ftl文件路径
template-loader-path:
  - classpath:/templates

设置静态文件路径,js,css等

mvc: static-path-pattern: /** resource: static-locations: classpath:/static/,classpath:/public/

autoconfigure:

#    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
#  datasource:
#    druid:
#      stat-view-servlet:
#        enabled: true
#        loginUsername: admin
#        loginPassword: 123456
#        allow:
#      web-stat-filter:
#        enabled: true
datasource:
  type: com.alibaba.druid.pool.DruidDataSource
  druid:
    driverClassName: dm.jdbc.driver.DmDriver
    url: jdbc:dm:/127.0.0.1:5236/?JEECGBOOT&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
    username: JEECGBOOT
    password: JEECGBOOT
dynamic:
  druid: # 全局druid参数,绝大部分值和默认保持一致。(现已支持的参数如下,不清楚含义不要乱设置)
    # 连接池的配置信息
    # 初始化大小,最小,最大
    initial-size: 5
    min-idle: 5
    maxActive: 20
    # 配置获取连接等待超时的时间
    maxWait: 60000
    # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
    timeBetweenEvictionRunsMillis: 60000
    # 配置一个连接在池中最小生存的时间,单位是毫秒
    minEvictableIdleTimeMillis: 300000
    validationQuery: SELECT 1 FROM DUAL
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    # 打开PSCache,并且指定每个连接上PSCache的大小
    poolPreparedStatements: true
    maxPoolPreparedStatementPerConnectionSize: 20
    # 配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙
    filters: stat,wall,slf4j
    # 通过connectProperties属性来打开mergeSql功能;慢SQL记录
    connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
      #      datasource:
      #        master:
      #          url: jdbc:mysql://127.0.0.1:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
      #          username: root
      #          password: hzj123.*
      #          driver-class-name: com.mysql.cj.jdbc.Driver
      # 多数据源配置
      #multi-datasource1:
      #url: jdbc:mysql://localhost:3306/jeecg-boot2?useUnicode=true&characterEncoding=utf8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
      #username: root
      #password: root
    #driver-class-name: com.mysql.cj.jdbc.Driver

redis 配置

redis: database: 0 host: 47.94.7.164 lettuce: pool: max-active: 8 #最大连接数据库连接数,设 0 为没有限制 max-idle: 8 #最大等待连接中的数量,设 0 为没有限制 max-wait: -1ms #最大建立连接等待时间。如果超过此时间将接到异常。设为-1表示无限制。 min-idle: 0 #最小等待连接中的数量,设 0 为没有限制 shutdown-timeout: 100ms password: '' port: 6379

mybatis plus 设置

mybatis-plus: mapper-locations: classpath*:org/jeecg/modules/*/xml/Mapper.xml global-config:

关闭MP3.0自带的banner

banner: false
db-config:
  #主键类型  0:"数据库ID自增",1:"该类型为未设置主键类型", 2:"用户输入ID",3:"全局唯一ID (数字类型唯一ID)", 4:"全局唯一ID UUID",5:"字符串全局唯一ID (idWorker 的字符串表示)";
  id-type: ASSIGN_ID
  # 默认数据库表下划线命名
  table-underline: true

configuration:

这个配置会将执行的sql打印出来,在开发或测试的时候可以用

#log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
# 返回类型为Map,显示null对应的字段
call-setters-on-nulls: true

minidao 设置

minidao : base-package: org.jeecg.modules.jmreport.*

DB类型(mysql | postgresql | oracle | sqlserver)

db-type: mysql

jeecg专用配置

jeecg :

本地:local\Minio:minio\阿里云:alioss

uploadType: local path :

文件上传根目录 设置

upload: C:\Users
#webapp文件路径
webapp: c://opt//webapp

shiro: excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/,/category/,/visual/,/map/,/jmreport/bigscreen2/**

阿里云oss存储配置

oss: endpoint: oss-cn-beijing.aliyuncs.com accessKey: ?? secretKey: ?? bucketName: ?? staticDomain: ??

ElasticSearch 6设置

elasticsearch: cluster-name: jeecg-ES cluster-nodes: 127.0.0.1:9200 check-enabled: false

表单设计器配置

desform:

主题颜色(仅支持 16进制颜色代码)

theme-color: "#1890ff"
# 文件、图片上传方式,可选项:qiniu(七牛云)、system(跟随系统配置)
upload-type: system

在线预览文件服务器地址配置

file-view-domain: 127.0.0.1:8012

minio文件上传

minio: minio_url: http://minio.jeecg.com minio_name: ?? minio_pass: ?? bucketName: otatest

大屏报表参数设置

jmreport: mode: dev

数据字典是否进行saas数据隔离,自己看自己的字典

saas: false
#是否需要校验token
is_verify_token: false
#必须校验方法
verify_methods: remove,delete,save,add,update

Wps在线文档

wps: domain: https://wwo.wps.cn/office/ appid: ?? appsecret: ??

xxl-job配置

xxljob: enabled: false adminAddresses: http://127.0.0.1:9080/xxl-job-admin appname: ${spring.application.name} accessToken: '' address: 127.0.0.1:30007 ip: 127.0.0.1 port: 30007 logPath: logs/jeecg/job/jobhandler/ logRetentionDays: 30

自定义路由配置 yml nacos database

route: config: data-id: jeecg-gateway-router group: DEFAULT_GROUP data-type: yml

分布式锁配置

redisson: address: 127.0.0.1:6379 password: type: STANDALONE enabled: true

cas单点登录

cas: prefixUrl: http://cas.example.org:8443/cas

Mybatis输出sql日志

logging: level: org.jeecg.modules.system.mapper : info

swagger

knife4j: production: false basic: enable: false username: jeecg password: jeecg1314

第三方登录

justauth: enabled: true type: GITHUB: client-id: ?? client-secret: ?? redirect-uri: http://sso.test.com:8080/jeecg-boot/sys/thirdLogin/github/callback WECHAT_ENTERPRISE: client-id: ?? client-secret: ?? redirect-uri: http://sso.test.com:8080/jeecg-boot/sys/thirdLogin/wechat_enterprise/callback agent-id: 1000002 DINGTALK: client-id: ?? client-secret: ?? redirect-uri: http://sso.test.com:8080/jeecg-boot/sys/thirdLogin/dingtalk/callback WECHAT_OPEN: client-id: ?? client-secret: ?? redirect-uri: http://sso.test.com:8080/jeecg-boot/sys/thirdLogin/wechat_open/callback cache: type: default prefix: 'demo::' timeout: 1h

2、jeecg-boot-parent

4.0.0 org.jeecgframework.boot jeecg-boot-parent 2.4.3 pom org.springframework.boot spring-boot-starter-parent 2.3.5.RELEASE 2.4.3 1.8 UTF-8 Hoxton.SR8 2.2.3.RELEASE 2.2.0 1.2.75 2.0.4 2.0.4 42.2.6 11.2.0.3 4.0 8.0.21 3.2.0 5.3.8 3.13.6 1.9.4 29.0-jre 3.4.1 1.1.22 2.6 2.1.0 3.11.2 1.7.1 3.11.0 3.1.0 1.3.1 1.3 8.0.3 1.3.4 1.6.1 7.4.0 jeecg-boot-base jeecg-boot-module-demo jeecg-boot-module-system jeecg jeecg Repository http://maven.jeecg.com:8090/nexus/content/repositories/jeecg jeecg-snapshots jeecg Snapshot Repository http://maven.jeecg.com:8090/nexus/content/repositories/snapshots/ aliyun aliyun Repository http://maven.aliyun.com/nexus/content/groups/public false jeecg jeecg Repository http://maven.jeecg.org/nexus/content/repositories/jeecg false org.springframework.boot spring-boot-starter-test test org.projectlombok lombok com.alibaba fastjson ${fastjson.version} com.dameng DmJdbcDriver18 1.0 com.dameng DmDialectForHibernate 5.3 org.springframework.cloud spring-cloud-dependencies ${spring-cloud.version} pom import com.alibaba.cloud spring-cloud-alibaba-dependencies ${spring-cloud-alibaba.version} pom import org.jeecgframework.boot jeecg-boot-module-system ${jeecgboot.version} com.dameng DmJdbcDriver18 1.0 com.dameng DmDialectForHibernate 5.3 org.jeecgframework.boot jeecg-boot-base-tools ${jeecgboot.version} org.jeecgframework.boot jeecg-boot-base-core ${jeecgboot.version} org.jeecgframework.boot jeecg-system-local-api ${jeecgboot.version} org.jeecgframework.boot jeecg-system-cloud-api ${jeecgboot.version} org.jeecgframework.boot jeecg-boot-starter-cloud ${jeecgboot.version} org.jeecgframework.boot jeecg-boot-starter-job ${jeecgboot.version} org.jeecgframework.boot jeecg-boot-starter-lock ${jeecgboot.version} org.jeecgframework.boot jeecg-boot-starter-rabbitmq ${jeecgboot.version} com.qiniu qiniu-java-sdk ${qiniu-java-sdk.version} okhttp com.squareup.okhttp3 dom4j dom4j ${dom4j.version} org.redisson redisson ${redisson.version} com.google.guava guava ${guava.version} cn.hutool hutool-all ${hutool-all.version} commons-beanutils commons-beanutils ${commons-beanutils.version} commons-fileupload commons-fileupload 1.4 commons-io commons-io com.xkcoding.justauth justauth-spring-boot-starter ${justauth-spring-boot-starter.version} hutool-core cn.hutool fastjson com.alibaba com.squareup.okhttp3 okhttp 4.4.1 io.minio minio ${minio.version} okio com.squareup.okio okhttp com.squareup.okhttp3 org.apache.maven.plugins maven-compiler-plugin 1.8 1.8 UTF-8 org.apache.maven.plugins maven-surefire-plugin true org.apache.maven.plugins maven-resources-plugin woff woff2 eot ttf svg src/main/resources true src/main/java **/*.xml **/*.json **/*.ftl dev true dev jeecg 127.0.0.1:8848 DEFAULT_GROUP 127.0.0.1:8848 test test jeecg 127.0.0.1:8848 DEFAULT_GROUP 127.0.0.1:8848 prod prod jeecg 127.0.0.1:8848 DEFAULT_GROUP 127.0.0.1:8848

友情提示: 未按格式要求发帖,会直接删掉。

Durant-Wen commented 3 years ago

请问如何解决循环打印Init DruidDataSource的问题?