I am using the following Oracle datasource configuration:
<local-tx-datasource>
<jndi-name>securityPool</jndi-name>
<connection-url>jdbc:oracle:thin:@10.10.1.2:1521:DB1</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>username</user-name>
password
<min-pool-size>${dbpool.minSize}</min-pool-size>
<max-pool-size>${dbpool.maxSize}</max-pool-size>
<idle-timeout-minutes>${dbpool.idleTimeoutMinutes}</idle-timeout-minutes>
<blocking-timeout-millis>${dbpool.blockingTimeoutMillis}</blocking-timeout-millis>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
Which works great - the system properties for the given settings work (minSize, maxSize, etc.). However, if I try to configure user name, password, or connection url using properties they are not used. Any reason why this is? What class is responsible for reading this file (in case I need to make some tweaks)?
Thanks,
-Aaron