Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

WAS6.1.0.21 Oracle OCI Driver for connecting database

 
Ramakanta Sahoo
Ranch Hand
Posts: 255
Fedora Firefox Browser Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can usually find it alongside your Oracle installation.
 
Ramakanta Sahoo
Ranch Hand
Posts: 255
Fedora Firefox Browser Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.


 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic