Guest User

Untitled

a guest
Feb 12th, 2019
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. @Configuration
  2. public class SpringConfig {
  3. @Bean
  4. @Singleton
  5. public DataSource getDataSource() {
  6. BasicDataSource basicDataSource = new BasicDataSource();
  7. basicDataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
  8. basicDataSource.setUrl("jdbc:mysql://localhost:3306/db?serverTimezone=UTC");
  9. basicDataSource.setUsername("name");
  10. basicDataSource.setPassword("password");
  11. basicDataSource.setInitialSize(5);
  12. basicDataSource.setMinIdle(3);
  13. basicDataSource.setMaxIdle(15);
  14. basicDataSource.setMaxWait(10000);
  15. basicDataSource.setMaxActive(100);
  16. return basicDataSource;
  17. }
  18. }
  19.  
  20. @Configuration
  21. @PropertySource("classpath:database.properties")
  22. public class SpringConfig {
  23. private @Value("${propertyName}") String propertyField;
  24.  
  25. @Bean
  26. @Singleton
  27. public DataSource getDataSource() {
  28. BasicDataSource basicDataSource = new BasicDataSource();basicDataSource.setConnectionProperties(propertyField);
  29. return basicDataSource;
  30. }
  31. }
  32.  
  33. driverClassName = "com.mysql.cj.jdbc.Driver"
  34. url="jdbc:mysql://localhost:3306/db"
  35. username="user"
  36. password="password"
Add Comment
Please, Sign In to add comment