Hi all!
I'm trying to install the OCI drivers from oracle, because the thin ones doesn't support fail-over or load-balancing.
The platform is a Jboss 4.0.2 as MQ server, running on RedHat AS 3.1 (64-bit). I've installed the oci drivers (*so) in /lib64/oci, added this path to ld.so.conf and ran ldconfig. Defining some environement variables like LD_LIBRARY_PATH, SQLPATH, and TNS_ADMIN, I've got a succesful conection to a RAC using sqlplus with a tnsnames.ora file.
So I think that the oci drivers are correctly installed in the RedHat OS, but when trying to use this OCI connection with Jboss on a datasource, I get:
--------------------------
Error handling message : Unexpected throwable while trying to create a connection: null; - nested throwable: (java.lang.reflect.UndeclaredThrowableException);
--------------------------
It seems that JBoss doesn't find the *so files, but when I call the JVM (1.5.0_04 from sun) with this parameters:
-Djava.library.path=/lib64/oci/: and all the other default paths
Someone knows how oci drivers need to be installed to work with jboss ?
Thanks!