• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

WAS6.1.0.21 Oracle OCI Driver for connecting database

 
Ranch Hand
Posts: 256
Netbeans IDE Firefox Browser Fedora
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
author and cow tipper
Posts: 5009
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You can usually find it alongside your Oracle installation.
 
Ramakanta Sahoo
Ranch Hand
Posts: 256
Netbeans IDE Firefox Browser Fedora
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.


 
No more fooling around. Read this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic