Guest User

Untitled

a guest
Dec 19th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.53 KB | None | 0 0
  1. @Configuration
  2. @EnableAutoConfiguration(exclude={DataSourceAutoConfiguration.class})
  3. public class DBConfig {
  4.  
  5. Logger logger = LoggerFactory.getLogger(DBConfig.class);
  6. @Bean
  7. JdbcTemplate jdbcTemplate() throws IllegalAccessException, InvocationTargetException, InstantiationException {
  8. logger.info("-----Configuring JDBCTemplate------");
  9. SnowflakeBasicDataSource dataSource = new SnowflakeBasicDataSource();
  10. dataSource.setServerName("<myserver>.snowflakecomputing.com");
  11. dataSource.setUser("<my_username>");
  12. dataSource.setPassword("<my_password>");
  13. dataSource.setWarehouse("DEMO_WH");
  14. dataSource.setDatabaseName("DEMO_DB");
  15. dataSource.setSchema("PUBLIC");
  16. return new JdbcTemplate(dataSource);
  17. }
  18. }
  19.  
  20. <?xml version="1.0" encoding="UTF-8"?>
  21. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  22. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  23. <modelVersion>4.0.0</modelVersion>
  24. <parent>
  25. <groupId>org.springframework.boot</groupId>
  26. <artifactId>spring-boot-starter-parent</artifactId>
  27. <version>2.1.1.RELEASE</version>
  28. <relativePath/> <!-- lookup parent from repository -->
  29. </parent>
  30. <groupId>com.vaibhav</groupId>
  31. <artifactId>snowflake-1</artifactId>
  32. <version>0.0.1-SNAPSHOT</version>
  33. <name>snowflake-1</name>
  34. <description>Demo project for Spring Boot</description>
  35.  
  36. <properties>
  37. <java.version>1.8</java.version>
  38. </properties>
  39.  
  40. <dependencies>
  41. <dependency>
  42. <groupId>net.snowflake</groupId>
  43. <artifactId>snowflake-jdbc</artifactId>
  44. <version>3.6.21</version>
  45. </dependency>
  46. <dependency>
  47. <groupId>org.springframework.boot</groupId>
  48. <artifactId>spring-boot-starter-jdbc</artifactId>
  49. </dependency>
  50. <dependency>
  51. <groupId>org.springframework.boot</groupId>
  52. <artifactId>spring-boot-starter-web-services</artifactId>
  53. </dependency>
  54.  
  55. <dependency>
  56. <groupId>org.springframework.boot</groupId>
  57. <artifactId>spring-boot-starter-test</artifactId>
  58. <scope>test</scope>
  59. </dependency>
  60. </dependencies>
  61.  
  62. <build>
  63. <plugins>
  64. <plugin>
  65. <groupId>org.springframework.boot</groupId>
  66. <artifactId>spring-boot-maven-plugin</artifactId>
  67. </plugin>
  68. </plugins>
  69. </build>
  70.  
  71. </project>
Add Comment
Please, Sign In to add comment