Springboot-application.xml Configurable Properties Summary (DataSource and JPA)

############################################ #datasource ############################################# Spring.datasource.url:mysql Address # # #spring. Datasource.user: Database user name # # #spring. Datasource.password: Database Password # # # Spring.datasource.driverClassName: Corresponding database driver # # #spring. Datasource.max-active: Specifies the maximum number of active connections in the Connection pool # # # Spring.datasource.max-idle: Specify the maximum number of idle connections in the connection pool # # #spring. Datasource.min-idle: Specifies the minimum value that must remain connected (for DBCP and Tomcat connection Pools) # # #spring. Datasource.initial-size: Specifies the number of initially established connections ############################################ #其他信息总结 when starting connection pooling #  ########################################### #spring. dao.exceptiontranslation.enabled  If Persistenceexceptiontranslationpostprocessor is turned on, the default is true## #spring. datasource.abandon-when-percentage-full Set the percentage of time-outs that are discarded to be closed or escalated # # #spring. datasource.allow-pool-suspension If the connection pool is allowed to pause when using Hikari pool, the default is: false### Spring.datasource.alternate-username-allowed whether to allow alternate user names # # #spring. DATASOURCE.AUTO-COMMIT Specifies whether updates are automatically committed. # # #  SPRING.DATASOURCE.CATALOG Specifies the default catalog.## #spring. Datasource.commit-on-returnSets whether to commit all outstanding transactions when the connection is returned # # #spring. DATASOURCE.CONNECTION-INIT-SQL Specifies that the connection is created and then added to the connection pool before the sql.### is executed SPRING.DATASOURCE.CONNECTION-INIT-SQLS when using DBCP connection pool, specify the sql### to be executed when initializing Spring.datasource.connection-properties. [Key] Specifies the property to configure when using DBCP Connection Pool # # #spring. datasource.connection-test-query specifies the SQL statement that verifies the validity of the connection # # # SPRING.DATASOURCE.CONNECTION-TIMEOUT Specifies the timeout period for the connection, in milliseconds. # # #spring. datasource.continue-on-error when initializing the database, if the error continues, The default false## #spring. DATASOURCE.DATA Specifies the data (DML) script # # #spring. DATASOURCE.DATA-SOURCE-CLASS-NAME Specifies the fully qualified name of the DataSource. # # # SPRING.DATASOURCE.DATA-SOURCE-JNDI Specifies the address of Jndi # # #spring. Datasource.data-source-properties. When [key] uses Hikari connection pool, specify the property to be set in # # #spring. datasource.db-properties use the Tomcat connection pool to specify the properties to set # # # Spring.datasource.default-auto-commit is automatically submitted. # # #spring. Datasource.default-catalog Specify the default catalog.### for the connection Spring.datasource.default-read-only whether the default connection is set to read-only. # # #spring. datasource.default-transaction-isolation Specifies the default isolation level for connected transactions . # # #spring. Datasource.driver-class-name Specify DrivThe class name of ER, which is automatically probed from the JDBC URL by default. # # #spring. Datasource.fair-queue whether to return the connection using FIFO. # # #spring. datasource.health-check-properties . When [key] uses the Hikari connection pool, the properties passed during Heartbeat check # # #spring. datasource.idle-timeout Specifies how long the connection is not being used, is set to idle, and the default is 10ms### Spring.datasource.ignore-exception-on-pre-load whether the exception is ignored when the connection pool is initialized. # # #spring. Datasource.init-sql When a connection is created, the sql### that is executed SPRING.DATASOURCE.INITIAL-SIZE Specifies the number of connections that are initially established when you start a connection pool # # #spring. datasource.initialization-fail-fast When you create a connection pool, Unable to create specifies whether the minimum number of connections is thrown #spring. datasource.initialize Specifies the initialization data source, whether initialized with Data.sql, default: true### SPRING.DATASOURCE.ISOLATE-INTERNAL-QUERIES Specifies whether the internal query is to be quarantined, and the default is false## #spring. Datasource.jdbc-interceptors using Tomcat Connection pool, specify the JDBC Interceptor, semicolon Delimited # # #spring. Datasource.jdbc-url Specifies the JDBC url.## #spring. datasource.jmx-enabled whether to turn on JMX, The default is: false## #spring. datasource.jndi-name Specifies the name of the Jndi. # # #spring. Datasource.leak-detection-threshold use Hikari Connection pool, how many milliseconds to detect a connection leak. # # #spring. datasource.log-abandoned uses DBCP connection pool, whether to track obsolete statement or connections, by default: false## #spring. DataSource.Log-validation-errors If you are using the Tomcat connection pool, print a checksum error. # # #spring. datasource.login-timeout Specifies the time-out for connecting to the database. # # # SPRING.DATASOURCE.MAX-AGE Specifies the maximum age of connections in a connection pool # # #spring. datasource.max-lifetime Specifies the maximum lifetime of connections in a connection pool, in milliseconds. # # #  spring.datasource.max-open-prepared-statements Specifies the maximum number of open prepared statements. # # #spring. datasource.max-wait Specifies the maximum wait time, in milliseconds, that the connection pool waits for a connection to return. # # #spring. datasource.maximum-pool-size Specifies the maximum number of connections for the connection pool, including in-use and idle connections. # # # Spring.datasource.min-evictable-idle-time-millis Specifies how long an idle connection can be cleared after minimum idle time. # # #spring. datasource.min-idle Specifies the minimum value that must remain connected ( For DBCP and Tomcat Connection pools) # # #spring. datasource.minimum-idle Specifies the minimum number of idle connections maintained by the connection, as specified when using HIKARICP. # # # SPRING.DATASOURCE.NAME Specifies the data source name. # # #spring. Datasource.num-tests-per-eviction-run Specifies the number of objects when running each idle object Evictor thread # # # SPRING.DATASOURCE.PASSWORD Specifies the database password. # # #spring. Datasource.platform Specifies the platform (schema-${platform}.sql) to use for the schema, The default is: all## #spring. datasource.pool-name Specifies the connection pool name. # # #spring. datasource.pool-prepared-statements Specifies whether to pool statements.### Spring.datasource.propagate-iNterrupt-state if the thread is interrupted while waiting for a connection, whether the interrupt state is propagated. # # #spring. datasource.read-only when using Hikari connection pool, whether to mark data source read-only # # #  Spring.datasource.register-mbeans Specifies whether the Hikari connection pool is registered with JMX mbeans.## #spring. datasource.remove-abandoned Specifies whether to delete the connection immediately if the connection exceeds the obsolete time-out. # # #spring. datasource.remove-abandoned-timeout Specifies the time that the connection should be discarded. # # # Spring.datasource.rollback-on-return whether the pending transaction is rolled back when the connection is returned. # # #spring. Datasource.schema Specifies the schema (DDL) script. # # # SPRING.DATASOURCE.SEPARATOR Specifies the statement delimiter for the initialization script, default:; # # #spring. datasource.sql-script-encoding specifies the SQL scripts encoding. # # # SPRING.DATASOURCE.SUSPECT-TIMEOUT Specifies the time-out before printing an obsolete connection. # # #spring. Datasource.test-on-borrow whether to test the connection when borrowing the connection from the connection pool. # # # When Spring.datasource.test-on-connect is created, test the connection # # #spring. Datasource.test-on-return whether the connection is tested when the connection is returned to the connection pool. # # #  Spring.datasource.test-while-idle whether to perform a connection test when the connection is idle. # # #spring. Datasource.time-between-eviction-runs-millis Specifies the interval between idle connection checks, obsolete connection cleanup, and idle connection pool sizing # # #spring. datasource.transaction-isolation Specifies the transaction isolation level, specified when using Hikari connection pool # # #spring. Datasource.url Specify the JDBC url.## #sPring.datasource.use-disposable-connection-facade whether the connection is wrapped to prevent it from being used after the connection is closed. # # #spring. datasource.use-equals Whether to use String.Equals () to replace the ==.## #spring when comparing method names. Datasource.use-lock whether to lock the connection operation # # #spring. Datasource.username Specify the database name. # # # SPRING.DATASOURCE.VALIDATION-INTERVAL Specifies how many MS to perform a connection check. # # #spring. datasource.validation-query specifies the SQL query statement that gets the connection checksum when the connection is obtained. # # #spring. datasource.validation-query-timeout Specifies the time-out for the connection check query. # # #spring. Datasource.validation-timeout set the time-out for the connection check, Specify # # #spring when using Hikari connection pool. Datasource.validator-class-name is used to test the validator fully qualified name of the query. # # # Spring.datasource.xa.data-source-class-name the fully qualified name of the specified data source. # # #spring. datasource.xa.properties Specifies the attribute passed to XA data source # # ######################################### #SPring JPA configuration information ############################################# SPRING.JPA.DATABASE Specifies the target database. # # #spring. jps.show-sq whether to display the SQL statement # # #spring. JPA.HIBERNATE.DDL-AUTO Specifies DDL mode (none, Validate, update, create, Create-drop). When using an inline database, the default is Create-drop, otherwise the none.## #spring. jpa.hibernate.naming-strategy specifies a naming policy. ############################################ #其他 ############################################ #spring. Jpa.database-platform Specifies the type of the target database. # # #spring. Jpa.generate-ddl whether the schema is initialized at startup, and the default is false## #spring. JPA.HIBERNATE.DDL-AUTO Specifies DDL mode (none, Validate, update, create, Create-drop).  When using an inline database, the default is Create-drop, otherwise the none.## #spring. jpa.hibernate.naming-strategy specifies a naming policy. # # #spring. Jpa.open-in-view Whether to register Openentitymanagerinviewinterceptor, bind JPA Entitymanager to the request thread, default to: true## #spring. jpa.properties add additional attributes to JPA provider.## #spring. Jpa.show-sql whether to open SQL log, the default is: false##########################################

Springboot-application.xml Configurable Properties Summary (DataSource and JPA)