How to use

setConfigLocation

method

in

org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean

 @Bean
public BasicDataSource dataSource(){
    BasicDataSource basicDataSource=new BasicDataSource();
    basicDataSource.addConnectionProperty("destroy-method","close");
    basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");
    basicDataSource.setUsername("root");
    basicDataSource.setUrl("jdbc:mysql://localhost/dbname");
    basicDataSource.setPassword("");
    return basicDataSource;
}

@Bean
public AnnotationSessionFactoryBean sessionFactoryBean(){
    AnnotationSessionFactoryBean asfb=new AnnotationSessionFactoryBean();
    asfb.setDataSource(dataSource());
    asfb.setConfigLocation(new ClassPathResource("hibernate.cfg.xml"));
    asfb.setHibernateProperties(hibernateProperties());

    return asfb;
}
public SessionFactory sessionFactory(){
   return sessionFactoryBean().getObject();
}
private Properties hibernateProperties(){
    Properties properties=new Properties();
    properties.put("dialect","org.hibernate.dialect.MySQLDialect");

    return properties;
 }