Doubt with configuration of oracle-ds.xml in $JBOSS_HOME/ser
ran_sushmi Jul 24, 2009 9:12 AMI 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