-
1. Re: JBOSS 4.3 EAP NOT PICKING UP TNSNAMES.ORA
peterj Nov 9, 2009 10:51 AM (in response to scubie999)JBoss AS simply passes the connection URL to the JDBC driver - it is the driver that makes the database connection. Does the Oracle JDBC driver you are using support the "jdbc:oracle:oci:@ORCL" connection URL?
-
2. Re: JBOSS 4.3 EAP NOT PICKING UP TNSNAMES.ORA
scubie999 Nov 9, 2009 11:13 AM (in response to scubie999)Hi Peter
Yes, oci has been installed.
The following connect descriptor:
<connection-url>jdbc:oracle:oci:@(description=(address=(host=hostname)(protocol=tcp)(port=1521))(connect_data=(sid=ORCL)))</connection-url>
also works.
This seems to me to be a matter of the location of the tnsnames.ora file. It is as if JBOSS expects it elsewhere...? Other than the normal $ORACLE_HOME/network/admin
Carlo -
3. Re: JBOSS 4.3 EAP NOT PICKING UP TNSNAMES.ORA
peterj Nov 9, 2009 12:13 PM (in response to scubie999)It has nothing to do with JBoss AS. It is the JDBC driver that makes the connection. Can the driver find the necessary files? How do you tell the driver where to look to find those files? All of that should be in the documentation for the Oracle JDBC driver you are using.