Knowledge has a beginning but no end

SQL Error No Dialect mapping for JDBC type

Ashvin Gami & Deepak Kumar

2022-09-26 19:37:19

    Error :--

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

        at org.hibernate.dialect.TypeNames.get(TypeNames.java:70)

        at org.hibernate.dialect.TypeNames.get(TypeNames.java:101)

        at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:666)

    Above hibernate error can be resolved in NATIVE sql by

    1. Use this syntax

    Select 1*1 as column;

    instead of this

    Select 1 as column;

     

    2.  Use this syntax

    Select ''||'101'||'' as column2;   --- Not it's two single quote and not double quote.

    instead of this

    Select '101' as c2;

    For example

    Use this

    Select ''||'102'||'' as pending_quantity from tablexyz;

    Instead of this

    Select '102' as pending_quantity from tablexyz;

     

     

    Related Articles