File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Websphere and the fly likes WAS6.1.0.21 Oracle OCI Driver for connecting database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "WAS6.1.0.21 Oracle OCI Driver for connecting database" Watch "WAS6.1.0.21 Oracle OCI Driver for connecting database" New topic
Author

WAS6.1.0.21 Oracle OCI Driver for connecting database

Ramakanta Sahoo
Ranch Hand

Joined: Aug 23, 2008
Posts: 254

Hi All,

I want the oracle OCI driver to connect to Oracle database for OS authentication in WAS.

please let me know ehere can I get the OCI driver for Oracle.


Regards, Ricky
Oracle Weblogic 10g Certified Expert TechPaste.Com
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968
    
    1

You can usually find it alongside your Oracle installation.
Ramakanta Sahoo
Ranch Hand

Joined: Aug 23, 2008
Posts: 254

Thanks

but when I tried to configure it with WAS I am getting below error. What is the right procedure to put it in classpath.
Is it right to have a .so file or Is there any .jar file also available.

As when ever i added it into classpath WAS console is throwing below error

WAS console error
The test connection operation failed for data source Oracle JDBC Driver
DataSource on server server1 at node zone03 with the following
exception: java.sql.SQLException: java.lang.UnsatisfiedLinkError: no
ocijdbc10 in java.library.path. View JVM logs for further details.

cd /export/home/oracle/database/lib
libocijdbc10.so

This is the class path now
${ORACLE_JDBC_DRIVER_PATH}/ojdbc14.jar

How do we put this oci driver in class path. I tried with changing the env varible ORACLE_JDBC_DRIVER_PATH to /export/home/oracle/database/lib but it didnt work.

what could be the issue please help.


 
 
subject: WAS6.1.0.21 Oracle OCI Driver for connecting database