Shulou(Shulou.com)06/02 Report--

The main content of this article is to explain "Mybatis query Times wrong java.sql.SQLException: Invalid value for getInt () how to solve", interested friends might as well take a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "Mybatis query Times wrong java.sql.SQLException: Invalid value for getInt () how to solve it"!

Today, when I was doing a school project, I suddenly reported an error of 500 java.sql.SQLException: Invalid value for getInt (). I looked for it and found that it was such a problem.

First of all, there are several database fields that accidentally add spaces after the underscore

Later, when generated with the mybatis reverse generation tool, columns with spaces are automatically enclosed in double quotes (otherwise they cannot be queried), resulting in the query results being overwritten by column names.

It was originally listed as an int type, but it must have been reported as an error after it was overwritten and changed to varchar.

Solution: modify database fields and regenerate

At this point, I believe you have a deeper understanding of "Mybatis query Times wrong java.sql.SQLException: Invalid value for getInt () how to solve". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.