SpringBoot integrated H2 database cannot make local connection?

recently I tried to use SpringBoot + JPA + H2 database. In application.properties, I configured the database connection 

spring.datasource.url=jdbc:h2:tcp://localhost/D:/H2DataBase/DB/test;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE

but after starting the program, the console output is connected to memory mode, and the output is as follows: 

Starting embedded database: url="jdbc:h2:mem:testdb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false", username="sa"

Why does this happen? is there an error in the database connection to URL? How to solve? Thank you.

Java
Mar.22,2021

because you use tcp mode and add the auto_server=true parameter, springboot automatically starts H2 in mem mode, but this is not a common H2 mode. H2 is an embedded database and usually should use file or mem mode, so the url, of jdbc should be:

spring.datasource.url=jdbc:h2:file:yourdbname

mem mode is recommended by some books or websites, but I think file mode is better, so that the data saved during development and debugging can be retained after restarting the application, and the file mode is stable and there is no problem. Just keep in mind that the production environment should never be used for h _ 2ame. H _ 2 should only be used for development.

Previous: The result parsed by json.Unmarshal is empty.

Next: Why does the official website of linux kernel version 4.17.3 call it a stable version?

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1eaf299-2231.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1eaf299-2231.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?