Guest User

Untitled

a guest
Aug 21st, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.02 KB | None | 0 0
  1. @Configuration
  2. @EnableTransactionManagement
  3. @EnableJpaRepositories(basePackages = "br.com.ribeiraoreefshop.model.repositories")
  4. public class ConfiguracaoDB {
  5.  
  6. @Bean
  7. public DataSource dataSource() throws IllegalStateException,
  8. PropertyVetoException {
  9. ComboPooledDataSource dataSource = new ComboPooledDataSource();
  10. dataSource.setDriverClass("org.postgresql.Driver");
  11. dataSource
  12. .setJdbcUrl("jdbc:postgresql://localhost:5432/ribeiraoreefshop");
  13. dataSource.setUser("postgres");
  14. dataSource.setPassword("snh");
  15. return dataSource;
  16. }
  17.  
  18. @Bean
  19. public LocalContainerEntityManagerFactoryBean entityManagerFactory()
  20. throws Exception {
  21. LocalContainerEntityManagerFactoryBean entityManagerFactoryBean = new LocalContainerEntityManagerFactoryBean();
  22. entityManagerFactoryBean.setDataSource(dataSource());
  23. entityManagerFactoryBean
  24. .setPackagesToScan("br.com.ribeiraoreefshop.model.entity");
  25. entityManagerFactoryBean
  26. .setPersistenceProviderClass(HibernatePersistenceProvider.class);
  27. entityManagerFactoryBean.setJpaDialect(new HibernateJpaDialect());
  28.  
  29. Properties jpaProterties = new Properties();
  30. jpaProterties.put("hibernate.dialect",
  31. "org.hibernate.dialect.PostgreSQL82Dialect");
  32. jpaProterties.put("hibernate.hbm2ddl.auto", "update");
  33. jpaProterties.put("hibernate.show_sql", "true");
  34. jpaProterties.put("hibernate.format_sql", "true");
  35.  
  36. jpaProterties.put("hibernate.c3p0.min_size", "5");
  37. jpaProterties.put("hibernate.c3p0.max_size", "10");
  38. jpaProterties.put("hibernate.c3p0.timeout", "1800");
  39. jpaProterties.put("hibernate.c3p0.max_statements", "50");
  40.  
  41. entityManagerFactoryBean.setJpaProperties(jpaProterties);
  42. return entityManagerFactoryBean;
  43. }
  44.  
  45. @Bean
  46. public JpaTransactionManager transactionManager() throws Exception {
  47. JpaTransactionManager transactionManager = new JpaTransactionManager();
  48. transactionManager.setEntityManagerFactory(entityManagerFactory()
  49. .getObject());
  50. return transactionManager;
  51. }
  52.  
  53. }
Add Comment
Please, Sign In to add comment