Shulou(Shulou.com)05/31 Report--

This article shares with you the content of a sample analysis of Mysql8.0 version-driven getTables returning all database tables. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

If you are using version 5.X driver, you need to replace Driver Class with: com.mysql.cj.jdbc.Driver

It is important to note that:

The parameters related to version 8.0 driver DataSource have changed:

For example, the 8.0 driver changes the default value of the parameter nullCatalogMeansCurrent from true to false. If you use DatabaseMetaData.getTables to get all the table information, the 8.0 driver will return the tables of all libraries.

/ / tables of all libraries are returned by default, not just the library databaseMetaData.getTables specified by datasource (null, new String [] {"TABLE"})

The solution is to change this parameter to true when the connection pool is initialized, taking HikariCP as an example:

Java Config:

HikariConfig config = new HikariConfig ();... config.addDataSourceProperty ("nullCatalogMeansCurrent", true)

Spring Boot configuration:

Spring.datasource.hikari.data-source-properties.nullCatalogMeansCurrent=true, thank you for your reading! On the "Mysql8.0 version-driven getTables return all database tables sample analysis" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.