Springboot project integrates Durid data source and P6Spy and dbType not support problems

In the project development stage, the SQL printing of mybatis has placeholders, and debugging is still a bit cumbersome. If you want to integrate P6Spy to print SQL that can be directly executed, it is convenient for debugging, and the Durid connection pool is used. Springboot project integrates Durid <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.2.18</version> </dependency> Configuration […]

Solve Cause: java.sql.SQLException: sql injection violation, dbType mysql … token IDENTIFIER deleted error

Article directory 1. Reproduce the error 2. Analysis errors 3. Fix bugs 4. Other ways to resolve this error 4.1 Method description 4.2 Table creation specification 5. Supplementary Notes This article not only helps you solve the error, but also helps you analyze the cause of the error 1. Reproduce the error After writing the […]