org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111

Hibernate JIRA | Gauri Shankar Choudhary | 2 months ago
  1. 0

    I'm working with Postgres while try to execute native SQL getting exception {code} private List<Map<String, Object>> executeQuery(final String pQuery) throws Exception { Session session =xxxxxDao.getSessionFactory().openSession(); List<Map<String, Object>> resultMapList = new ArrayList<Map<String, Object>>(); try { Query sqlQuery = session.createSQLQuery(pQuery); sqlQuery.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE); resultMapList = sqlQuery.list(); return resultMapList; } catch(Exception e) { e.printStackTrace(); } finally { session.close(); } } {code} Stacktrace: {noformat} org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111 at org.hibernate.dialect.TypeNames.get(TypeNames.java:77) at org.hibernate.dialect.TypeNames.get(TypeNames.java:100) at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:378) at org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(CustomLoader.java:590) at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.performDiscovery(CustomLoader.java:516) at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:532) at org.hibernate.loader.Loader.getResultSet(Loader.java:1962) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2542) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) {noformat}

    Hibernate JIRA | 2 months ago | Gauri Shankar Choudhary
    org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111
  2. 0

    how to skip an index in a tuple result from a sql query

    Stack Overflow | 6 years ago | pstanton
    org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111
  3. 0

    hibernate-spatial: sql query to retrieve a geometry

    Stack Overflow | 4 years ago | pstanton
    org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [RESOLVIDO] Problemas ao tentar executar uma procedure via NativeQuery() - Assuntos Gerais - GUJ

    com.br | 9 months ago
    javax.faces.FacesException: #{notaFiscalMBean.inserirBemNotaFiscal}: javax.persistence.PersistenceException: org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111
  6. 0

    JPA SQL Server No Dialect mapping for JDBC type: -9

    Stack Overflow | 2 years ago | user1903224
    org.springframework.orm.jpa.JpaSystemException: org.hibernate.MappingException: No Dialect mapping for JDBC type: -9; nested exception is javax.persistence.PersistenceException: org.hibernate.MappingException: No Dialect mapping for JDBC type: -9

    17 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.hibernate.MappingException

      No Dialect mapping for JDBC type: 1111

      at org.hibernate.dialect.TypeNames.get()
    2. Hibernate
      CustomLoader.list
      1. org.hibernate.dialect.TypeNames.get(TypeNames.java:77)
      2. org.hibernate.dialect.TypeNames.get(TypeNames.java:100)
      3. org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:378)
      4. org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(CustomLoader.java:590)
      5. org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.performDiscovery(CustomLoader.java:516)
      6. org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:532)
      7. org.hibernate.loader.Loader.getResultSet(Loader.java:1962)
      8. org.hibernate.loader.Loader.doQuery(Loader.java:802)
      9. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
      10. org.hibernate.loader.Loader.doList(Loader.java:2542)
      11. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
      12. org.hibernate.loader.Loader.list(Loader.java:2271)
      13. org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
      13 frames
    3. Hibernate
      SQLQueryImpl.list
      1. org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
      2. org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
      3. org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
      3 frames