Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <Resource auth="Container" driverClassName="com.mysql.jdbc.Driver"
- maxActive="20"
- global="jdbc/otp1"
- maxIdle="0"
- maxWait="10000"
- name="jdbc/otp1"
- password="root"
- username="root"
- type="javax.sql.DataSource"
- url="jdbc:mysql://localhost:3306/test"/>
- <ResourceLink name="jdbc/otp"
- global="jdbc/otp1"
- auth="Container" type="javax.sql.DataSource" />
- enter code here
- <dependencies>
- <dependency>
- <groupId>org.springframework.boot</groupId>
- <artifactId>spring-boot-starter-jdbc</artifactId>
- </dependency>
- <dependency>
- <groupId>org.springframework.boot</groupId>
- <artifactId>spring-boot-starter-web</artifactId>
- </dependency>
- <dependency>
- <groupId>mysql</groupId>
- <artifactId>mysql-connector-java</artifactId>
- <scope>runtime</scope>
- </dependency>
- <dependency>
- <groupId>org.apache.tomcat</groupId>
- <artifactId>tomcat-jdbc</artifactId>
- <version>9.0.8</version>
- </dependency>
- </dependencies>
- <build>
- <plugins>
- <plugin>
- <groupId>org.springframework.boot</groupId>
- <artifactId>spring-boot-maven-plugin</artifactId>
- </plugin>
- </plugins>
- </build>
- @Configuration
- @Bean
- public DataSource getDataSource(){
- JndiDataSourceLookup dsLookup = new JndiDataSourceLookup();
- dsLookup.setResourceRef(true);
- DataSource dataSource=dsLookup.getDataSource("jdbc/otp");
- return dataSource;
- }
Add Comment
Please, Sign In to add comment