Advertisement
Guest User

Untitled

a guest
Apr 7th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.02 KB | None | 0 0
  1. @Configuration
  2. @EnableTransactionManagement
  3. @ComponentScan(basePackages = { "com.arg.utility.hibernate" })
  4. @PropertySource(value = { "classpath:application.properties" })
  5. public class HibernateConfigWS {
  6.  
  7. @Bean
  8. public LocalSessionFactoryBean sessionFactoryWS() throws SQLException, NamingException {
  9. LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();
  10. sessionFactory.setDataSource(dataSourceWS());
  11. sessionFactory.setPackagesToScan(new String[] { "com.arg.utility.hibernate.entity.ws.model" });
  12. sessionFactory.setHibernateProperties(hibernateProperties());
  13. return sessionFactory;
  14. }
  15.  
  16.  
  17. @Bean
  18. @Lazy
  19. public DataSource dataSourceWS() throws SQLException, NamingException {
  20. InitialContext initContext = new InitialContext();
  21. DataSource ds = null;
  22. try{
  23. ds = (DataSource)initContext.lookup(System.getProperty(UtilityConstants.JNDI_WS_DATASOURCE));
  24. }catch(Exception e){
  25. LOGGER.error("Wallet Server Datasource lookup failed :"+e.getStackTrace());
  26. }
  27. return ds;
  28. }
  29.  
  30.  
  31. @Bean
  32. public HibernateTransactionManager transactionManagerWS(SessionFactory sessionFactoryWS) {
  33. HibernateTransactionManager txManager = new HibernateTransactionManager();
  34. txManager.setSessionFactory(sessionFactoryWS);
  35. return txManager;
  36. }
  37.  
  38. //----------------------HIBERNATE COMMON PROPERTIES CONFIG---------------------//
  39. /**
  40. *
  41. * @return properties object
  42. */
  43. private Properties hibernateProperties() {
  44. Properties properties = new Properties();
  45. properties.put("hibernate.dialect", environment.getRequiredProperty("hibernate.dialect"));
  46. properties.put("hibernate.show_sql", "false");
  47. properties.put("hibernate.format_sql", environment.getRequiredProperty("hibernate.format_sql"));
  48. /*properties.put("hibernate.connection.provider_class", "org.hibernate.c3p0.internal.C3P0ConnectionProvider"); // commented
  49. properties.put("hibernate.c3p0.min_size", "5"); // commented
  50. properties.put("hibernate.c3p0.max_size", "20"); // commented
  51. properties.put("hibernate.c3p0.timeout", "1800"); // commented
  52. properties.put("hibernate.c3p0.max_statements", "50");*/ // commented
  53. return properties;
  54. }
  55.  
  56. }
  57.  
  58. <datasource jndi-name="java:/WSDataSource" pool-name="WSDataSource" enabled="true" use-java-context="true">
  59. <connection-url>jdbc:mysql://dshost:3306/ds_name</connection-url>
  60. <connection-property name="zeroDateTimeBehavior">
  61. convertToNull
  62. </connection-property>
  63. <driver>com.mysql</driver>
  64. <pool>
  65. <min-pool-size>0</min-pool-size>
  66. <max-pool-size>10</max-pool-size>
  67. <prefill>true</prefill>
  68. </pool>
  69. <security>
  70. <user-name>abc</user-name>
  71. <password>abc@123</password>
  72. </security>
  73. <validation>
  74. <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
  75. <validate-on-match>false</validate-on-match>
  76. <background-validation>true</background-validation>
  77. <background-validation-millis>30000</background-validation-millis>
  78. <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
  79. </validation>
  80. </datasource>
  81.  
  82. <<< ServerService Thread Pool -- 68:2017/04/07 16:20:54.676:org.springframework.web.context.ContextLoader::::: Context initialization failed >>>
  83. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerWS' defined in com.ugowallet.utility.hibernate.config.HibernateConfigWS: Invocation of init method failed; nested exception is org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap to requested type [javax.sql.DataSource]
  84. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1628)
  85. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
  86. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
  87. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
  88. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  89. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
  90. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
  91. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
  92. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866)
  93. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
  94. at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)
  95. at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)
  96. at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
  97. at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)
  98. at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:198)
  99. at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:100)
  100. at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
  101. at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
  102. at java.util.concurrent.FutureTask.run(Unknown Source)
  103. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  104. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  105. at java.lang.Thread.run(Unknown Source)
  106. at org.jboss.threads.JBossThread.run(JBossThread.java:320)
  107. Caused by: org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap to requested type [javax.sql.DataSource]
  108. at org.hibernate.engine.jdbc.connections.internal.UserSuppliedConnectionProviderImpl.unwrap(UserSuppliedConnectionProviderImpl.java:55)
  109. at org.springframework.orm.hibernate4.SessionFactoryUtils.getDataSource(SessionFactoryUtils.java:106)
  110. at org.springframework.orm.hibernate4.HibernateTransactionManager.afterPropertiesSet(HibernateTransactionManager.java:356)
  111. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687)
  112. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624)
  113. ... 22 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement