Advertisement
Guest User

Untitled

a guest
Jun 29th, 2016
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. <Resource name="jdbc/my_ds"
  2. auth="Container"
  3. type="javax.sql.DataSource"
  4. driverClassName="org.mariadb.jdbc.Driver"
  5. url="jdbc:mariadb:failover://localhost:3306/mine"
  6. username="mine"
  7. password="me"
  8. initalSize="1"
  9. minIdle="1"
  10. maxIdle="30"
  11. maxActive="100"
  12. maxWait="10000"
  13. jmxEnabled="true"
  14. validationQuery="SELECT 1"
  15. testOnBorrow="true"
  16. minEvictableIdleTimeMillis="60000"
  17. timeBetweenEvictionRunsMillis="5000"
  18. />
  19.  
  20. @Configuration
  21. @ComponentScan
  22. @EnableJpaRepositories
  23. @EnableTransactionManagement
  24. public class AppConfiguration {
  25.  
  26. @Bean
  27. public DataSource dataSource() {
  28. JndiDataSourceLookup lookup = new JndiDataSourceLookup();
  29. return lookup.getDataSource("/jdbc/my_ds");
  30. }
  31.  
  32. @Bean
  33. public EntityManagerFactory entityManagerFactory() {
  34. HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
  35. vendorAdapter.setGenerateDdl(true);
  36. vendorAdapter.setShowSql(true);
  37.  
  38. LocalContainerEntityManagerFactoryBean factory = new LocalContainerEntityManagerFactoryBean();
  39. factory.setJpaVendorAdapter(vendorAdapter);
  40. factory.setPackagesToScan("com.example.persistence");
  41. factory.setDataSource(dataSource());
  42. factory.afterPropertiesSet();
  43.  
  44. return factory.getObject();
  45. }
  46.  
  47. @Bean
  48. public PlatformTransactionManager transactionManager() {
  49. JpaTransactionManager txManager = new JpaTransactionManager();
  50. txManager.setEntityManagerFactory(entityManagerFactory());
  51. return txManager;
  52. }
  53. }
  54.  
  55. @Bean
  56. public DataSource dataSource() {
  57. return new DriverManagerDataSource("jdbc:mariadb://localhost:3306/mine", "mine", "my");
  58. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement