MySQL Forums
Forum List  »  Newbie

use mysql-connecotor-j:8.0.33,I found an SQL execution exception
Posted by: lionel xiu
Date: April 25, 2024 02:55AM

We use the mybatis plugin to write an SQL statement, for example: insert into table (id, beforeJson, afterJson) values (null, "", ""), where the types in the beforeJson and afterJson databases are text. In the mapper file, the jdbcType for beforeJson and afterJson in values is specified as LONGVARCHAR. When executing SQL in the code, the following exception is reported: Unknown column '0x'in' field list ', jdk version is 1.8, and jdbc version is org.springframework.boot:spring-boot-starter-jdbc:2.1.18.RELEASE, MySQL driver version is mysql:mysql-connector-java:8.0.33

Options: ReplyQuote


Subject
Written By
Posted
use mysql-connecotor-j:8.0.33,I found an SQL execution exception
April 25, 2024 02:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.