Skip to content

Instantly share code, notes, and snippets.

@nagetsum
Last active July 13, 2020 02:53
Show Gist options
  • Save nagetsum/4f5a8f7754f0859f5d18ff9294728335 to your computer and use it in GitHub Desktop.
Save nagetsum/4f5a8f7754f0859f5d18ff9294728335 to your computer and use it in GitHub Desktop.
<datasource jndi-name="java:jboss/datasources/OracleDS" pool-name="OracleDS">
<connection-url>jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=BROKEN)(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCLCDB.localdomain)))</connection-url>
<connection-property name="oracle.jdbc.ReadTimeout">
310000
</connection-property>
<driver>oracle</driver>
<pool>
<min-pool-size>20</min-pool-size>
<initial-pool-size>20</initial-pool-size>
<max-pool-size>20</max-pool-size>
<prefill>true</prefill>
</pool>
<security>
<user-name></user-name>
<password></password>
</security>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
<validate-on-match>true</validate-on-match>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
</validation>
</datasource>
...
<drivers>
<driver name="oracle" module="com.oracle">
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
</driver>
</drivers>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment