[jboss-user] [Installation, Configuration & DEPLOYMENT] - Doubt with configuration of oracle-ds.xml in $JBOSS_HOME/ser

[ran_sushmi]

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  

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4245836#4245836

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4245836