Guest User

Untitled

a guest
Jan 31st, 2018
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.42 KB | None | 0 0
  1. <datasource jndi-name="java:/oracleDBOld" pool-name="oracleDBOld" enabled="true" jta="true" use-java-context="true" use-ccm="true">
  2. <connection-url>
  3. jdbc:oracle:thin:@infraora01-prd.lmig.com:1522:OIN04P
  4. </connection-url>
  5. <connection-property name="oracle.jdbc.RetainV9LongBindBehavior">
  6. true
  7. </connection-property>
  8. <driver>
  9. oracle
  10. </driver>
  11. <pool>
  12. <min-pool-size>
  13. 0
  14. </min-pool-size>
  15. <max-pool-size>
  16. 300
  17. </max-pool-size>
  18. <prefill>
  19. false
  20. </prefill>
  21. <use-strict-min>
  22. false
  23. </use-strict-min>
  24. <flush-strategy>
  25. FailingConnectionOnly
  26. </flush-strategy>
  27. </pool>
  28. <security>
  29. <security-domain>
  30. oracleDBOld-domain
  31. </security-domain>
  32. </security>
  33. <validation>
  34. <check-valid-connection-sql>
  35. select 1 from dual
  36. </check-valid-connection-sql>
  37. <validate-on-match>
  38. false
  39. </validate-on-match>
  40. <background-validation>
  41. false
  42. </background-validation>
  43. <background-validation-millis>
  44. 0
  45. </background-validation-millis>
  46. <use-fast-fail>
  47. false
  48. </use-fast-fail>
  49. </validation>
  50. <timeout>
  51. <blocking-timeout-millis>
  52. 5000
  53. </blocking-timeout-millis>
  54. <idle-timeout-minutes>
  55. 1
  56. </idle-timeout-minutes>
  57. </timeout>
  58. </datasource>
  59.  
  60. config = new Configuration();
  61.  
  62. config.setProperty("hibernate.connection.datasource", (isOldNodeOrDesktop ? "java:comp/env/jdbc/oracleDBOld" : "java:/oracleDBOld"));
  63. config.setProperty("hibernate.show_sql", (isDesktop ? "true" : "false"));
  64. config.setProperty("hibernate.dialect", "org.hibernate.dialect.Oracle9Dialect");
  65. config.setProperty("hibernate.query.substitutions", "true 1, false 0");
  66. config.setProperty("hibernate.cache.use_second_level_cache", "true");
  67. config.setProperty("hibernate.cache.use_query_cache", "true");
  68. config.setProperty("hibernate.cache.provider_class", "org.hibernate.cache.EhCacheProvider");
  69. config.setProperty("hibernate.generate_statistics", "false");
  70. config.setProperty("hibernate.cache.use_structured_entries", "false");
  71.  
  72. // Domain class mappings
  73. config.addClass(com.lmig.requestit.domain.ApplicationGroup.class);
  74. config.addClass(com.lmig.requestit.domain.EIPAGApplication.class);
  75. config.addClass(com.lmig.requestit.domain.EIPAGApplicationEmail.class);
  76. config.addClass(com.lmig.requestit.domain.EmergencyAccessApplication.class);
  77. config.addClass(com.lmig.requestit.domain.EmergencyAccessApprover.class);
  78. config.addClass(com.lmig.requestit.domain.EmergencyAccessLNWUser.class);
  79. config.addClass(com.lmig.requestit.domain.EmergencyAccessNode.class);
  80. config.addClass(com.lmig.requestit.domain.EmergencyAccessPlatform.class);
  81. config.addClass(com.lmig.requestit.domain.EmergencyAccessRole.class);
  82. config.addClass(com.lmig.requestit.domain.EmergencyAccessSBU.class);
  83. config.addClass(com.lmig.requestit.domain.EmergencyAccessSysgroup.class);
  84. config.addClass(com.lmig.requestit.domain.EmergencyAccessUser.class);
  85. config.addClass(com.lmig.requestit.domain.EmergencyAccessUserAccess.class);
  86. config.addClass(com.lmig.requestit.domain.WindowsNode.class);
  87. config.addClass(com.lmig.requestit.domain.UnixNode.class);
  88.  
  89. // Mapping not aligned with any domain classes; contains SQL
  90. // queries
  91. config.addResource("oldOracleDB_queries.hbm.xml");
  92.  
  93. // Build SessionFactory
  94. RequestITHibernateOldDBUtils.setSessionFactory(config.buildSessionFactory());
Add Comment
Please, Sign In to add comment