com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or variable #9: Cannot find data type json

Question

Wanted to create JSON field using Spring boot entity class in SQL Server. Below is the column name

@Column(name = "personalDetails", columnDefinition = "json")
@JsonRawValue
String personalDetails;

but I am getting the following error.

com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or variable #9: Cannot find data type json

JSON isn't a data type in SQL Server; the error is telling you the problem. If you want to store JSON data (in SQL Server), do so in an nvarchar(MAX). — Thom A
– Thom A ♦, Commented Apr 19, 2021 at 9:25

gantoin · Accepted Answer · 2021-04-19 09:34:44Z

1

JSON isn't a data type in SQL Server; the error is telling you the problem. If you want to store JSON data (in SQL Server), do so in an nvarchar(MAX).

Solved here

answered Apr 19, 2021 at 9:34

gantoin

2053 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or variable #9: Cannot find data type json

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related