Solving the Column "REAL" not found Exception in H2 Db with Spring Boot

Learn how to resolve the common `JdbcSQLSyntaxErrorException: Column "REAL" not found` error when inserting records in H2 Db using Spring Boot. Discover the importance of correct SQL syntax and tips for debugging. --- This video is based on the question https://stackoverflow.com/q/73401778/ asked by the user 'Ajit Kumar Singh' ( https://stackoverflow.com/u/13824452/ ) and on the answer https://stackoverflow.com/a/73402553/ provided by the user 'Evgenij Ryazanov' ( https://stackoverflow.com/u/11731987/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions. Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: H2 Db, Column " not found" exception Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l... The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license. If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com. --- Understanding the Column "REAL" not found Exception in H2 Db When developing applications with Spring Boot, working with databases can sometimes lead to perplexing issues. One such issue is the JdbcSQLSyntaxErrorException: Column "REAL" not found exception encountered while attempting to insert records into H2 Db. If you are facing this problem, you're not alone. Let's dig deeper into what could cause this error and how to resolve it. The Problem: What Does the Exception Mean? When you attempt to insert records into a database table using an SQL query, you expect your values to be properly recognized and inserted into the appropriate columns. In this scenario, using the following SQL query: [[See Video to Reveal this Text or Code Snippet]] The exception indicates that the database is unable to find a column named "REAL." However, the intention was to place "REAL" as a value in the terminal_type column. This misinterpretation happens due to incorrect SQL syntax. The Solution: Correcting SQL Syntax Understanding Identifiers and String Literals In SQL, values must be enclosed in single quotes, while identifiers, such as column names, should not. The confusion arises when you use double quotes for values, leading the database to interpret these as column identifiers instead of string literals. Fixing Your Query To fix the error, you need to adjust your insert statement to properly use single quotes for string literals. Here's how to do it: [[See Video to Reveal this Text or Code Snippet]] Key Changes Made Replaced "REAL" with 'REAL' and "INTERNAL" with 'INTERNAL'. Ensured that all string literals are correctly enclosed in single quotes for SQL compliance. Conclusion By understanding the correct use of quotes in SQL syntax, you can resolve issues like the JdbcSQLSyntaxErrorException: Column "REAL" not found efficiently. Always remember to use single quotes for string values, while keeping identifiers free from quotes. This knowledge will greatly enhance your debugging skills as you work with databases in your Spring Boot applications. Feel free to use this guide whenever you encounter similar issues and share it with fellow developers who might benefit from it!