Spring Boot 2.7连接H2数据库报错:找不到mem:testdb求解决
H2控制台连接错误:Database “mem:testdb” not found 排查求助
我在尝试连接H2控制台时遇到如下错误:
Database “mem:testdb” not found, either pre-create it or allow remote database creation.
我做了以下排查但问题仍未解决:
- 查阅过类似问题的解决方案,说需要复制控制台显示的JDBC URL,但我的控制台没有这个提示(附截图)。
- 检查过
application.properties配置(附截图),尝试添加spring.datasource.generate-unique-name=false但无效。 - 确认POM文件中H2依赖、devtools等均已正确添加(项目通过Spring Initializr创建),POM配置如下:
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.7.11</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.qindel</groupId> <artifactId>test</artifactId> <version>0.0.1-SNAPSHOT</version> <name>test</name> <description>Prueba técnica Plataforma</description> <properties> <java.version>11</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>com.h2database</groupId> <artifactId>h2</artifactId> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <configuration> <excludes> <exclude> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </exclude> </excludes> </configuration> </plugin> </plugins> </build> </project>
请问有什么解决思路吗?
内容的提问来源于stack exchange,提问作者sergio rodriguez
相关产品推荐
相关产品推荐

