0 Replies Latest reply on May 23, 2003 11:34 AM by as6o

    Using system properties to config. datasource?

    as6o

      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>$&#123dbpool.minSize&#125</min-pool-size>
      <max-pool-size>$&#123dbpool.maxSize&#125</max-pool-size>
      <idle-timeout-minutes>$&#123dbpool.idleTimeoutMinutes&#125</idle-timeout-minutes>
      <blocking-timeout-millis>$&#123dbpool.blockingTimeoutMillis&#125</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