Hibernate : No Dialect mapping for JDBC type: 101

19,182

Solution 1

Try it like this:

Object result = session.createSQLQuery(
        "SELECT " +
        "   rownum as id, " +
        "   mm.metric_name, " +
        "   dm.aggregated_value_float, " +
        "   dm.created_timestamp as dm_timestamp, " +
        "   s.type, " +
        "   s.name as subelement_name " +
        "FROM " +
        "   daily_metric dm, " +
        "   subelement s, " +
        "   metric_metadata mm " +
        "WHERE " +
        "   dm.subelement_id =s.subelement_id AND " +
        "   TRUNC(dm.created_timestamp)='15-JAN-15' AND " +
        "   s.subelement_id =1456376 AND " +
        "   dm.metric_metadata_id = mm.metric_metadata_id " +
        "ORDER BY 1,2 DESC")
.addScalar("dm_timestamp", TimestampType.INSTANCE)
.uniqueResult();

Solution 2

I had a similar issue when selecting a single result via "getSingleResult()" from a table:

 BigDecimal result = (BigDecimal)query.getSingleResult();

It turned out that I had to explicitly cast the returned number within the select statement into a number:

 SELECT CAST(SUM(aggregated) as NUMBER) FROM ....
Share:
19,182

Related videos on Youtube

Priya
Author by

Priya

I am Software Engineer, since 2012. Working as Java Developer.

Updated on September 28, 2022

Comments

  • Priya
    Priya 2 months

    I am facing issue while selecting records from datatabase,

    Query :

     SELECT rownum as id, mm.metric_name, dm.aggregated_value_float,
     dm.created_timestamp, s.type, s.name as subelement_name FROM
     daily_metric dm, subelement s, metric_metadata mm  WHERE
     dm.subelement_id =s.subelement_id AND 
     TRUNC(dm.created_timestamp)='15-JAN-15' AND s.subelement_id =1456376 
     and dm.metric_metadata_id = mm.metric_metadata_id order by 1,2 desc
    

    Code :

    Query query = session.createSQLQuery(query);
    Object o =  query.uniqueResult();
    

    Stack Trace

    org.hibernate.MappingException: No Dialect mapping for JDBC type: 101
        at org.hibernate.dialect.TypeNames.get(TypeNames.java:87)
        at org.hibernate.dialect.TypeNames.get(TypeNames.java:118)
        at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:653)
        at org.hibernate.loader.custom.JdbcResultMetadata.getHibernateType(JdbcResultMetadata.java:93)
        at org.hibernate.loader.custom.ScalarResultColumnProcessor.performDiscovery(ScalarResultColumnProcessor.java:62)
        at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:496)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:2073)
        at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)
        at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
        at org.hibernate.loader.Loader.doQuery(Loader.java:909)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
        at org.hibernate.loader.Loader.doList(Loader.java:2551)
        at org.hibernate.loader.Loader.doList(Loader.java:2537)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2367)
        at org.hibernate.loader.Loader.list(Loader.java:2362)
        at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:351)
        at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1869)
        at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:311)
        at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:141)
        at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966)
    

    I have tried link but it showign Hibernate.Timestampcan not be resoved by compiler.

    hibernate.cfg.xml

     <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
      <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>