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

[peterj]

I do not think that the Oracle JDBC driver uses the tnsnames.ora file. Whatever IP address or hostname you provide in the connection URL is what the JDBC driver will use to connect to the database.

[peterj]

A Google search yielded this page which shows how to set up the connection URL to use the tnsnames.ora file:

http://media.datadirect.com/download/docs/jdbc/alljdbc/reference/jdbcoracle8.html

[ran_sushmi]

thanks, for your answer. So when we say,

--------------------------------------------------------------------------------------
<connection-url>jdbc:oracle:thin:@10.10.10.26::orapdpc</connection-url>
--------------------------------------------------------------------------------------
we can be sure that the database has to be on machine 10.10.10.26 and not anywhere else.

Regards

[peterj]

If the connection URL contains the IP address 10.10.10.26, then that IP address is passed to the JDBC driver. What the JDBC driver does with it you will have the ask the JDBC driver vendor. For most JDBC drivers, they will connect to the database (or perhaps some database server software) on 10.10.10.26. Where the actual data resides is up to the database.

Most of the time, the database will reside on 10.10.10.26.