Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. <Resource name="jdbc/MyLocalDB"
  2. global="jdbc/MyLocalDB"
  3. auth="Container"
  4. type="javax.sql.DataSource"
  5. driverClassName="com.mysql.jdbc.Driver"
  6. url="jdbc:mysql://localhost:3306/demoData"
  7. username="root"
  8. password="root"
  9. maxActive="100"
  10. maxIdle="20"
  11. minIdle="5"
  12. maxWait="10000"/>
  13.  
  14. <ResourceLink name="jdbc/MyLocalDB"
  15. global="jdbc/MyLocalDB"
  16. auth="Container"
  17. type="javax.sql.DataSource" />
  18.  
  19. package com.tomcat.pool;
  20. import javax.naming.Context;
  21. import javax.naming.InitialContext;
  22. import javax.naming.NamingException;
  23. import javax.sql.DataSource;
  24. import org.springframework.boot.SpringApplication;
  25. import org.springframework.boot.autoconfigure.SpringBootApplication;
  26. import org.springframework.context.annotation.Bean;
  27. import org.springframework.jdbc.core.JdbcTemplate;
  28.  
  29. @SpringBootApplication
  30. public class SpringJDBCConnectionPoolApp {
  31.  
  32. public static void main(String[] args) {
  33. SpringApplication.run(SpringJDBCConnectionPoolApp.class, args);
  34. }
  35.  
  36.  
  37. @Bean
  38. public DataSource dataSource(){
  39. Context ctx = null;
  40. DataSource ds = null;
  41. try {
  42. ctx = new InitialContext();
  43. ds = (DataSource) ctx.lookup("java:/comp/env/jdbc/MyLocalDB");
  44. } catch (NamingException e) {
  45. System.out.println("dataSource not found!!!");
  46. }
  47. return ds;
  48. }
  49.  
  50. @Bean
  51. public JdbcTemplate jdbcTemplate(DataSource dataSource){
  52. return new JdbcTemplate(dataSource);
  53. }
  54. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement