API tools faq
paste
Guest User

Untitled

a guest
Jan 4th, 2018
206
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.98 KB | None | 0 0
raw download clone embed print report
  1. HTTP Status 500 – Internal Server Error
  2.  
  3. Type Exception Report
  4.  
  5. Message Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
  6.  
  7. Description The server encountered an unexpected condition that prevented it from fulfilling the request.
  8.  
  9. Exception
  10.  
  11. org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
  12. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
  13. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
  14. javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
  15. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  16. javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  17. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  18.  
  19. Root Cause
  20.  
  21. org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
  22. org.springframework.orm.hibernate5.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:542)
  23. org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
  24. org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:461)
  25. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:277)
  26. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  27. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  28. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
  29. com.sun.proxy.$Proxy31.checkLogin(Unknown Source)
  30. com.shiso.controllers.HomeController.index(HomeController.java:30)
  31. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  32. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  33. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  34. java.lang.reflect.Method.invoke(Unknown Source)
  35. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  36. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  37. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  38. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  39. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  40. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  41. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  42. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  43. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  44. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
  45. javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
  46. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  47. javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  48. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  49.  
  50. Root Cause
  51.  
  52. org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
  53. org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
  54. org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
  55. org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
  56. org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:109)
  57. org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
  58. org.hibernate.internal.SessionImpl.connection(SessionImpl.java:523)
  59. org.springframework.orm.hibernate5.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:448)
  60. org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
  61. org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:461)
  62. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:277)
  63. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  64. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  65. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
  66. com.sun.proxy.$Proxy31.checkLogin(Unknown Source)
  67. com.shiso.controllers.HomeController.index(HomeController.java:30)
  68. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  69. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  70. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  71. java.lang.reflect.Method.invoke(Unknown Source)
  72. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  73. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  74. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  75. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  76. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  77. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  78. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  79. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  80. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  81. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
  82. javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
  83. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  84. javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  85. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  86.  
  87. Root Cause
  88.  
  89. java.sql.SQLException: The server time zone value '�rodkowoeuropejski czas stand' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
  90. com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:545)
  91. com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
  92. com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:505)
  93. com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:479)
  94. com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:489)
  95. com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:69)
  96. com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1606)
  97. com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:633)
  98. com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347)
  99. com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:219)
  100. java.sql.DriverManager.getConnection(Unknown Source)
  101. java.sql.DriverManager.getConnection(Unknown Source)
  102. org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:153)
  103. org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:144)
  104. org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:196)
  105. org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:159)
  106. org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
  107. org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
  108. org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106)
  109. org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
  110. org.hibernate.internal.SessionImpl.connection(SessionImpl.java:523)
  111. org.springframework.orm.hibernate5.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:448)
  112. org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
  113. org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:461)
  114. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:277)
  115. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  116. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  117. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
  118. com.sun.proxy.$Proxy31.checkLogin(Unknown Source)
  119. com.shiso.controllers.HomeController.index(HomeController.java:30)
  120. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  121. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  122. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  123. java.lang.reflect.Method.invoke(Unknown Source)
  124. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  125. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  126. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  127. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  128. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  129. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  130. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  131. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  132. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  133. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
  134. javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
  135. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  136. javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  137. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  138.  
  139. Root Cause
  140.  
  141. com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone value '�rodkowoeuropejski czas stand' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
  142. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  143. sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
  144. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  145. java.lang.reflect.Constructor.newInstance(Unknown Source)
  146. com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)
  147. com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
  148. com.mysql.cj.jdbc.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:118)
  149. com.mysql.cj.mysqla.MysqlaSession.configureTimezone(MysqlaSession.java:293)
  150. com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:2399)
  151. com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1739)
  152. com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1596)
  153. com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:633)
  154. com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347)
  155. com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:219)
  156. java.sql.DriverManager.getConnection(Unknown Source)
  157. java.sql.DriverManager.getConnection(Unknown Source)
  158. org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:153)
  159. org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:144)
  160. org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:196)
  161. org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:159)
  162. org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
  163. org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
  164. org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106)
  165. org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
  166. org.hibernate.internal.SessionImpl.connection(SessionImpl.java:523)
  167. org.springframework.orm.hibernate5.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:448)
  168. org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
  169. org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:461)
  170. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:277)
  171. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  172. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  173. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
  174. com.sun.proxy.$Proxy31.checkLogin(Unknown Source)
  175. com.shiso.controllers.HomeController.index(HomeController.java:30)
  176. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  177. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  178. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  179. java.lang.reflect.Method.invoke(Unknown Source)
  180. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  181. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  182. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
  183. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  184. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  185. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  186. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
  187. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  188. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  189. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
  190. javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
  191. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  192. javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  193. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  194.  
  195. package com.shiso.init;
  196.  
  197. import org.springframework.context.MessageSource;
  198. import org.springframework.context.annotation.Bean;
  199. import org.springframework.context.annotation.ComponentScan;
  200. import org.springframework.context.annotation.Configuration;
  201. import org.springframework.context.support.ResourceBundleMessageSource;
  202. import org.springframework.web.servlet.config.annotation.EnableWebMvc;
  203. import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry;
  204. import org.springframework.web.servlet.config.annotation.ViewResolverRegistry;
  205. import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter;
  206. import org.springframework.web.servlet.view.InternalResourceViewResolver;
  207. import org.springframework.web.servlet.view.JstlView;
  208.  
  209. @Configuration
  210. @EnableWebMvc
  211. @ComponentScan(basePackages = "com.shiso")
  212. public class AppConfig extends WebMvcConfigurerAdapter
  213. {
  214. @Override
  215. public void configureViewResolvers(ViewResolverRegistry registry) {
  216.  
  217. InternalResourceViewResolver viewResolver = new InternalResourceViewResolver();
  218. viewResolver.setViewClass(JstlView.class);
  219. viewResolver.setPrefix("/WEB-INF/views/");
  220. viewResolver.setSuffix(".jsp");
  221. registry.viewResolver(viewResolver);
  222. }
  223.  
  224. @Override
  225. public void addResourceHandlers(ResourceHandlerRegistry registry) {
  226. registry.addResourceHandler("/resources/**").addResourceLocations("/WEB-INF/resources/theme1/");
  227. }
  228.  
  229. @Bean
  230. public MessageSource messageSource() {
  231. ResourceBundleMessageSource messageSource = new ResourceBundleMessageSource();
  232. messageSource.setBasename("messages");
  233. return messageSource;
  234. }
  235.  
  236.  
  237. }
  238.  
  239. package com.shiso.init;
  240.  
  241. import java.util.Properties;
  242.  
  243. import javax.sql.DataSource;
  244.  
  245. import org.hibernate.SessionFactory;
  246. import org.hibernate.boot.SchemaAutoTooling;
  247. import org.hibernate.cfg.AvailableSettings;
  248. import org.springframework.beans.factory.annotation.Autowired;
  249. import org.springframework.context.annotation.Bean;
  250. import org.springframework.context.annotation.ComponentScan;
  251. import org.springframework.context.annotation.Configuration;
  252. import org.springframework.context.annotation.PropertySource;
  253. import org.springframework.core.env.Environment;
  254. import org.springframework.jdbc.datasource.DriverManagerDataSource;
  255. import org.springframework.orm.hibernate5.HibernateTransactionManager;
  256. import org.springframework.orm.hibernate5.LocalSessionFactoryBean;
  257. import org.springframework.transaction.annotation.EnableTransactionManagement;
  258.  
  259. @Configuration
  260. @EnableTransactionManagement
  261. @ComponentScan({ "com.shiso.init" })
  262. @PropertySource(value = { "classpath:application.properties" })
  263. public class HibernateConfig
  264. {
  265. @Autowired
  266. private Environment environment;
  267.  
  268. @Bean
  269. public LocalSessionFactoryBean sessionFactory() {
  270. LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();
  271. sessionFactory.setDataSource(dataSource());
  272. sessionFactory.setPackagesToScan(new String[] { "com.shiso.model" });
  273. sessionFactory.setHibernateProperties(hibernateProperties());
  274. return sessionFactory;
  275. }
  276.  
  277. @Bean
  278. public DataSource dataSource() {
  279. DriverManagerDataSource dataSource = new DriverManagerDataSource();
  280. dataSource.setDriverClassName(environment.getRequiredProperty("jdbc.driverClassName"));
  281. dataSource.setUrl(environment.getRequiredProperty("jdbc.url"));
  282. dataSource.setUsername(environment.getRequiredProperty("jdbc.username"));
  283. dataSource.setPassword(environment.getRequiredProperty("jdbc.password"));
  284. return dataSource;
  285. }
  286.  
  287. private Properties hibernateProperties() {
  288. Properties properties = new Properties();
  289. properties.put("hibernate.dialect", environment.getRequiredProperty("hibernate.dialect"));
  290. properties.put("hibernate.show_sql", environment.getRequiredProperty("hibernate.show_sql"));
  291. properties.put("hibernate.format_sql", environment.getRequiredProperty("hibernate.format_sql"));
  292. properties.put(AvailableSettings.HBM2DDL_AUTO, SchemaAutoTooling.CREATE.name().toLowerCase());
  293. return properties;
  294. }
  295.  
  296. @Bean
  297. @Autowired
  298. public HibernateTransactionManager transactionManager(SessionFactory s) {
  299. HibernateTransactionManager txManager = new HibernateTransactionManager();
  300. txManager.setSessionFactory(s);
  301. return txManager;
  302. }
  303. }
  304.  
  305. jdbc.driverClassName=com.mysql.jdbc.Driver
  306. jdbc.url=jdbc:mysql://localhost:3306/shiso
  307. jdbc.username=user
  308. jdbc.password=password
  309. hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
  310. hibernate.show_sql=true
  311. hibernate.format_sql=true
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!