From: Igor F. <ife...@th...> - 2002-09-23 14:33:29
|
Jon Haugsand wrote: > 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? > Use "jdbc:oracle:thin:@banklab3:1521:ora8" for "thin" (type 4) jdbc driver or "jdbc:oracle:oci8:@<host string>" for "oci8" (type2) jdbc driver. Later needs $ORACLE_HOME/bin on a PATH (or LD_LIBRARY_PATH). Two other things to mention. With oracle 8i I had to upgrate to 8.1.7.3 to get things working, make sure that both server and client are upgraded. Also, check bug 585632 on SF, you most likely need to get jboss-jdbc-oracle.zip patch from there. -- Igor Fedorenko Think smart. Think automated. Think Dynamics. www.thinkdynamics.com |