No Dialect mapping for JDBC type: -9
场景:关于No Dialect mapping for JDBC type :9 hibernate执行原生sql语句有关问题
关于No Dialect mapping for JDBC type :-9 hibernate执行原生sql语句问题
原因和参考: http://blog.****.net/xd195666916/article/details/5419316
关于No Dialect mapping for JDBC type :-9 hibernate执行原生sql语句问题
原因和参考: http://blog.****.net/xd195666916/article/details/5419316
package com.asl.cityu.common; import java.sql.Types; import org.hibernate.Hibernate; import org.hibernate.dialect.SQLServerDialect; public class SqlServer2008Dialect extends SQLServerDialect { public SqlServer2008Dialect() { super(); registerHibernateType(1, "string"); registerHibernateType(-9, "string"); registerHibernateType(-16, "string"); registerHibernateType(3, "double"); registerHibernateType(Types.CHAR, Hibernate.STRING.getName()); registerHibernateType(Types.NVARCHAR, Hibernate.STRING.getName()); registerHibernateType(Types.LONGNVARCHAR, Hibernate.STRING.getName()); registerHibernateType(Types.DECIMAL, Hibernate.DOUBLE.getName()); } }
<?xml version="1.0" encoding="UTF-8" ?> <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0"> <persistence-unit name="DateSource"> <jta-data-source>java:/SqlServerDS</jta-data-source> <properties> <property name="hibernate.dialect" value="com.asl.cityu.common.SqlServer2008Dialect"/> <property name="hibernate.hbm2ddl.auto" value="none" /> </properties> </persistence-unit> </persistence>