datasource.properties 2.9 KB
Newer Older
B
bao liang 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements.  See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License.  You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
17 18
        
# postgresql
Q
qiaozhanwei 已提交
19 20
spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.url=jdbc:postgresql://localhost:5432/dolphinscheduler
21 22
spring.datasource.username=test
spring.datasource.password=test
23

L
lgcareer 已提交
24
# connection configuration
25
#spring.datasource.initialSize=5
L
lgcareer 已提交
26
# min connection number
27
#spring.datasource.minIdle=5
L
lgcareer 已提交
28
# max connection number
29
#spring.datasource.maxActive=50
L
lgcareer 已提交
30 31 32

# max wait time for get a connection in milliseconds. if configuring maxWait, fair locks are enabled by default and concurrency efficiency decreases.
# If necessary, unfair locks can be used by configuring the useUnfairLock attribute to true.
33
#spring.datasource.maxWait=60000
L
lgcareer 已提交
34 35

# milliseconds for check to close free connections
36
#spring.datasource.timeBetweenEvictionRunsMillis=60000
L
lgcareer 已提交
37 38

# the Destroy thread detects the connection interval and closes the physical connection in milliseconds if the connection idle time is greater than or equal to minEvictableIdleTimeMillis.
39
#spring.datasource.timeBetweenConnectErrorMillis=60000
L
lgcareer 已提交
40 41

# the longest time a connection remains idle without being evicted, in milliseconds
42
#spring.datasource.minEvictableIdleTimeMillis=300000
L
lgcareer 已提交
43 44

#the SQL used to check whether the connection is valid requires a query statement. If validation Query is null, testOnBorrow, testOnReturn, and testWhileIdle will not work.
45
#spring.datasource.validationQuery=SELECT 1
L
lgcareer 已提交
46 47

#check whether the connection is valid for timeout, in seconds
48
#spring.datasource.validationQueryTimeout=3
L
lgcareer 已提交
49 50 51

# when applying for a connection, if it is detected that the connection is idle longer than time Between Eviction Runs Millis,
# validation Query is performed to check whether the connection is valid
52
#spring.datasource.testWhileIdle=true
L
lgcareer 已提交
53 54

#execute validation to check if the connection is valid when applying for a connection
55
#spring.datasource.testOnBorrow=true
L
lgcareer 已提交
56
#execute validation to check if the connection is valid when the connection is returned
57 58 59
#spring.datasource.testOnReturn=false
#spring.datasource.defaultAutoCommit=true
#spring.datasource.keepAlive=true
L
lgcareer 已提交
60 61

# open PSCache, specify count PSCache for every connection
62
#spring.datasource.poolPreparedStatements=true
D
dailidong 已提交
63
#spring.datasource.maxPoolPreparedStatementPerConnectionSize=20