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

Reply via email to