API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 30th, 2017
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.19 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="UTF-8"?>
  2.  
  3. <!-- ===================================================================== -->
  4. <!-- -->
  5. <!-- JBoss Server Configuration -->
  6. <!-- -->
  7. <!-- ===================================================================== -->
  8.  
  9. <!-- $Id: oracle-xa-ds.xml,v 1.13 2004/09/15 14:37:40 loubyansky Exp $ -->
  10.  
  11. <!-- ===================================================================== -->
  12. <!-- ATTENTION: DO NOT FORGET TO SET Pad=true IN transaction-service.xml -->
  13. <!-- ===================================================================== -->
  14.  
  15. <datasources>
  16. <local-tx-datasource>
  17. <jndi-name>KopdevDS2</jndi-name>
  18. <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  19. <user-name>kopdev</user-name>
  20.  
  21. DB DEV CH
  22. <connection-url>jdbc:oracle:thin:@kvm161.waw.eo.pl:1521:IT4EMCH</connection-url>
  23. <password>dXY9TxgF9sqeRNWk</password>
  24.  
  25. <!-- DB TEST
  26. <connection-url>jdbc:oracle:thin:@kvm224.waw.eo.pl:1521:WISETEST</connection-url>
  27. <password>dXY9TxgF9sqeRNWk</password> -->
  28.  
  29. <!-- DB UAT
  30. <connection-url>jdbc:oracle:thin:@kvm55.dpd.internal:1521:IT4EMCH</connection-url>
  31. <password>xFatCzid4yFMdfzN</password>-->
  32.  
  33. <!-- PRE PROD -->
  34. <connection-url>jdbc:oracle:thin:@10.51.98.25:1521:IT4EMCH</connection-url>
  35. <password>NnXRpxKgT9CbXjW7</password>
  36.  
  37. <!--
  38.  
  39. <security-domain>EncryptDBPasswordLocal</security-domain>
  40. -->
  41.  
  42. <min-pool-size>1</min-pool-size>
  43. <max-pool-size>300</max-pool-size>
  44. <idle-timeout-minutes>1</idle-timeout-minutes>
  45. <blocking-timeout-millis>1000</blocking-timeout-millis>
  46. <!--the number of prepared statements per connection to be kept open and reused in subsequent requests. They are stored in a LRU cache. The default is 0 (zero), meaning no cache.-->
  47. <!--prepared-statement-cache-size>100</prepared-statement-cache-size-->
  48. <!--with prepared statement cache enabled whether two requests in the same transaction should return the same statement (from jboss-4.0.2 - default false) -->
  49. <!--share-prepared-statements>true</share-prepared-statements-->
  50. <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
  51. <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  52. <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
  53. <metadata>
  54. <type-mapping>Oracle9i</type-mapping>
  55. </metadata>
  56. </local-tx-datasource>
  57. <xa-datasource>
  58. <jndi-name>KopdevDS</jndi-name>
  59.  
  60. <track-connection-by-tx/>
  61. <isSameRM-override-value>false</isSameRM-override-value>
  62. <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
  63. <xa-datasource-property name="User">kopdev</xa-datasource-property>
  64.  
  65. <!-- DB DEV CH
  66. <xa-datasource-property name="URL">jdbc:oracle:thin:@kvm161.waw.eo.pl:1521:IT4EMCH</xa-datasource-property>
  67. <xa-datasource-property name="Password">dXY9TxgF9sqeRNWk</xa-datasource-property> -->
  68.  
  69. <!-- DB TEST
  70. <xa-datasource-property name="URL">jdbc:oracle:thin:@kvm224.waw.eo.pl:1521:WISETEST</xa-datasource-property>
  71. <xa-datasource-property name="Password">dXY9TxgF9sqeRNWk</xa-datasource-property> -->
  72.  
  73. <!-- DB UAT
  74. <xa-datasource-property name="URL">jdbc:oracle:thin:@kvm55.dpd.internal:1521:IT4EMCH</xa-datasource-property>
  75. <xa-datasource-property name="Password">xFatCzid4yFMdfzN</xa-datasource-property> -->
  76.  
  77. <!-- PRE PROD -->
  78. <xa-datasource-property name="URL">jdbc:oracle:thin:@10.51.98.25:1521:IT4EMCH</xa-datasource-property>
  79. <xa-datasource-property name="Password">NnXRpxKgT9CbXjW7</xa-datasource-property>
  80.  
  81. <!--
  82.  
  83. <security-domain>EncryptDBPassword</security-domain>
  84. -->
  85.  
  86. <min-pool-size>1</min-pool-size>
  87. <max-pool-size>300</max-pool-size>
  88. <idle-timeout-minutes>1</idle-timeout-minutes>
  89. <blocking-timeout-millis>1000</blocking-timeout-millis>
  90. <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
  91. <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
  92. <!-- Checks the Oracle error codes and messages for fatal errors -->
  93. <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  94. <!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa -->
  95. <no-tx-separate-pools/>
  96.  
  97. <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
  98. <metadata>
  99. <type-mapping>Oracle9i</type-mapping>
  100. </metadata>
  101. </xa-datasource>
  102. <xa-datasource>
  103. <jndi-name>AuroraDS</jndi-name>
  104. <track-connection-by-tx/>
  105.  
  106. <isSameRM-override-value>false</isSameRM-override-value>
  107. <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
  108. <xa-datasource-property name="User">aurora</xa-datasource-property>
  109.  
  110. <!-- DB DEV CH -->
  111. <xa-datasource-property name="URL">jdbc:oracle:thin:@kvm161.waw.eo.pl:1521:IT4EMCH</xa-datasource-property>
  112. <xa-datasource-property name="Password">qi9rgrCtiXeARPkR</xa-datasource-property>
  113.  
  114.  
  115. <!-- UAT
  116. <xa-datasource-property name="URL">jdbc:oracle:thin:@kvm55.dpd.internal:1521:IT4EMCH</xa-datasource-property>
  117. <xa-datasource-property name="Password">dtRYqzw3jibVtqMc</xa-datasource-property> -->
  118.  
  119. <!--
  120.  
  121. <security-domain>EncryptDBPasswordA</security-domain>
  122. -->
  123.  
  124. <min-pool-size>1</min-pool-size>
  125. <max-pool-size>300</max-pool-size>
  126. <idle-timeout-minutes>1</idle-timeout-minutes>
  127. <blocking-timeout-millis>1000</blocking-timeout-millis>
  128.  
  129. <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
  130. <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
  131. <!-- Checks the Oracle error codes and messages for fatal errors -->
  132. <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  133. <!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa -->
  134. <no-tx-separate-pools/>
  135.  
  136. <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
  137. <metadata>
  138. <type-mapping>Oracle9i</type-mapping>
  139. </metadata>
  140. </xa-datasource>
  141. <xa-datasource>
  142. <jndi-name>GeoroutingDS</jndi-name>
  143. <track-connection-by-tx/>
  144.  
  145. <isSameRM-override-value>false</isSameRM-override-value>
  146. <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
  147. <xa-datasource-property name="URL">jdbc:oracle:thin:@kvm161.waw.eo.pl:1521:IT4EMCH</xa-datasource-property>
  148. <xa-datasource-property name="User">georouting</xa-datasource-property>
  149. <xa-datasource-property name="Password">CRuFXkgsFmqR9qMb</xa-datasource-property>
  150.  
  151. <min-pool-size>1</min-pool-size>
  152. <max-pool-size>300</max-pool-size>
  153. <idle-timeout-minutes>1</idle-timeout-minutes>
  154. <blocking-timeout-millis>1000</blocking-timeout-millis>
  155.  
  156. <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
  157. <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  158. <no-tx-separate-pools/>
  159. <metadata>
  160. <type-mapping>Oracle9i</type-mapping>
  161. </metadata>
  162. </xa-datasource>
  163. <mbean code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter"
  164. name="jboss.jca:service=OracleXAExceptionFormatter">
  165. <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends>
  166. </mbean>
  167.  
  168. </datasources>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!