Guest User

Untitled

a guest
Nov 10th, 2018
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.64 KB | None | 0 0
  1. <Resource auth="Container" driverClassName="com.mysql.jdbc.Driver"
  2. maxActive="20"
  3. global="jdbc/otp1"
  4. maxIdle="0"
  5. maxWait="10000"
  6. name="jdbc/otp1"
  7. password="root"
  8. username="root"
  9. type="javax.sql.DataSource"
  10. url="jdbc:mysql://localhost:3306/test"/>
  11.  
  12. <ResourceLink name="jdbc/otp"
  13. global="jdbc/otp1"
  14. auth="Container" type="javax.sql.DataSource" />
  15. enter code here
  16.  
  17. <dependencies>
  18. <dependency>
  19. <groupId>org.springframework.boot</groupId>
  20. <artifactId>spring-boot-starter-jdbc</artifactId>
  21. </dependency>
  22. <dependency>
  23. <groupId>org.springframework.boot</groupId>
  24. <artifactId>spring-boot-starter-web</artifactId>
  25. </dependency>
  26. <dependency>
  27. <groupId>mysql</groupId>
  28. <artifactId>mysql-connector-java</artifactId>
  29. <scope>runtime</scope>
  30. </dependency>
  31.  
  32. <dependency>
  33. <groupId>org.apache.tomcat</groupId>
  34. <artifactId>tomcat-jdbc</artifactId>
  35. <version>9.0.8</version>
  36. </dependency>
  37. </dependencies>
  38. <build>
  39. <plugins>
  40. <plugin>
  41. <groupId>org.springframework.boot</groupId>
  42. <artifactId>spring-boot-maven-plugin</artifactId>
  43. </plugin>
  44. </plugins>
  45. </build>
  46.  
  47. @Configuration
  48.  
  49. @Bean
  50. public DataSource getDataSource(){
  51. JndiDataSourceLookup dsLookup = new JndiDataSourceLookup();
  52. dsLookup.setResourceRef(true);
  53. DataSource dataSource=dsLookup.getDataSource("jdbc/otp");
  54. return dataSource;
  55.  
  56. }
Add Comment
Please, Sign In to add comment