mysql - How to make the sql of the java project compatible with the sql syntax of multiple databases?

Question

How can the sql statements in Java projects be compatible with multiple databases? The project belongs to the product category and it is not confirmed which database the user uses. We use db2 during development, but if we encounter an oracle database, sql will fail. I don't know how to achieve compatibility with multiple databases. For example, oracle, MySQL, SQL server, db2, etc.

Answer 1

You can try using an ORM framework that supports multiple dialects.

Answer 2

Isn’t ORM the solution to this problem? It executes different sql, jpa, hibernate according to the configured database dialect