Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <datasource jndi-name="java:/oracleDBOld" pool-name="oracleDBOld" enabled="true" jta="true" use-java-context="true" use-ccm="true">
- <connection-url>
- jdbc:oracle:thin:@infraora01-prd.lmig.com:1522:OIN04P
- </connection-url>
- <connection-property name="oracle.jdbc.RetainV9LongBindBehavior">
- true
- </connection-property>
- <driver>
- oracle
- </driver>
- <pool>
- <min-pool-size>
- 0
- </min-pool-size>
- <max-pool-size>
- 300
- </max-pool-size>
- <prefill>
- false
- </prefill>
- <use-strict-min>
- false
- </use-strict-min>
- <flush-strategy>
- FailingConnectionOnly
- </flush-strategy>
- </pool>
- <security>
- <security-domain>
- oracleDBOld-domain
- </security-domain>
- </security>
- <validation>
- <check-valid-connection-sql>
- select 1 from dual
- </check-valid-connection-sql>
- <validate-on-match>
- false
- </validate-on-match>
- <background-validation>
- false
- </background-validation>
- <background-validation-millis>
- 0
- </background-validation-millis>
- <use-fast-fail>
- false
- </use-fast-fail>
- </validation>
- <timeout>
- <blocking-timeout-millis>
- 5000
- </blocking-timeout-millis>
- <idle-timeout-minutes>
- 1
- </idle-timeout-minutes>
- </timeout>
- </datasource>
- config = new Configuration();
- config.setProperty("hibernate.connection.datasource", (isOldNodeOrDesktop ? "java:comp/env/jdbc/oracleDBOld" : "java:/oracleDBOld"));
- config.setProperty("hibernate.show_sql", (isDesktop ? "true" : "false"));
- config.setProperty("hibernate.dialect", "org.hibernate.dialect.Oracle9Dialect");
- config.setProperty("hibernate.query.substitutions", "true 1, false 0");
- config.setProperty("hibernate.cache.use_second_level_cache", "true");
- config.setProperty("hibernate.cache.use_query_cache", "true");
- config.setProperty("hibernate.cache.provider_class", "org.hibernate.cache.EhCacheProvider");
- config.setProperty("hibernate.generate_statistics", "false");
- config.setProperty("hibernate.cache.use_structured_entries", "false");
- // Domain class mappings
- config.addClass(com.lmig.requestit.domain.ApplicationGroup.class);
- config.addClass(com.lmig.requestit.domain.EIPAGApplication.class);
- config.addClass(com.lmig.requestit.domain.EIPAGApplicationEmail.class);
- config.addClass(com.lmig.requestit.domain.EmergencyAccessApplication.class);
- config.addClass(com.lmig.requestit.domain.EmergencyAccessApprover.class);
- config.addClass(com.lmig.requestit.domain.EmergencyAccessLNWUser.class);
- config.addClass(com.lmig.requestit.domain.EmergencyAccessNode.class);
- config.addClass(com.lmig.requestit.domain.EmergencyAccessPlatform.class);
- config.addClass(com.lmig.requestit.domain.EmergencyAccessRole.class);
- config.addClass(com.lmig.requestit.domain.EmergencyAccessSBU.class);
- config.addClass(com.lmig.requestit.domain.EmergencyAccessSysgroup.class);
- config.addClass(com.lmig.requestit.domain.EmergencyAccessUser.class);
- config.addClass(com.lmig.requestit.domain.EmergencyAccessUserAccess.class);
- config.addClass(com.lmig.requestit.domain.WindowsNode.class);
- config.addClass(com.lmig.requestit.domain.UnixNode.class);
- // Mapping not aligned with any domain classes; contains SQL
- // queries
- config.addResource("oldOracleDB_queries.hbm.xml");
- // Build SessionFactory
- RequestITHibernateOldDBUtils.setSessionFactory(config.buildSessionFactory());
Add Comment
Please, Sign In to add comment