[jboss-user] [EJB 3.0] - No Dialect mapping for JDBC type

[akrishmohan]

When I run this code, 
..... 
int id = 20; //Id is the primary key in the db table
Query query = em.createNativeQuery("select p.* from Person where p.id = " + id);
log.debug(query.getResultList());
.......

I get the following exception: 

Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.MappingException: No Dialect mapping for JDBC type: -1

Caused by: org.hibernate.MappingException: No Dialect mapping for JDBC type: -1
	at org.hibernate.dialect.TypeNames.get(TypeNames.java:56)
	at org.hibernate.dialect.TypeNames.get(TypeNames.java:81)
	at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:217)
	at org.hibernate.loader.custom.CustomLoader.getHibernateType(CustomLoader.java:176)
	at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:146)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1678)
	at org.hibernate.loader.Loader.doQuery(Loader.java:662)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
	at org.hibernate.loader.Loader.doList(Loader.java:2145)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
	at org.hibernate.loader.Loader.list(Loader.java:2024)
	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:118)
	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1684)
	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)
	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:53)
	... 5 more


Any help will be appreciated.

Thanks
K




View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3989892#3989892

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3989892