The OCI drivers use the native Oracle SQL*Net client,
so you must have that installed.
//Nicholas
--- Kimball Larsen <[EMAIL PROTECTED]>
wrote:
> 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
=====
Nicholas Whitehead
Home: (973) 377 9335
Cell: (973) 615 9646
[EMAIL PROTECTED]
Laugh your pants off with Lionel at eYada.com.
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
