SQLQuery == select name from sys.databases SQLQuery sqlq = sessionFactory.getCurrentSession().createSQLQuery("select name from sys.databases"); sqlq.list(); This Issue in SQL Server but Mysql Query is executing with out any issue ( show databases) Exception in thread "main" org.hibernate.MappingException: No Dialect mapping for JDBC type: -9 at org.hibernate.dialect.TypeNames.get(TypeNames.java:76) at org.hibernate.dialect.TypeNames.get(TypeNames.java:99) at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:592) at org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(CustomLoader.java:720) at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.performDiscovery(CustomLoader.java:602) at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:618) at org.hibernate.loader.Loader.getResultSet(Loader.java:2070) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:906) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348) at org.hibernate.loader.Loader.doList(Loader.java:2550) at org.hibernate.loader.Loader.doList(Loader.java:2536) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366) at org.hibernate.loader.Loader.list(Loader.java:2361) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:340) at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1788) at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:232) at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:157) at com.data.Main.index(Main.java:58) at com.data.Main.main(Main.java:24)
| 0 |