org.hibernate.MappingException:

使用hibernate 原生sql时

image.png

数据库中类型若为nvarchar 则返回的类型 无法转为Java String类型

image.png

此时 可以配置自定义方言

image.png image.png

或者spring boot yml指定

public final static int BIT   =  -7;
public final static int TINYINT  =  -6;
public final static int SMALLINT =   5;
public final static int INTEGER  =   4;
public final static int BIGINT   =  -5;
public final static int FLOAT   =   6;
public final static int REAL   =   7;
public final static int DOUBLE   =   8;
public final static int NUMERIC  =   2;
public final static int DECIMAL  =   3;
public final static int CHAR  =   1;
public final static int VARCHAR  =  12;
public final static int LONGVARCHAR  =  -1;
public final static int DATE   =  91;
public final static int TIME   =  92;
public final static int TIMESTAMP  =  93;
public final static int BINARY  =  -2;
public final static int VARBINARY  =  -3;
public final static int LONGVARBINARY  =  -4;
public final static int NULL  =   0;
public final static int OTHER  = 1111;
public final static int JAVA_OBJECT        = 2000;
public final static int DISTINCT          = 2001;
public final static int STRUCT            = 2002;
public final static int ARRAY             = 2003;
public final static int BLOB             = 2004;
public final static int CLOB             = 2005;
public final static int REF              = 2006;
public final static int DATALINK = 70;
public final static int BOOLEAN = 16;
public final static int ROWID = -8;
public static final int NCHAR = -15;
public static final int NVARCHAR = -9;
public static final int LONGNVARCHAR = -16;
public static final int NCLOB = 2011;
public static final int SQLXML = 2009;