Hello all -
I have searched the archives of this list, but have been unable to
find an answer to my particular problem. First, some background:
Operating System: Redhat Linux 7.1
jBoss Version: 2.2.2 - with integrated Tomcat
Oracle 8i (8.1.7) on a remote Redhat server
I have set up jBoss to use the oracle thin drivers just fine, but my
boss insists that the oci drivers perform much more efficiently, and we
want to use the oci instead of thin. I altered the connection url in
the jboss.jcml to look like this:
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=OracleDB">
<attribute name="PoolName">DefaultDS</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="URL">jdbc:oracle:oci8:@[attribute from my
tnsnames.ora file]</attribute>
<attribute name="JDBCUser">[username]</attribute>
<attribute name="Password">[password]</attribute>
</mbean>
Everytime I try to start jBoss, I get the following error:
java.lang.UnsatisfiedLinkError: no ocijdbc8 in java.library.path
I have scoured the web looking for a solution, and have found that I
need to set the LD_LIBRARY_PATH to include the location of my
classes12.zip drivers from Oracle. I have done this. I have also added
classes12.zip to my CLASSPATH, and I have even gone so far as to extract
classes12.zip to a directory and add the oci directory to my CLASSPATH.
I have also put classes12.zip into my /lib/ext/ directory in jBoss - all
with the same results.
Has anyone else had problems getting the oci drivers to work? Any
suggestions would be great!
-Kimball Larsen
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user