4 Replies Latest reply on Aug 1, 2009 11:49 AM by Peter Johnson

    Doubt with configuration of oracle-ds.xml in $JBOSS_HOME/ser

    randhir singh Newbie

      I have the following doubt with the configuration of oracle-ds.xml in $JBOSS_HOME/server/default/deploy. My doubt is that if I have a entry as follows in oracle-ds.xml:-

      --------------------------------------------------------------------------------------
      <local-tx-datasource>
      <jndi-name>DirectDBOracleDS</jndi-name>
      <connection-url>jdbc:oracle:thin:@10.10.10.26::orapdpc</connection-url>

      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>jispbilcorbillingprd501</user-name>
      jispbilcorbillingprd501
      jispbilcorbillingprd501
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      </local-tx-datasource>
      --------------------------------------------------------------------------------------

      Now, the database being pointed to will be the one with SID, 'orapdpc' on server with IP, 10.10.10.26. The tnsnames.ora entry in machine, 10.10.10.26 has entry like:

      --------------------------------------------------------------------------------------
      ORAPDPC =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.26)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orapdpc)
      )
      )
      --------------------------------------------------------------------------------------

      so, this should point to the dababase in the same machine. If the tnsnames.ora entry in machine, 10.10.10.26 was like:

      --------------------------------------------------------------------------------------
      ORAPDPC =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.2)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orapdpc)
      )
      )
      --------------------------------------------------------------------------------------

      then, this would have pointed to the database in the machine with IP, 10.10.10.2.

      Is, the observation correct or when we say in oracle-ds.xml,

      --------------------------------------------------------------------------------------
      <connection-url>jdbc:oracle:thin:@10.10.10.26::orapdpc</connection-url>
      --------------------------------------------------------------------------------------

      it would mean that it would always point to the database on machine with IP, 10.10.10.26.

      I hope, my question is clear.

      Please help in solving the doubt.

      Regards