报错：No Dialect mapping for JDBC type: -15

最新推荐文章于 2025-06-30 14:28:04 发布

转载最新推荐文章于 2025-06-30 14:28:04 发布 · 1.8k 阅读

个人知识收集同时被 2 个专栏收录

6 篇文章

订阅专栏

错误异常报告

4 篇文章

订阅专栏

本文介绍了如何解决Hibernate中由于方言配置错误导致的问题。通过调整数据库类型或使用支持的方言，可以确保Hibernate正确映射和处理数据类型。文章还提供了一个自定义MySQLServerDialect类的例子。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

错误的配置了hibernate的方言
通过查询hibernate的源码，找到问题的根本所在，就是hibernate中不支持对应的数据类型，具体数据类型的值，请查看下表

查看 java.sql.Types 类，可以找到对应类型，调整相应的数据库里的类型，或者其他支持这个类型的方言。

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

找到相对应缺少的添加进去即可

package forward.aaa.utils;

import java.sql.Types;

import org.hibernate.dialect.SQLServerDialect;
import org.hibernate.type.StandardBasicTypes;

public class MySQLServerDialect extends SQLServerDialect{
	public MySQLServerDialect () {
        super();
        registerHibernateType(1, "string");     
        registerHibernateType(-9, "string");     
        registerHibernateType(-15, "string");     
        registerHibernateType(-16, "string");     
        registerHibernateType(3, "double");  
          
        registerHibernateType(Types.CHAR, StandardBasicTypes.STRING.getName());     
        registerHibernateType(Types.NVARCHAR, StandardBasicTypes.STRING.getName());
        registerHibernateType(Types.NCHAR, StandardBasicTypes.STRING.getName()); 
        registerHibernateType(Types.LONGNVARCHAR, StandardBasicTypes.STRING.getName());     
        registerHibernateType(Types.DECIMAL, StandardBasicTypes.DOUBLE.getName());
    }
}