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 |
