and anything using OCI (like the oracle native drivers). But this is the thin driver, so that it doesn't need tnsnames to connect. However, if JBoss is on a separate host than the Oracle DBMS it may need the tnsnames. I don't know JBoss, but I do know that iAS (iPlanet) required it.
Perhaps this would be better answered on the JBoss list.... https://lists.sourceforge.net/lists/listinfo/jboss-user --- Jason Carlamere <[EMAIL PROTECTED]> wrote: > > 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 > ____________________________________________________ ===== Mark Zawadzki Performance Engineer/DBA/Programmer extraordinaire� [EMAIL PROTECTED] [EMAIL PROTECTED] "Democracies die behind closed doors," - Judge Damon Keith __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ ____________________________________________________ To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm Be respectful! Clean up your posts before replying ____________________________________________________
