RDBMS and Druid configuration

Complete configuration items, default values, example values and enumeration descriptions for Lodsve Boot RDBMS and Druid configuration.

Configuration itemsTypeDefault valueExample valueDescription
lodsve.rdbms.default-data-source-nameStringNoneprimaryDefault data source name; leave the first one blank.
lodsve.rdbms.data-source.<name>.pool-nameStringNoneprimaryConnection pool display name.
lodsve.rdbms.data-source.<name>.driver-class-nameStringNonecom.mysql.cj.jdbc.DriverJDBC driver class name.
lodsve.rdbms.data-source.<name>.urlStringNonejdbc:mysql://localhost:3306/demoJDBC URL.
lodsve.rdbms.data-source.<name>.usernameStringNone${DB_USERNAME}Database username.
lodsve.rdbms.data-source.<name>.passwordStringNone${DB_PASSWORD}Database password.
lodsve.rdbms.data-source.<name>.pool-settingPoolSettingNoneSee table belowConnection pool settings.

PoolSetting

Configuration itemsTypeDefault valueExample valueDescription
...pool-setting.typePoolTypeHikariHikariConnection pool type.
...pool-setting.init-sizeint05Initialize the number of connections.
...pool-setting.max-activeint020Maximum number of active connections.
...pool-setting.min-idleint05Minimum number of idle connections.
...pool-setting.max-waitint030000Get the maximum waiting time of the connection, in milliseconds.
...pool-setting.validation-queryStringNoneSELECT 1SQL to verify the connection.
...pool-setting.test-on-borrowbooleanfalsefalseVerify when connecting.
...pool-setting.test-on-returnbooleanfalsefalseAlso verify when connecting.
...pool-setting.test-while-idlebooleanfalsetrueValidate at idle.
...pool-setting.time-between-eviction-runs-millisint060000Cleanup interval, in milliseconds.
...pool-setting.min-evictable-idle-time-millisint0300000Minimum idle survival time, in milliseconds.
...pool-setting.remove-abandonedbooleanfalsefalseWhether to remove leaking connections.
...pool-setting.remove-abandoned-timeoutint0300Leak connection timeout.
...pool-setting.log-abandonedbooleanfalsefalseWhether to log leaked connections.
...pool-setting.ext-propertiesPropertiesNone{characterEncoding: utf8mb4}Connection pool/driver extended properties.

PoolType

valuemeaning
HikariHikariCP, default value.
DruidAlibaba Druid.

lodsve.rdbms.druid

