jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes OCI help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "OCI help " Watch "OCI help " New topic
Author

OCI help

Asad Tungeker
Greenhorn

Joined: Jul 04, 2002
Posts: 3
I have successfully ran OCI:8 driver test on my local
development environment using 8.1.7 driver to conect to Oracle
9i. However, when I transferred the same configuration to app
server, I get a sql exception to connect using OCI:8 driver.
While debugging the classPath, I noticed
1.
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/oracle/app/oracle/product/8
.1.7/ctx/lib, but the ctx folder does not exist in the path
defined above,
2. PATH=$PATH:$ORACLE_HOME/bin
DO I NEED TO ADD the following: $ORACLE_HOME/ctx/bin in the
path ?
libocijdbc8.so driver exist in,
/opt/oracle/app/oracle/product/8.1.7/lib/libocijdbc8.so , and it
is in the classpath but for some reason the application keeps
looking for ocijdbc9.so files. Do I need to replace the
classes12.zip with an older version ??

Error string
[03.02.04 12:53:33:262 CST] ae8e9b ServletInstan X Uncaught
init() exception thr
own by servlet {0}: {1}
"action"
javax.servlet.ServletException:
no ocijdbc9 in
java.library.path
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at
javax.servlet.ServletException.<init>(ServletException.java:161)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doInit(Servle
tMan
ager.java:635)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._init(Strict
Life
cycleServlet.java:136)


Courage does'nt always roar.Sometimes courage is the little voice at the end of the day that says,"I'll try again tomorrow".
 
Consider Paul's rocket mass heater.
 
subject: OCI help
 
Similar Threads
WebLogic6.1/Oracle8.1.6 config problem (obvious to someone?)
WLS 7.0 sp2 with Oracle 8.1.7 on solaris 8
OCI HELP
Calling a Java Program through CRONTAB
Error Using JDrivers to Connect to Oracle