org.springframework.orm.hibernate3.HibernateSystemException: No Dialect mapping

[留下买路财]

org.springframework.orm.hibernate3.HibernateSystemException: No Dialect mapping for JDBC type: -9; nested exception is org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:679)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
哪位大侠知道这是什么错吗？找了半天找不出来错在哪里，我的方言配置好了

<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					org.hibernate.dialect.SQLServerDialect
				</prop>
				<prop key="hibernate.show_sql">
					true
				</prop>
			</props>
		</property>

[zhou961270]

dialect 配置不对,到网上去查一下SqlServer的dialect 再贴过来

[淫生杯具]

<prop key="hibernate.dialect">
net.sf.hibernate.dialect.SQLServerDialect
</prop>
试试这个，楼主的hibernateProperties属性比较少啊

[留下买路财]

不是这么配的？我一直都是这样配的，而且运行也没问题，但是一用到getHibernateTemplate().execute(
new HibernateCallback(){})回调用本地Sql查询就出错了

super.getHibernateTemplate().execute(new HibernateCallback() {

			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				// TODO Auto-generated method stub
                                String newSql="select * from v_orders ";
				SQLQuery query = session.createSQLQuery(newSql);
				System.out.println(newSql);
			
				query.addEntity(VOrders.class);
				List<VOrders> objs = query.list();
				return objs;
			}
		});

[留下买路财]

hibernate2.jar和hibernate3.jar包结构完全不同
例如：hibernate2中的net.sf.hibernate.dialect.SQLServerDialect
在hibernater3中变成了org.hibernate.dialect.SQLServerDialect
我用的是hibernater3