Configuration itemsTypeDefault valueExample valueDescription
lodsve.rdbms.druid.aop-patternsString[]None[com.example.service.*]Druid Spring AOP statistics package mode.
lodsve.rdbms.druid.stat-view-servlet.enabledbooleanfalsetrueWhether to enable monitoring servlet.
lodsve.rdbms.druid.stat-view-servlet.url-patternStringNone/druid/*Monitor Servlet URLs.
lodsve.rdbms.druid.stat-view-servlet.allowStringNone127.0.0.1Allow access to IP.
lodsve.rdbms.druid.stat-view-servlet.denyStringNone10.0.0.8Access Denied IP.
lodsve.rdbms.druid.stat-view-servlet.login-usernameStringNone${DRUID_USER}Monitoring page username.
lodsve.rdbms.druid.stat-view-servlet.login-passwordStringNone${DRUID_PASSWORD}Monitor page password.
lodsve.rdbms.druid.stat-view-servlet.reset-enableStringNonefalseWhether to display the reset button, the source code type is String.
lodsve.rdbms.druid.web-stat-filter.enabledbooleanfalsetrueWhether to enable Web Statistics Filter.
lodsve.rdbms.druid.web-stat-filter.url-patternStringNone/*Web Filter URL pattern.
lodsve.rdbms.druid.web-stat-filter.exclusionsStringNone*.js,*.css,/druid/*Exclude resources or paths.
lodsve.rdbms.druid.web-stat-filter.session-stat-max-countStringNone1000Session maximum statistics, source code type is String.
lodsve.rdbms.druid.web-stat-filter.session-stat-enableStringNonefalseWhether to count Sessions, the source code type is String.
lodsve.rdbms.druid.web-stat-filter.principal-session-nameStringNoneuserSession user attribute name.
lodsve.rdbms.druid.web-stat-filter.principal-cookie-nameStringNoneuserCookie username.
lodsve.rdbms.druid.web-stat-filter.profile-enableStringNonefalseWhether to enable Profile, the source code type is String.

Druid Filter

The corresponding Filter is created when enabled is true below; the remaining properties are directly bound to the third-party Druid JavaBean, and the fields change with the Druid version.

Configuration itemsTypeDefault valueExample valueDescription
lodsve.rdbms.druid.filter.stat.enabledbooleanfalse (metadata hint true)trueCreate StatFilter.
lodsve.rdbms.druid.filter.config.enabledbooleanfalsefalseCreate ConfigFilter.
lodsve.rdbms.druid.filter.encoding.enabledbooleanfalsefalseCreate EncodingConvertFilter.
lodsve.rdbms.druid.filter.slf4j.enabledbooleanfalsefalseCreate Slf4jLogFilter.
lodsve.rdbms.druid.filter.log4j.enabledbooleanfalsefalseCreate Log4jFilter.
lodsve.rdbms.druid.filter.log4j2.enabledbooleanfalsefalseCreate Log4j2Filter.
lodsve.rdbms.druid.filter.commons-log.enabledbooleanfalsefalseCreate CommonsLogFilter.
lodsve.rdbms.druid.filter.wall.enabledbooleanfalsetrueCreate WallFilter.
lodsve.rdbms.druid.filter.wall.config.*Druid WallConfigDetermined by Druidmulti-statement-allow: falseSQL firewall rules.
lodsve.rdbms.druid.filter.stat.* etc.Corresponds to Druid Filter JavaBeanDetermined by Druidlog-slow-sql: trueFields except enabled are defined by third-party classes.

Druid 1.2.1 metadata also provides db-type hints for StatFilter and WallConfig. The enumeration values of the two configuration items are the same:

Configuration itemsTypeDefault valueExample valueDescription
lodsve.rdbms.druid.filter.stat.db-typeStringDetermined by DruidmysqlStatFilter The database type used for statistics.
lodsve.rdbms.druid.filter.wall.db-typeStringDetermined by DruidmysqlThe type of database used by WallConfig.

Druid db-type enumeration

valuemeaning
db2IBM Db2.
postgresqlPostgreSQL.
sqlserverMicrosoft SQL Server.
oracleOracle.
AliOracleAlibaba Cloud Oracle compatible type.
mysqlMySQL.
mariadbMariaDB.
hiveApache Hive.
h2H2.
dmDameng database.
kingbaseKingbaseES.
oceanbaseOceanBase.
xuguVirtual Valley Database.
odpsMaxCompute / ODPS.
teradataTeradata.
log4jdbcLog4jdbc proxy database type.
phoenixApache Phoenix.
edbEDB.
kylinApache Kylin.
sqliteSQLite.
otherOther databases.
jtdsjTDS.
hsqlHSQLDB.
derbyApache Derby.
gbaseGBase.
informixIBM Informix.
adsAnalyticDB / ADS.
prestoPresto.
elastic_searchElasticsearch.
hbaseApache HBase.
drdsDRDS.
clickhouseClickHouse.
blinkBlink.
antsparkAntSpark.
oceanbase_oracleOceanBase Oracle mode.
polardbPolarDB.
ali_oracleAlibaba Cloud Oracle compatible type.
mockMock database.
sybaseSybase.
ingresIngres.
cloudscapeCloudscape.
timestenTimesTen.
as400IBM AS/400.
sapdbSAP DB.
kdbkdb+.
firebirdsqlFirebird.
JSQLConnectJSQLConnect.
JTurboJTurbo.
interbaseInterBase.
pointbasePointBase.
edbcEDBC.
mimerMimer SQL.

filter.stat.*, filter.config.*, filter.encoding.*, filter.slf4j.*, filter.log4j.*, filter.log4j2.*, filter.commons-log.* and filter.wall.config.* will directly bind the public setter of Druid 1.2.1 corresponding JavaBean. The detailed table on this page is expanded based on the current build metadata; these fields are not Lodsve custom fields, and the new version of JavaBeans and metadata should prevail after upgrading Druid.

Druid 1.2.1 Property Details

The following table lists each bindable property exposed by Druid 1.2.1 based on the spring-configuration-metadata.json generated by the project build. A default value of “Determined by Druid” means that the property has no default value declared by Lodsve or metadata; the example values are only used to illustrate the format.

Configuration itemsTypeDefault valueExample valueDescription
lodsve.rdbms.druid.filter.commons-log.connection-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.connection-commit-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.connection-connect-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.connection-connect-before-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.connection-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.connection-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.connection-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.commons-log.connection-rollback-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.data-source-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.data-source-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.commons-log.result-set-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.result-set-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.result-set-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.result-set-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.commons-log.result-set-next-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.result-set-open-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-create-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-executable-sql-log-enableBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-execute-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-execute-batch-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-execute-query-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-execute-update-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.commons-log.statement-parameter-clear-log-enableBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-parameter-set-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-prepare-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-prepare-call-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.commons-log.statement-sql-format-optionDruid sql.SQLUtils$FormatOptionDetermined by Druidpretty-format: trueSQL formatting options object.
lodsve.rdbms.druid.filter.commons-log.statement-sql-pretty-formatBooleanDetermined by DruidtrueWhether to format the SQL log.
lodsve.rdbms.druid.filter.log4j.connection-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.connection-commit-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.connection-connect-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.connection-connect-before-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.connection-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.connection-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.connection-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.log4j.connection-rollback-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.data-source-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.data-source-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.log4j.result-set-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.result-set-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.result-set-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.result-set-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.log4j.result-set-next-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.result-set-open-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-create-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-executable-sql-log-enableBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-execute-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-execute-batch-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-execute-query-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-execute-update-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.log4j.statement-parameter-clear-log-enableBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-parameter-set-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-prepare-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-prepare-call-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j.statement-sql-format-optionDruid sql.SQLUtils$FormatOptionDetermined by Druidpretty-format: trueSQL formatting options object.
lodsve.rdbms.druid.filter.log4j.statement-sql-pretty-formatBooleanDetermined by DruidtrueWhether to format the SQL log.
lodsve.rdbms.druid.filter.log4j2.connection-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.connection-commit-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.connection-connect-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.connection-connect-before-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.connection-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.connection-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.connection-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.log4j2.connection-rollback-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.data-source-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.data-source-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.log4j2.result-set-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.result-set-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.result-set-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.result-set-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.log4j2.result-set-next-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.result-set-open-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-create-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-executable-sql-log-enableBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-execute-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-execute-batch-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-execute-query-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-execute-update-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.log4j2.statement-parameter-clear-log-enableBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-parameter-set-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-prepare-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-prepare-call-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.log4j2.statement-sql-format-optionDruid sql.SQLUtils$FormatOptionDetermined by Druidpretty-format: trueSQL formatting options object.
lodsve.rdbms.druid.filter.log4j2.statement-sql-pretty-formatBooleanDetermined by DruidtrueWhether to format the SQL log.
lodsve.rdbms.druid.filter.slf4j.connection-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.connection-commit-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.connection-connect-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.connection-connect-before-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.connection-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.connection-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.connection-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.slf4j.connection-rollback-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.data-source-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.data-source-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.slf4j.result-set-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.result-set-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.result-set-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.result-set-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.slf4j.result-set-next-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.result-set-open-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-close-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-create-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-executable-sql-log-enableBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-execute-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-execute-batch-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-execute-query-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-execute-update-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-log-error-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-logger-nameStringDetermined by Druidcom.example.sqlLogger name.
lodsve.rdbms.druid.filter.slf4j.statement-parameter-clear-log-enableBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-parameter-set-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-prepare-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-prepare-call-after-log-enabledBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.slf4j.statement-sql-format-optionDruid sql.SQLUtils$FormatOptionDetermined by Druidpretty-format: trueSQL formatting options object.
lodsve.rdbms.druid.filter.slf4j.statement-sql-pretty-formatBooleanDetermined by DruidtrueWhether to format the SQL log.
lodsve.rdbms.druid.filter.stat.connection-stack-trace-enableBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.stat.log-slow-sqlBooleanDetermined by DruidtrueDruid JavaBean configuration items.
lodsve.rdbms.druid.filter.stat.merge-sqlBooleanDetermined by DruidtrueDruid JavaBean configuration items.
lodsve.rdbms.druid.filter.stat.slow-sql-millisLongDetermined by Druid3000Slow SQL threshold in milliseconds.
lodsve.rdbms.druid.filter.wall.configDruid wall.WallConfigDetermined by DruidExample valueDruid JavaBean configuration items.
lodsve.rdbms.druid.filter.wall.config.alter-table-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.block-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.call-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.case-condition-const-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.comment-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.commit-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.complete-insert-values-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.condition-and-alway-false-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.condition-and-alway-true-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.condition-double-const-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.condition-like-true-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.condition-op-bitwse-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.condition-op-xor-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.const-arithmetic-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.create-table-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.delete-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.delete-where-alway-true-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.delete-where-none-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.deny-functionsSet<String>Determined by Druid[item]A collection of forbidden objects.
lodsve.rdbms.druid.filter.wall.config.deny-objectsSet<String>Determined by Druid[item]A collection of forbidden objects.
lodsve.rdbms.druid.filter.wall.config.deny-schemasSet<String>Determined by Druid[item]A collection of forbidden objects.
lodsve.rdbms.druid.filter.wall.config.deny-tablesSet<String>Determined by Druid[item]A collection of forbidden objects.
lodsve.rdbms.druid.filter.wall.config.deny-variantsSet<String>Determined by Druid[item]A collection of forbidden objects.
lodsve.rdbms.druid.filter.wall.config.describe-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.dirStringDetermined by Druidclasspath:/druidDruid configuration file directory.
lodsve.rdbms.druid.filter.wall.config.do-privileged-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.drop-table-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.function-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.hint-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.initedBooleanDetermined by DruidtrueDruid JavaBean configuration items.
lodsve.rdbms.druid.filter.wall.config.insert-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.insert-values-check-sizeIntegerDetermined by Druid3000INSERT VALUES checks the upper limit of the number.
lodsve.rdbms.druid.filter.wall.config.intersect-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.limit-zero-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.lock-table-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.merge-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.metadata-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.minus-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.multi-statement-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.must-parameterizedBooleanDetermined by DruidtrueWhether to require SQL parameterization.
lodsve.rdbms.druid.filter.wall.config.none-base-statement-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.object-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.permit-functionsSet<String>Determined by Druid[item]A collection of objects that are allowed access.
lodsve.rdbms.druid.filter.wall.config.permit-schemasSet<String>Determined by Druid[item]A collection of objects that are allowed access.
lodsve.rdbms.druid.filter.wall.config.permit-tablesSet<String>Determined by Druid[item]A collection of objects that are allowed access.
lodsve.rdbms.druid.filter.wall.config.permit-variantsSet<String>Determined by Druid[item]A collection of objects that are allowed access.
lodsve.rdbms.druid.filter.wall.config.read-only-tablesSet<String>Determined by Druid[item]Read-only collection of table names.
lodsve.rdbms.druid.filter.wall.config.rename-table-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.replace-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.rollback-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.schema-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.select-all-column-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.select-except-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.select-having-alway-true-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.select-intersect-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.select-into-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.select-into-outfile-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.select-limitIntegerDetermined by Druid3000The maximum number of rows returned by the query.
lodsve.rdbms.druid.filter.wall.config.select-minus-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.select-union-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.select-where-alway-true-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.selelct-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.set-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.show-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.start-transaction-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.strict-syntax-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.table-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.tenant-columnStringDetermined by Druidtenant_idTenant isolation configuration.
lodsve.rdbms.druid.filter.wall.config.tenant-table-patternStringDetermined by Druidtenant_%Tenant isolation configuration.
lodsve.rdbms.druid.filter.wall.config.truncate-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.update-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.update-check-handlerDruid wall.WallUpdateCheckHandlerDetermined by DruidCustom beanCustom update check handler.
lodsve.rdbms.druid.filter.wall.config.update-where-alay-true-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.update-where-none-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.use-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.config.variant-checkBooleanDetermined by DruidtrueWhether to enable corresponding checking or logging.
lodsve.rdbms.druid.filter.wall.config.wrap-allowBooleanDetermined by DruidtrueWhether the corresponding SQL operation is allowed.
lodsve.rdbms.druid.filter.wall.log-violationBooleanDetermined by DruidtrueWhether to log SQL Firewall violations.
lodsve.rdbms.druid.filter.wall.provider-white-listSet<String>Determined by Druid[item]Provider whitelist.
lodsve.rdbms.druid.filter.wall.tenant-columnStringDetermined by Druidtenant_idTenant isolation configuration.
lodsve.rdbms.druid.filter.wall.throw-exceptionBooleanDetermined by DruidtrueWhether to throw an exception when a SQL Firewall violation occurs.
Architecture diagram