Spring Boot连接外部H2数据库异常及表不显示问题排查求助

Let's break down the problems you're facing and fix them one by one—this stuff can be tricky when you're switching from in-memory to external H2, but we'll get it sorted:

1. Why Wrong URL/Username Still Connects? #

The biggest issue here is your configuration prefix. You’re using spring.h2.* but Spring Boot’s default datasource properties rely on the spring.datasource.* prefix. When you use the wrong prefix, Spring Boot completely ignores your custom settings and falls back to its default in-memory H2 database—that’s why even bad credentials work!

Fix this by updating your application.properties to use the correct prefix, plus adjust the URL for external server access:

spring.datasource.driverClassName=org.h2.Driver
# Use TCP protocol to connect to your external H2 server on port 8082
spring.datasource.url=jdbc:h2:tcp://localhost:8082/~/test2;DB_CLOSE_ON_EXIT=FALSE;AUTO_RECONNECT=TRUE
spring.datasource.username=QW
spring.datasource.password=root
spring.h2.console.enabled=true
spring.datasource.platform=h2

Note the tcp://localhost:8082 in the URL—your original file-based URL would create/access a local file on your app’s machine, not the external H2 server’s database.

2. Why Can’t You See Entity Tables? #

Once your datasource is correctly configured, check these key points:

• Enable Auto-Table Creation: Add this property to tell Hibernate to generate tables from your @Entity classes:

  spring.jpa.hibernate.ddl-auto=update
  

  Use create for testing (fresh tables every startup) or update to preserve existing data.

• Entity Package Scanning: Make sure your @Entity classes live in a package that Spring Boot scans. If your main app class is in com.example.myapp, entities should be in com.example.myapp.entity or a subpackage—Spring automatically scans packages below the main class. If they’re in a separate package, add @EntityScan(basePackages = "your.entity.package") to your main application class.

• Match H2 Console Credentials: When you open the H2 console at http://localhost:8080/h2-console, use the exact same URL, username, and password from your spring.datasource config. Using the default console settings will connect you to the in-memory DB, not your external server.

3. Double-Check External H2 Server Setup #

Quick sanity checks for your H2 exe server:

• Confirm the server is running on port 8082 (open the H2 console from the exe to verify).
• Ensure the database path ~/test2 exists on the server’s machine (if it’s local, make sure the user running the H2 server has access to that directory).

Quick Validation Test #

After fixing the config:

1. Stop both your Spring Boot app and H2 server.
2. Start the H2 server first.
3. Launch your Spring Boot app.
4. Open the H2 console, enter the corrected TCP URL and credentials. You should now see your entity tables, and using wrong credentials will fail to connect (which confirms your app is now using the external DB).

内容的提问来源于stack exchange，提问作者VISHAL DHAMDE