--------------------------------------------------------------------------------------------
package donsexample.spring.config;

import java.util.Properties;

import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.config.PropertyPlaceholderConfigurer;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.env.Environment;
import org.springframework.core.io.ClassPathResource;
import org.springframework.orm.hibernate3.HibernateTransactionManager;
import org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean;
import org.springframework.scheduling.annotation.EnableScheduling;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import org.springframework.web.servlet.config.annotation.EnableWebMvc;

import org.apache.commons.dbcp.BasicDataSource;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;

@Configuration
@ComponentScan("donsexample") 
@EnableScheduling
@EnableTransactionManagement
@EnableWebMvc

public class SpringContextConfigurator
{
   @Autowired
   protected Environment env;   

   // The following is used to establish the database connection..
   // These beans are unique within an @Configuration class.
   @Bean
   public DataSource dataSource() throws Exception {
                
        final BasicDataSource ds = new BasicDataSource();  // Another Spring Class.
        
        ds.setDriverClassName("com.mysql.jdbc.Driver ");
        ds.setUrl("jdbc:mysql//localhost:3306/donsdb" );
        ds.setUsername("root");
        ds.setPassword("*********");
        ds.setValidationQuery("Select 1 from DUAL");
        ds.setRemoveAbandoned(true);
        ds.setTestOnBorrow(true);
        ds.setTestWhileIdle(true);
   return ds;
   }
   
   // These beans are unique within an @Configuration class. --> Added @Autowired
   @Bean
   @Autowired
   public HibernateTransactionManager transactionManager() throws Exception
   {

      HibernateTransactionManager transactionManager = new HibernateTransactionManager(); // HIbernate class..
   
      // Get our session factory from the method below.
   //   SessionFactory theFactory = getSessionFactory();
      SessionFactory theFactory = (SessionFactory)getSessionFactory();
      transactionManager.setSessionFactory(theFactory);      
   return transactionManager;
   }
      
   // These beans are unique within an @Configuration class.
   @Bean
   public SessionFactory getSessionFactory() throws Exception {
         
      // Loop here so we can attached via Eclipse to debug initialization..
       try
       {
         boolean stillLooping = true;
         while(stillLooping)
         {
            Thread.currentThread().sleep(5000);
         }
       }
       catch(InterruptedException ie)
       {
         
       }
      
      Properties properties = new Properties();
      properties.put("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");
      properties.put("hibernate.show_sql", "true");      
      
      //-------------- added the following Properties ------
      
      properties.put("format_sql", "true");
      properties.put("hbm2ddl.auto", "create");
      //----------------------------------------------------
      
      AnnotationSessionFactoryBean factory = new AnnotationSessionFactoryBean();
      factory.setPackagesToScan(new String [] {"donsexample.model"});
      
      // Get the data Source defined in the method above
      
      Class mysqlDriverClass = Class.forName("com.mysql.jdbc.Driver");
      DataSource ourDataSource = dataSource();

      factory.setDataSource(ourDataSource);
      factory.setHibernateProperties(properties);

      // <<<< This is where we get the error about trying to load  >>>>
      // the com.mysql.jdbc.Driver even though we can load it
      // up above with Class.forName(...)
      
      // Note: the afterPropertiesSet method is inherited from
      // AbstractSessionFactoryBean
      factory.afterPropertiesSet();//  <<- Error happens here!

      return factory.getObject();
   }

}