如何在java中修复“JDBC类型的无方言映射：-1”错误 [英] How to fix “No Dialect mapping for JDBC type: -1” error in java

问题描述

我遇到一个错误如何解决此错误，即

i'm getting one error how to resolve this error i.e,

org.hibernate.MappingException: No Dialect mapping for JDBC type: -1
  at org.hibernate.dialect.TypeNames.get(TypeNames.java:56)
  at org.hibernate.dialect.TypeNames.get(TypeNames.java:81)
  at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:393)

我是尝试获取该列数据中的XML列的格式为XML

I'm trying to get XML column in that column data is in format of XML

Session session = null;
session =  getHibernateTemplate().getSessionFactory().openSession();
Query qu = session.createSQLQuery("select xml from details 
where start_date between (select * from(select eventdate from emplyoeevent 
where event='logout' and event_id in (select session_id from session 
where session_emplyoee='"+Id+"') order by eventdate asc)
where rownum=1) and TO_DATE(SYSDATE, 'DD-MON-YYYY HH:MI:SS PM')");
List li =  qu.list();

我在中收到错误列表li = qu.list（）; line。

推荐答案

对我来说，我遇到了一个未映射的MySQL表格列的问题。

With me I was having trouble with an unmapped MySQL table column.

列类型：文本

然后我必须使用addScalar（）：

Then I had to use addScalar():

Query query =  em. createNativeQuery(originalQuery);
((SQLQuery) ((HibernateQuery) query).getHibernateQuery())
            .addScalar("column1", new LongType())
            .addScalar("column2", new IntegerType())
            .addScalar("column3", new StringType());
List<Object[]> values = query.getResultList();

这篇关于如何在java中修复“JDBC类型的无方言映射：-1”错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！