Forum:

Object Relational Mapping

Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set

Greenhorn

Posts: 9

posted 8 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am trying to make a JSP page with a text box and search button.It searches the MySQL dbs using Hibernate and displays all the entries which match the name entered. I am using Spring and Hibernate.

1)This is the JSP page

2)Here is the Search Controller

3) this is the DAO IMpl

package com.my.dao.impl;
import java.io.Serializable;  
import java.util.List;  
  import javax.transaction.Transactional;
import org.hibernate.Query;
import org.hibernate.Session;  
import org.hibernate.SessionFactory;  
import org.hibernate.Transaction;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import com.my.dao.SearchDAO;
import com.my.entity.Search;;

@Repository("SearchDAO")  
public class SearchDAOImpl implements SearchDAO
{ @Autowired  
	 SessionFactory sessionFactory;

@Override  
	 @Transactional  
	public void search()
{Session session = sessionFactory.openSession();  
 Transaction tx = session.beginTransaction();  
	  
String hql = "from Search where my.name='hello' ";
Query query = session.createQuery(hql);

List<Search> sdata = query.list();
	}
	 
	 
	 @SuppressWarnings("deprecation")
	public Search retrieveFromId(int idValue) 
	    {
		  Configuration config = new Configuration();
		  config.addAnnotatedClass(Search.class);
		  config.configure("/hibernate.cfg.xml");
	  
ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder().applySettings(config.getProperties()).build();
SessionFactory factory = config.buildSessionFactory(serviceRegistry);  
		  Session session = factory.getCurrentSession();
		  session.beginTransaction();
		  String queryString = "from User where id = :id";
		  Query query = session.createQuery(queryString);
		  query.setInteger("id", idValue);
		  Object queryResult = query.uniqueResult();
		  Search user = (Search)queryResult;
		  session.getTransaction().commit();
		  return user;
		 }
}

I get the following Exception

HTTP Status 500 - Request processing failed; nested exception is org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set

type Exception report

message Request processing failed; nested exception is org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy

What is the mistake???

K. Tsang

Bartender

Posts: 3648

I like...

posted 8 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I have added code tags for you, doesn't it look better?

How is your hibernate.cfg.xml look like? As the error message indicate, the "hibernate.dialect" value is needed which points to what database you are using.

For example MySQL the dialect is "org.hibernate.dialect.MySQLDialect"

K. Tsang CEng MBCS PMP PMI-ACP OCMJEA OCPJP

Roel De Nijs

Sheriff

Posts: 11604

178

I like...

posted 8 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

And I also updated the subject line, because you should always try to UseAMeaningfulSubjectLine (and yours was not providing very much information).

And I agree with K. Tsang on this one: it seems you didn't have set the hibernate.dialect property in the hibernate configuration file

SCJA, SCJP (1.4 | 5.0 | 6), SCJD
OCAJP 7

Thank you my well lotioned goddess! Here, have my favorite tiny ad!

a bit of art, as a gift, that will fit in a stocking

https://gardener-gift.com