Advertisement
Guest User

Untitled

a guest
Mar 9th, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.74 KB | None | 0 0
  1. @Configuration
  2. @EnableTransactionManagement
  3. @EnableJpaRepositories(entityManagerFactoryRef = "remotedbEntityManagerFactory", basePackages = {"com.stravovani.DB.RemoteDB.Repository"})
  4. public class RemoteDBConfig {
  5.  
  6. @Value("${datasource.stravovani.maxPoolSize:10}")
  7. private int maxPoolSize;
  8.  
  9. @Primary
  10. @Bean(name = "remotedbDataSource")
  11. @ConfigurationProperties(prefix = "remotedb.datasource")
  12. public DataSourceProperties dataSourceProperties(){
  13. return new DataSourceProperties();
  14. }
  15.  
  16. @Primary
  17. @Bean
  18. public DataSource dataSource() {
  19. DataSourceProperties dataSourceProperties = dataSourceProperties();
  20. HikariDataSource dataSource = (HikariDataSource)
  21. DataSourceBuilder
  22. .create(dataSourceProperties.getClassLoader())
  23. .driverClassName(dataSourceProperties.getDriverClassName())
  24. .url(dataSourceProperties.getUrl())
  25. .username(dataSourceProperties.getUsername())
  26. .password(dataSourceProperties.getPassword())
  27. .type(HikariDataSource.class)
  28. .build();
  29. dataSource.setMaximumPoolSize(maxPoolSize);
  30. return dataSource;
  31. }
  32.  
  33.  
  34. @Primary
  35. @Bean(name = "remotedbEntityManagerFactory")
  36. public LocalContainerEntityManagerFactoryBean entityManagerFactory()
  37. throws NamingException {
  38. LocalContainerEntityManagerFactoryBean factoryBean = new
  39. LocalContainerEntityManagerFactoryBean();
  40. factoryBean.setDataSource(dataSource());
  41. factoryBean.setPackagesToScan("com.stravovani.DB.RemoteDB.Model");
  42. factoryBean.setJpaVendorAdapter(jpaVendorAdapter());
  43. return factoryBean;
  44. }
  45.  
  46. @Primary
  47. @Bean
  48. public JpaVendorAdapter jpaVendorAdapter() {
  49. HibernateJpaVendorAdapter hibernateJpaVendorAdapter = new
  50. HibernateJpaVendorAdapter();
  51. return hibernateJpaVendorAdapter;
  52. }
  53.  
  54. @Primary
  55. @Bean
  56. @Autowired
  57. public PlatformTransactionManager
  58. transactionManager(@Qualifier("remotedbEntityManagerFactory") EntityManagerFactory emf) {
  59. JpaTransactionManager txManager = new JpaTransactionManager();
  60. txManager.setEntityManagerFactory(emf);
  61. return txManager;
  62. }
  63. }
  64.  
  65. @Configuration
  66. @EnableTransactionManagement
  67. @EnableJpaRepositories(entityManagerFactoryRef = "localdbEntityManagerFactory", transactionManagerRef = "localdbTransactionManager", basePackages = {"com.stravovani.DB.LocalDB.Repository"})
  68. public class LocalDBConfig {
  69.  
  70. @Value("${datasource.stravovani.maxPoolSize:10}")
  71. private int maxPoolSize;
  72.  
  73. @Bean(name = "localdbDataSource")
  74. @ConfigurationProperties(prefix = "localdb.datasource")
  75. public DataSourceProperties dataSourceProperties(){
  76. return new DataSourceProperties();
  77. }
  78.  
  79. @Bean
  80. public DataSource dataSource() {
  81. DataSourceProperties dataSourceProperties = dataSourceProperties();
  82. HikariDataSource dataSource = (HikariDataSource)
  83. DataSourceBuilder
  84. .create(dataSourceProperties.getClassLoader())
  85. .driverClassName(dataSourceProperties.getDriverClassName())
  86. .url(dataSourceProperties.getUrl())
  87. .username(dataSourceProperties.getUsername())
  88. .password(dataSourceProperties.getPassword())
  89. .type(HikariDataSource.class)
  90. .build();
  91. dataSource.setMaximumPoolSize(maxPoolSize);
  92. return dataSource;
  93. }
  94.  
  95. @Bean(name = "localdbEntityManagerFactory")
  96. public LocalContainerEntityManagerFactoryBean entityManagerFactory()
  97. throws NamingException {
  98. LocalContainerEntityManagerFactoryBean factoryBean = new
  99. LocalContainerEntityManagerFactoryBean();
  100. factoryBean.setDataSource(dataSource());
  101. factoryBean.setPackagesToScan("com.stravovani.DB.LocalDB.Model");
  102. factoryBean.setJpaVendorAdapter(jpaVendorAdapter());
  103. return factoryBean;
  104. }
  105.  
  106. @Bean
  107. public JpaVendorAdapter jpaVendorAdapter() {
  108. HibernateJpaVendorAdapter hibernateJpaVendorAdapter = new
  109. HibernateJpaVendorAdapter();
  110. return hibernateJpaVendorAdapter;
  111. }
  112.  
  113. @Bean
  114. @Autowired
  115. public PlatformTransactionManager
  116. transactionManager(@Qualifier("localdbEntityManagerFactory") EntityManagerFactory emf) {
  117. JpaTransactionManager txManager = new JpaTransactionManager();
  118. txManager.setEntityManagerFactory(emf);
  119. return txManager;
  120. }
  121. }
  122.  
  123. spring.data.rest.basePath=/api
  124. spring.cache.type=NONE
  125. spring.jpa.hibernate.ddl-auto=update
  126. spring.jpa.show-sql=true
  127. spring.h2.console.enabled=true
  128. spring.h2.console.path=/localDB
  129.  
  130. # Oracle - CIT DB
  131. remotedb.datasource.url= ************************
  132. remotedb.datasource.username=*********
  133. remotedb.datasource.password=****************
  134. remotedb.datasource.driver-class-name=oracle.jdbc.OracleDriver
  135.  
  136. # H2 - Local DB
  137. localdb.datasource.url=jdbc:h2:file:./localDB
  138. localdb.datasource.username=************
  139. localdb.datasource.password=*********************
  140. localdb.datasource.driverClassName=org.h2.Driver
  141.  
  142. 2018-03-09 21:57:16.707 ERROR 10812 --- [nio-8080-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root cause
  143.  
  144. java.lang.NullPointerException: null
  145. at com.stravovani.MVC.Controller.CardController.test(CardController.java:19) ~[classes/:na]
  146. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
  147. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
  148. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
  149. at java.base/java.lang.reflect.Method.invoke(Method.java:564) ~[na:na]
  150. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  151. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  152. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  153. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:870) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  154. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:776) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  155. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  156. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  157. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  158. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  159. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:870) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  160. at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  161. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:855) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  162. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  163. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  164. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  165. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) ~[tomcat-embed-websocket-8.5.28.jar:8.5.28]
  166. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  167. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  168. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  169. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  170. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  171. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  172. at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  173. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  174. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  175. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  176. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  177. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  178. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  179. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  180. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  181. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
  182. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  183. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  184. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
  185. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-8.5.28.jar:8.5.28]
  186. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496) [tomcat-embed-core-8.5.28.jar:8.5.28]
  187. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [tomcat-embed-core-8.5.28.jar:8.5.28]
  188. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat-embed-core-8.5.28.jar:8.5.28]
  189. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat-embed-core-8.5.28.jar:8.5.28]
  190. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [tomcat-embed-core-8.5.28.jar:8.5.28]
  191. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-embed-core-8.5.28.jar:8.5.28]
  192. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.28.jar:8.5.28]
  193. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) [tomcat-embed-core-8.5.28.jar:8.5.28]
  194. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-embed-core-8.5.28.jar:8.5.28]
  195. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.28.jar:8.5.28]
  196. at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) [na:na]
  197. at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) [na:na]
  198. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.28.jar:8.5.28]
  199. at java.base/java.lang.Thread.run(Thread.java:844) [na:na]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement