I believe that tnsnames.ora would only be used if connecting to the
database via sqlplus
sqlplus user/pass@workitem
Without the wind, the grass does not move. Without software, networks and
hardware are useless
"Cohan, Sean"
<SCohan To: "JDJList"
<[EMAIL PROTECTED]>
@goSPS.com> cc:
Subject: [jdjlist] Trying to Connect to
Oracle
10/23/2002
10:36 AM
Please
respond to
"JDJList"
We're trying to connect to an Oracle DB, but I haven't gotten it down yet.
I have the database (SID = WORKITEM) installed on a Win2K server
(bxatest2.)
We're running Jboss 3.0.3 on a second PC. The URL connect string we're
using in our oracle-xa-service.xml file:
<config-property name="XADataSourceProperties" type="java.lang.String">
URL=jdbc:oracle:thin@bxatest2:1521:WORKITEM
</config-property>
but getting the following error:
09:48:05,920 ERROR [STDERR] java.sql.SQLException: Unable to get
Connection:
javax.resource.ResourceException: Unable to create DB XAConnection:
java.sql.SQLException: Invalid Oracle URL specified
I'm a little confused on where and how tnsnames.ora should be specified.
On
the server, bxatest2, we have a tnsnames.ora file in
c:\oracle\ora81\netword\admin with a connect string as:
WORKITEM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = bis.doc.gov)
(PROTOCOL = TCP)
(Host = 192.186.217.246)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = WORKITEM)
)
)
We don't have on the PC running JBoss. Do we need one there and therefore
Oracle client installed there?
Originally I had the following entry on bxatest2:
workitem.bis.doc.gov =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = bis.doc.gov)
(PROTOCOL = TCP)
(Host = 192.186.217.246)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = WORKITEM)
)
)
In the oracle-xa-service.xml file in this case, should we have:
<config-property name="XADataSourceProperties" type="java.lang.String">
URL=jdbc:oracle:thin@bxatest2:1521:workitem.bis.doc.gov
</config-property>
Lastly, how and where do we specify the user id and password to connect to
the DB as?
Thanks.
____________________________________________________
To change your JDJList options, please visit:
http://www.sys-con.com/java/list.cfm
Be respectful! Clean up your posts before replying
____________________________________________________
____________________________________________________
To change your JDJList options, please visit:
http://www.sys-con.com/java/list.cfm
Be respectful! Clean up your posts before replying
____________________________________________________
