SQL Error No Dialect mapping for JDBC type
Below hibernate error can be resolved in NATIVE sql by using 1*1 as c1 instead of 1 as c1 or ''||'' as c2 instead of '' as c2
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)