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)