关于No Dialect mapping for JDBC type :-9 hibernate执行原生sql语句问题
原因和参考: http://blog.csdn.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>