RE: [JBoss-user] JBoss 3.0.1 and Oracle-XA

[Finn, M. <mic...@fr...>]

Jon,

What driver are you trying to use? oci or thin? Your URL is a mix of both:
jdbc:oracle:oci8:@ --> OCI driver
banklab3:1521:ora8 --> Thin driver

If you are going to use the OCI driver (a type 2 driver):
1) You will need an install of the Oracle client software
2) You will need Oracle libs (not jars) in your lib path (not classpath)
3) Your URL points at a tnsnames entry, not a host:port pair.

If you are going to use thin driver (type 4):
You need classes12.zip in your classpath (like
$JBOSS/server/{yourconfig}/lib).

If you want to use the thin driver, your URL will be something like:
jdbc:oracle:thin:@banklab3:1521:ora8

(change "oci8" to thin)

HTH,
Mike


-----Original Message-----
From: Jon Haugsand [mailto:Jon...@no...]
Sent: Monday, September 23, 2002 10:07 AM
To: jbo...@li...
Subject: [JBoss-user] JBoss 3.0.1 and Oracle-XA



I am trying to get Oracle-XA to work with JBoss 3.0.1, by doing the
following:

 1. I copy the docs/examples/jca/oracle-xa-service.xml
 2. I change the line with URL=jdbc:oracle:oci8:@tc
    to URL=jdbc:oracle:oci8:@banklab3:1521:ora8
 3. I insert username and password
 4. I include an <attribute  name="Pad">true</attribute> into
    jboss-service.xml


It looks like the mbean is registrated, but I get error message that
complain with "no ocijdbc8 in java.library.path"

 I assume no 2 above is not correct.  But how should the URL be then?

-- 
  Jon Haugsand, <Jon...@no...>
  Norges Bank, <http://www.norges-bank.no>



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
JBo...@li...
https://lists.sourceforge.net/lists/listinfo/jboss-user