无JDBC类型的Dialect映射 [英] No Dialect mapping for JDBC type

问题描述

  org.hibernate.MappingException：否JDBC方式的Dialect映射：-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:369）
  

我也参考这个问题
如何修正了没有方言映射的JDBC类型：-1java中的错误

但是我没有得到想要的解决方案。

我的查询是：

 查询langQuery = null; 
 List< Object []> langList = null; 
 StringBuilder strQuery = new StringBuilder（）; 
 strQuery.append（SELECT lw.langWordId，lw.wordText，lt.translatedContent from language_word lw inner join language_translation lt on）; 
 strQuery.append（lw.langWordId = lt.langWordId where lw.isActive =+ Boolean.TRUE +）; 
 
 langQuery = session.createSQLQuery（strQuery.toString（））; 
 
 langList = langQuery.list（）; 
  

langList = langQuery.list（）;

我的pom.xml文件有依赖关系：

 <依赖性> 
< groupId> org.hibernate< / groupId> 
< artifactId> hibernate-core< / artifactId> 
< version> 3.6.0.Final< / version> 
< /依赖关系> 
 
< dependency> 
< groupId> org.hibernate< / groupId> 
< artifactId> hibernate< / artifactId> 
< version> 3.2.6.ga< / version> 
< /依赖关系> 
< dependency> 
< groupId> org.hibernate< / groupId> 
< artifactId> hibernate< / artifactId> 
< version> 3.2.3.ga< / version> 
< /依赖关系> 
 
< dependency> 
< groupId> org.hibernate< / groupId> 
< artifactId> ejb3-persistence< / artifactId> 
< version> 1.0.2.GA< / version> 
< type> pom< / type> 
< /依赖关系> 
< dependency> 
< groupId> org.hibernate< / groupId> 
< artifactId> hibernate-annotations< / artifactId> 
< version> 3.3.1.GA< / version> 
< /依赖关系> 
 
< dependency> 
< groupId> org.hibernate< / groupId> 
< artifactId> hibernate-commons-annotations< / artifactId> 
< version> 3.3.0.ga< / version> 
< /依赖关系> 
 
< dependency> 
< groupId> org.hibernate< / groupId> 
< artifactId> hibernate-validator< / artifactId> 
< version> 3.1.0.GA< / version> 
< /依赖关系> 
  

我的任务是什么？

我使用 addscalar ，同时检索我的列表，但仍然得到了那个错误。

任何帮助都会感激。

I would like to know how to resolve this error:

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:369)

Also I refer this Question How to fix "No Dialect mapping for JDBC type: -1" error in java

But I did not get a desired solution.

My query is:

     Query langQuery = null; 
     List<Object[]> langList = null;
        StringBuilder strQuery = new StringBuilder();
        strQuery.append("SELECT lw.langWordId,lw.wordText,lt.translatedContent from language_word lw inner join language_translation lt on ");
        strQuery.append(" lw.langWordId=lt.langWordId where lw.isActive="+Boolean.TRUE+" ");

        langQuery = session.createSQLQuery(strQuery.toString());

        langList = langQuery.list();

langList = langQuery.list(); at this line i am getting this error.

My pom.xml file have dependencies:

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-core</artifactId>
    <version>3.6.0.Final</version>
</dependency>

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate</artifactId>
    <version>3.2.6.ga</version>
</dependency>
<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate</artifactId>
    <version>3.2.3.ga</version>
</dependency>

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>ejb3-persistence</artifactId>
    <version>1.0.2.GA</version>
    <type>pom</type>
</dependency>
<dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-annotations</artifactId>
        <version>3.3.1.GA</version>
    </dependency>

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-commons-annotations</artifactId>
    <version>3.3.0.ga</version>
</dependency>

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-validator</artifactId>
    <version>3.1.0.GA</version>
</dependency>

Am I mission something?

I used addscalar while retrieving my list but still I got that error.

Any help will appreciated.

解决方案

//kindly check your Query, this error occurs when you have the syntax error in your Query

这篇关于无JDBC类型的Dialect映射的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！