Advertisement
Guest User

Untitled

a guest
Apr 18th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.20 KB | None | 0 0
  1. public DataSource createHikariDatasource(String url, String username, String password, String driver) {
  2.  
  3.  
  4. HikariConfig hikariConfig = new HikariConfig();
  5. hikariConfig.setDataSourceClassName(driver);
  6. hikariConfig.setUsername(username);
  7. hikariConfig.setJdbcUrl(url);
  8. hikariConfig.setPassword(password);
  9. hikariConfig.setConnectionTestQuery("show tables");
  10. DataSource ds = new HikariDataSource(hikariConfig);
  11.  
  12. return ds;
  13.  
  14.  
  15. }
  16.  
  17. @Test
  18. public void createHikariCPDatasource() throws Exception {
  19. GreetingConfig greetingConfig = new GreetingConfig();
  20.  
  21. String driver = "org.hsqldb.jdbc.JDBCDataSource";
  22. String url="jdbc:hsqldb:mem:testdb";
  23. String user = "SA";
  24. String password = "";
  25.  
  26.  
  27. logger.debug("get message data source");
  28. DataSource dataSource = greetingConfig.createHikariDatasource(url, user, password,driver);
  29.  
  30. JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
  31. jdbcTemplate.execute(env.getProperty("init"));
  32. jdbcTemplate.execute(env.getProperty("insert"));
  33.  
  34. }
  35.  
  36. com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: null
  37. at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:524)
  38. at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:118)
  39. at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:71)
  40. at org.cam.go.microservice.GreetingConfig.createHikariDatasource(GreetingConfig.java:233)
  41. at org.cam.go.microservice.GreetingConfigTest.createHikariCPDatasource(GreetingConfigTest.java:78)
  42. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  43. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  44. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  45. at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
  46. at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
  47. at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
  48. at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement